I am confused. I set up an UPDATE RECORD AUTOMATION that seems to work in my 2 test tables, but it still creates error messages sent to me by Airtable.I have two tables to test this: The first one is CONTACTS MAIN with the following fields: This is t...
I am trying to solve the following problem.
I have thousands of registration numbers that always start with a “T” and are followed by 10 digits.
This is how they are delivered to me T3090728379.
But they all need to look like this T-309072837-9
which...
I have a formula that’s doing what I want it to do. But I’d like the field {ACTUAL VALUE} to be currency formatted like {EST. VALUE} - I’d also like to get a SUM at the bottom of this column, so I need it to be a number.
This is what I have so far....
If someone could help me with this, I’d be extremely grateful. I can’t figure this out.
This is what I"d like to achieve through a formula:
Most Track Titles have a name followed by a “space hyphen space” and a suffix.
I’d like to automatically dele...
I have an interesting problem. I need to create database-sort-friendly versions of names, where all definite and indefinite articles are dropped from the beginning of each name.
I came up with this formula:
IF(REGEX_MATCH(Name,'^THE'),
SUBSTITUTE(Na...
Thank you, @ScottWorld. Yes, the "update contact" problem is solved. As @Arthur_Tutt pointed out, I don't need an automation here as the fields in the second table are already linked/lookup fields.I will look into MAKE for importing data into Airtabl...
Thank you so much, @Arthur_Tutt. Your video was eye-opening. Thank you so much for trying to explain some of these essential things to Airtable beginners like me. I really appreciate it.You are correct. The second table already has a link to the firs...
Thank you, @ScottWorld, for replying. I did already change it to "when a record matches condition."I decided to shut down this little side project as it is causing more trouble than necessary. I know what you mean by "the proper way to set up a datab...
Thank you, @Arthur_Tutt . I have a second automation set up (not shown here) that adds a record in the second table whenever a new one is created in the first one. The automation that's causing these Airtable notifications is the one that's updating ...
