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.
+29Airtable 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.
+35
2025 Update:
Airtable’s new form builder now lets you choose which fields you want to display in the linked record field dropdown menu.
However, this feature is relatively limited, because it only gives you a limited amount of horizontal space, and it will cut off fields if you add too many fields.
The easiest & better alternative is to use Fillout’s advanced forms for Airtable, which lets you display as many different fields as you want — including attachment fields — in the linked record dropdown menu, and it never cuts off the fields! I show off this feature on this episode of the BuiltOnAir podcast.
You can even display lookup fields on your form as well, so as soon as the user chooses a linked record field, all the values that you want to display onscreen can show up.
But more importantly, Fillout is 100% free and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update records from a form, display Airtable lookup fields on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.