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.
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.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.