Tom_Glatt - profile

Tom_Glatt · May 09, 2024

I have a tasks table with a self-linking field that I use to define task predecessors. Is there a way when adding a predecessor to filter the options to show only those that relate to the relevant project/grouping?The problem I am trying to solve is ...

Tom_Glatt · Jan 22, 2024

I have the following formula in a field names "Status":IF({Current Performance}=5,"5: Excellent",IF({Current Performance}>=4,"4: Good",IF({Current Performance}>=3,"3: Fair",IF({Current Performance}>=2,"2: Poor",IF({Current Performance}<2,"1: Very Poo...

Tom_Glatt · Jun 26, 2023

I'm curious how others address this challenge. In our project management base we have a combination of tasks and meetings. Tasks do not really need times, only start and/or due dates. Meetings, on the other hand, need both dates and times. Our curren...

Tom_Glatt · Jun 23, 2023

In my template table I have a lookup field that is formatted as currency. In the child table I have the same field with the same formatting, but I'm getting an "root must be a number" error when I run the script. I'm guessing this needs to be modifie...

Tom_Glatt · Aug 29, 2020

I have a script that I am testing on a CRM system we use and I’ve run into an issue. The basic automation workflow looks like this: A new record is added to a form which shows up in a view called “unprocessed.” This view is filtered on a linked recor...

Re: Adding a User to Interface Only · May 24, 2024

Thanks Scott. I didn’t realize that was now an option. Missed it. Do you think noloco is still a better option for something like a client portal as compared to airtable with the options to hide users and sharing?

Re: Adding a User to Interface Only · May 23, 2024

Has there been any further movement on this kind of issue? I really like the evolution of the interface development tool but am wary of building an interface that multiple clients access - especially clients that compete with one another. We've start...

Tom_Glatt · May 23, 2024

There's probably a better way, but you could create another calendar that syncs to Airtable and then use the duplicate option in an event to copy the event you want synced to the synced calendar. Would be a hassle if/when things change for an event, ...

Tom_Glatt · May 09, 2024

Ah! So THAT is what that little cog wheel is for on the linked record filter settings. Thanks so much for the help. You're awesome.

Tom_Glatt · Jan 22, 2024

Thank you for the detailed explanation! I kind of thought it was doing something like that but had no idea how to correct for it. Nice to learn the why. Thanks again for taking the time to explain.

User Statistics

User Activity

Limiting options when picking records in a self-linked record field

If Statement Formula focused on a Lookup Field

Tasks and Meetings: dates with and without times

Create Records for Multiple Templates: Lookup Field Error

Automation Script Error - Mutations Quota

Re: Adding a User to Interface Only

Re: Adding a User to Interface Only

Re: Send single Google Calendar entry to Airtable Calendar.

Re: Limiting options when picking records in a self-linked record field

Re: If Statement Formula focused on a Lookup Field