olafjasiniak - profile

Interface filter "Current user domain" · May 27, 2024

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"...

olafjasiniak · Nov 04, 2024

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...

olafjasiniak · Sep 18, 2024

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...

Re: Assign member based on field values · Nov 15, 2023

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

Re: Assign member based on field values · Nov 14, 2023

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...

Re: Assign member based on field values · Nov 14, 2023

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 ...

User Statistics

User Activity

Interface filter "Current user domain"

Re: Interface Filter Element URL

Re: Interface Filter Element URL

Re: Assign member based on field values

Re: Assign member based on field values

Re: Assign member based on field values