Data linked between table

[Julien]

Hello,

I use Airtable to build a simple CRM.

I have a table dedicated to the client companies. (PF = String)
I have a table dedicated to the contacts belonging to these companies. (PF = Autonumber…I do not have an email or a phone number for each contact)
I have a table dedicated to deals (PF = String)

A deal is linked to a company and a contact.

I would like to be able to select a contact in my deal table, belonging to the company to which the deal is linked.

In my deal table I can easily display the name of the company, which comes from the customer company table.

However, when I want to choose a contact, I can only look for it by its contact_id (PF contact table)…

Except that I have 2000 and I can’t know by heart the id of each customer…
I would like to be able to choose the customer by his, or have a list of contacts related to the company where the deal belongs…

Thank you for your help.

Julien

[TheTimeSavingCo]

Hi Julien, I usually get around this by making the first field a formula field that displays the values that I need like so:

Allowing me to do this:

[ScottWorld]

Welcome to the community, @Julien!

Unfortunately, this is a gigantic & frustrating limitation of Airtable. I would highly recommend sending an email to support@airtable.com to ask them to fix this behavior in the future.

As @Adam_TheTimeSavingCo mentioned above, there is only one workaround for this, which is to make your primary field a formula field.

Alternatively, the On2Air: Amplify extension gives you the behavior that you’re looking for. But just like all extensions, you will need to do your data entry within the extension dashboard to get this behavior:

On2Air | Airtable Apps for Your Business Operations – 16 Jun 21

On2Air: Amplify | On2Air

On2Air: Amplify is record editor and viewer. Create custom records by displaying or hiding fields, view documents or attachments in full-screen, and edit current records or create new records directly from the dashboard. On2Air: Amplify is an...

[Julien]

I thank you for your help.

So I chose the formula as the field type for my primary key.

It works very well, and will help me easily in my steps.

Thanks again :slightly_smiling_face: