+7Hi!
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!
Best answer by Justin_Barrett
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.
A shorter way is to drop the = operator.
IF({Checkbox field}, result_if_true, optional_result_if_false)
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:
IF(AND({Checkbox 1}, {Checkbox 2}), ... )
+25You 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.
+21You 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.
A shorter way is to drop the = operator.
IF({Checkbox field}, result_if_true, optional_result_if_false)
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:
IF(AND({Checkbox 1}, {Checkbox 2}), ... )
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.