I have a conditional automation. One of the conditions is that the actions only run if Formula = 1. However, airtable returns an error when this condition is included. The field is formatted as a number field. How do I get airtable to evaluate whethe...
I have a series of automations with various linked fields, but there is one user action I am struggling to create. For some minimal context, this is for recording and calculating mineral amendments to garden beds on a small market garden.In a particu...
The relatively recent addition of "default to current date" is really useful on date fields, where 95% of the time the user is going to select "today."However, it seems that the field doesn't use our local timezone, unless I enable "display time." I ...
I have a base that is largely used for planning.I have a lot of automations. Often one action sets off a chain of 4-5 automations.Because I use this base for planning, records get deleted often as part of my workflow (i.e. I change my mind).An unfort...
What is your process for troubleshooting automations in complex bases that have information changing regularly?I have an error occurring with an automation that I am struggling to troubleshoot. I can't seem to replicate the error in my testing, which...
Thanks! I did come up with 2 other solutions after posting, but yours is better (it reduces fields, which I prefer as it makes editing base design and troubleshooting simpler).The other two solutions that worked were1) Turning the active fields formu...
Sure!This is the base being referenced by the lookup field. It's a count field. This is the base it runs in. Here's the lookup and the formula field that references the lookup. These are the conditions on the automation
So I think there is still something I'm not understanding about how airtable interprets numbers in formula fields.But ultimately, what is the path forward for what I am trying to achieve witht his automation?
I may be misunderstanding, because this field can only be an integer.The set up:Active Guilds Lookup field (this looks up a "count" field in another base)Active Guilds field (this is the formula field - I created this because automations didn't have ...
