Help

Re: Single Select to Formula Fields

Solved
Jump to Solution
469 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jackson_Button
6 - Interface Innovator
6 - Interface Innovator

Hi!

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.

image

Has anyone used single select to provide a true or false outpouts, I am stuck!

1 Solution

Accepted Solutions

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}), ... )

See Solution in Thread

2 Replies 2

Hi @Jackson_Button

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}), ... )