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