Help

Detect formula error

Topic Labels: Formulas
Solved
Jump to Solution
1424 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nico_De_Ceulaer
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a single select field, and a rollup field which contains a formula that references the single select field.
Now I remove 1 option from the single select field. The formula of the rollup field is now broken because it references this deleted select option.
Airtable did not stop me from removing that select option (although it warned me about the dangers of me deleting the option). Airtable does show that the rollup formula is now broken by adding a red indicator to the field.
The problem I have is that the two fields where in different tables, so it took me quite some time before I noticed the problem. So here comes the question: is there a way to get a list of broken fields in a base? Either through the web UI or through the Airtable API?
That way, I could query this once in a while to verify nothing is broken.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

@AlliAlosa just wrote a script for that! :cowboy_hat_face:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

@AlliAlosa just wrote a script for that! :cowboy_hat_face:

Nico_De_Ceulaer
5 - Automation Enthusiast
5 - Automation Enthusiast

Super! This solves my problem exactly.
Thanks a million!