Skip to main content

Hi,



I am trying to find a way to create the logic:



IF Project Code = Empty, then Checkbox = Checked



(if a device is not assigned to a project, then the it becomes available)



If anyone can guide me through this, Airtable is new to me.



Thanks



M

If you don’t need the functionality to manually check the checkbox as well, then you can just just use a formula field like this:



IF({Project Code}=BLANK(),“ ✅ ”,“✘”)



Otherwise, if you need to be able to manually override it, then you should have a separate Checkbox and then a formula field like this:



IF( OR( {Checkbox}=1, {Project Code}=BLANK() ),“ ✅ ”,“✘”)



(You can choose other emojis)

You could also automate it with Integromat or Zapier. But as @David_Skinner says the important is what you use or want to do with that Checkbox.

Reply


Terms & Conditions