I am using Zapier to autofull documents based on airtable inputs, I am struggling with checkboxes and trying to use formula fields to provide me with a “true” or “false” based on the input of a single select field.
Has anyone used single select to provide a true or false outpouts, I am stuck!
You can just put the value(s) you want to use from your single select field between " ". Not sure how those checkboxes are related to this… To use checkboxes in a formula field, u can use =0 for empty ones and =1 for filled ones.
That will return the result_if_true output if the checkbox is checked for a given record. This is similar to Airtable’s pattern of treating most other non-empty fields as equivalent to True and empty fields as equivalent to False.
The same goes for using AND() and OR() to check multiple fields: