Skip to main content

Working with addresses

  • July 10, 2023
  • 1 reply
  • 23 views

Forum|alt.badge.img+2

Hello,

I'm recording international transport orders in Airtable, which require an origin and destination location at the city level. I have linked tables with cities, states/provinces, and countries, just like the CRM template by AirTable. When using a form view directly on the base table, I just add the City and the picker will display the related states and countries.  I also created a form as an interface, but the city picker won't show other fields from the City table. Is there a way to show other data associated with the City when selecting it in an Interface form?

1 reply

TheTimeSavingCo
Forum|alt.badge.img+28

I'm afraid not.  The known workaround for this involves converting the primary field of the "City" table to be a formula field that displays all the information you'd like your form users to see.  Doesn't look terribly nice, but it gets the job done!


Reply