The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
There are a few requests for new functions to be added to the ones available to Formulas.I think it would be even better if user-defined functions can be made available to Formulas. They can be defined in a Scripting Block of the Base.Perhaps someday...
I keep running into this “brick wall” because recursive structures are necessary to many of my bases because many of the data I am managing are naturally hierarchical in nature (XML, JSON, folder/directory paths, org structures, etc).I understand tha...
I am trying to manage a data dictionary and generate XSD (XML schema definition) as part of managing API definitions in our project.
However, I keep getting blocked by this error.
Here is an example base (I stripped down all columns that are not rele...
What would be great is if functions defined in Scripting Blocks are allowed to be used in Formula fields.
That way, if there is a function that is needed but missing, we have the option to write a new function that we can use.
I think the problem in your formulas is you put 1 or 0 in quotes. Remove the quotes and it should work.
See here: https://support.airtable.com/hc/en-us/articles/217113757-Using-checkbox-fields-in-formulas