Mar 17, 2023 03:31 PM
I have a form within a table. This form has a field that's a link to record type - City. When I view this field +Add City, it shows me the City and the State so I know the context. This works within the Airtable app only. If I share this form and then want to +Add City, it doesn't show me the City and State so the context is lost. I have two cities with the same name but I don't know which state so I can't pick the right one.
How do I see the same pop-up modal with City AND State view that I see when I am in the Airtable app? I am just choosing the City and the state is auto filled but the user needs to see the State so they know which City to Add.
Mar 18, 2023 12:54 AM
I'm afraid you can't do that. The workaround people usually use is to make the primary field a formula field that displays all the information you want the user to have in the form
Within your context, you would:
1. Duplicate the "City" field
2. Convert the primary field to a "Formula" field with a formula like: `{City} & " - " & {State}`, so that the primary field shows both pieces of information
Mar 18, 2023 01:18 PM
Hmmm. how would I make that a look up so the user selects the "City" only? and it fills in the city field? I am trying to think through how I could make it work - its not coming to me right now 🙂
Mar 18, 2023 11:37 PM
Could you provide screenshots of what you're seeing after you tried out what I suggested and screenshots of what you'd like to see instead please?
Mar 28, 2023 07:06 PM
This is the form editor view where you can see the City (AND State) even though I use City field.
In this form view (sharing) mode, that I want to people to select City, you can see that only the City shows up and not the state so if I type "Las Vegas", I have two of them - don't know which one to choose