Skip to main content
Solved

Formula problems

  • July 5, 2020
  • 3 replies
  • 32 views

Hi @all, I am trying to move everything that has the “finished” checkbox checked to another table.
Is this possible?
I am using integromat’s automation system.
here is what I’ve tried:

Best answer by ScottWorld

Start by creating your formula in Airtable first, and make sure that your formula results in the number 1 for all of your records which are finished.

Then, you can copy and paste that formula into Integromat.

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • July 6, 2020

Start by creating your formula in Airtable first, and make sure that your formula results in the number 1 for all of your records which are finished.

Then, you can copy and paste that formula into Integromat.


  • Author
  • New Participant
  • July 6, 2020

Start by creating your formula in Airtable first, and make sure that your formula results in the number 1 for all of your records which are finished.

Then, you can copy and paste that formula into Integromat.


like this?
IF(Finished = TRUE()):
return 1


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • July 6, 2020

like this?
IF(Finished = TRUE()):
return 1


No, that is not a valid formula. Please post screenshots of your Airtable base, along with whatever formula you’re using.