I have 3 collumns in my main table: “Empresa”, “Evento” and “Cliente”
I need to filter in the portal this 3 cells, Empresa (3 options and each option reveals some “Evento” options and when you select a “Evento” option more option reveals on “Cliente”)
So I take it that you want to have a Cliente field on a form that is filtered by first Empresa and then Evento. To achieve this, you can do the following:
Add the “Cliente 5” field to your form and then go to the field settings by clicking on it.
Go to Filter Records.
Add both “Empresa” and “Evento” under Conditional linked record filtering fields. (Make sure that Empresa is above Evento so that you first filter by Empresa, and then Evento)
This should now allow you to filter the Cliente field by Empresa and Evento.
I hope this helps, but please let me know if this isn’t quite what you are trying to do. If it isn’t, please add some more explanation on what you are trying to do. If you prefer not to share too much information on a public forum, you can always contact us through the chat and we will reply there
Oh, perfect!
In the “Mini” side is it clear for me how to create a Conditional linked record.
I’m having difficulty on how to create theses linked tables on Airtable, what I link with what, what column needs to be a Lookup field, for example.