I would like to know if there is a way to search in all the fields of a linked tab when you are in the other tab. Right now, all I can do is search inside the primary field, which is not very convenient.
For example : I want to add a client in my tab. He is of course in the other linked tab. I don’t remember the name of his company but I remember his family name. In the same time, I also want to add a client, whose name I don’t remember, with his company name. To add them both, I should have write the company name and the family name in the primary field in the first place (although it is already written is the next fields), for each client. That seems odd regarding all the things you can do with Airtable.
I must add that I’m using the free version right now (not for long though), so maybe it’s because of that?
Thanks in advance for any help provided.
Welcome to the community, @Pierre_Suchaud!
Unfortunately, Airtable has never offered this very important capability, and I would highly recommend writing firstname.lastname@example.org about adding this feature. Historically, they have not listened to customer feedback, but you never know when their management will change and their internal policies will change.
You have a few options to address this:
You can create a formula field as your primary field, which combines all the different fields that you might want to search. it’s not pretty, but it works.
You can use the On2Air: Amplify app, which offers this feature. Then you would do your data entry in the app window, instead of the main Airtable interface.