Allow Form User to Reference/Lookup/Link a non-Primary field?

Hello!

I am creating a form for a table (let’s call it Table A) which has fields linking to another table (table B) in the same base.

When filling out the field on the form on Table A, the user can only see the data in the primary field of Table B. However many of the records in Table B have similar primary field data making them difficult to distinguish. Being able to see one (or multiple) of the other fields would be really helpful.

For the time being, I’ve made the primary field on Table B a formula that merges the most helpful relevant fields from that table, but it makes all my Table B views very messy/ugly. I wish this formula could be in a non-primary field so I could hide it, but then my Table A form wouldn’t show it.

Please tell me there’s something stupidly easy I’m missing! Is there a way for a form to reference/show any thing BUT the primary data? Or is there a workaround I can use with another table?

Cheers,
Nathan

Welcome to the community, @Nathan_Renner-Johns1!

Unfortunately, you are not missing anything. Sadly, this is one of the many many limitations in Airtable. Every area of the product has major flaws & limitations like this, and it’s also useless for us to ask Airtable to improve these things — they literally do not listen to our feedback at all. They are deaf to their users’ real-world needs.

You might be able to accomplish what you’re looking for with the MiniExtensions form, but I’m not 100% sure. @Moe would be able to tell you if this is possible:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.