Hello,I'm looking for a way to filter records dynamically similar to currently available options "Current user" and "Current user's email". What I have in mind is a formula field in the database that outputs something like "@acme.com", "@company.org"...
I think the only option would be to set up a dynamic filter for Client's email contains Current user email, but I don't think that can be done on public interfaces? Your clients would need to log in to Airtable I guess.To do that, you'd need to set u...
I think I've managed to solve this:I tested it on a "blank page" interface, it has a filter element and a grid tableWhen I select one element in the filter element (linked records), the URL looks like this:https://airtable.com/{{base_id}}/{{interface...
In the meantime one more thing came to mind - you could create a formula field with some Switch of If statements and then set up an automation that will parse this value to your desired field
You can also use lookup fields, so assign a member to the region, then add a lookup field.Generally I've found creating a more complex base schema with tables that serve as "dictionaries" to be easier to work with and automate than using single selec...
From what I understand you wouldn't need to have users interact with the "Team members" table (unless there are a lot of new members joining all the time). Just set up the structure once and connect the automation. Maybe I don't get the full context ...
