Forum Discussion

JenBlack's avatar
Qrew Member
2 years ago

Metro Area Field

I am trying to figure out a good way to simplify user searching for client headquarter locations. I currently have an open text field allowing users to enter HQ location, however this allows a lot of discrepancies in the way users are entering data. One example of this could be entering data for Kansas City could look like this:

  • KCMO
  • Kansas City, Missouri
  • Kansas City, MO
  • Kansas City
I don't want to have an entire address field because we don't need it and it takes up too much space on my form.

One solution I thought about was to create a multiple choice field populated with most major cities and states our clients reside in, but allowing users the option of adding choices so we would at least have some consistency in formatting but I wanted to throw the idea out to the community and see if anyone else had run into/solved this problem as well.


Jen Black

1 Reply

  • DwightMunson1's avatar
    Qrew Assistant Captain
    1. I would set up a table for this data. 
    2. Create a HQ dropdown (MC) in the original table, and make the new table the source for the values.

    Dwight Munson