Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Linked records in Form needs to show 2 fields

203 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a dropdown menu in a form that is linking to another table. The other table has dates and a label for each date. I need the dropdown menu to show both the date and the label for the user. It currently only shows the date in the preview.

1 Reply 1

Airtable forms are fairly limited. When people use the form they only see the primary field value for the linked record choices. If you want to show more information, you have to include that info in the primary field.

One solution is to move your date to a different field other than the primary field. Then turn your primary field into a formula field that combines the date and the label. You might want to use DATETIME_FORMAT()for the date field in your primary field formula. It is documented in the formula field reference.