Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

CRM: Checkbox =1 Then Create a new row in another table

Topic Labels: Formulas
Solved
Jump to Solution
535 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi everyone,

I’m building my CRM and I have two tables, one is the “Account” and the other “Register”.
The client fills the form that it’s linked to the “Register” table, the account manager, based on the information provided by the client approves or not the client turning the Checkbox to 1.
I want to create a new row for that client in the table “Account” when the account manager change the checkbox to 1.

Can you guys help me? Or maybe I am overcomplicating everything.

Thank you all!

Best,
Luis

1 Solution

Accepted Solutions

Welcome to the community, @Luis_Ferreira! :grinning_face_with_big_eyes: Unfortunately this can’t be done directly within Airtable. You’ll need to enlist the help of an integration tool like Zapier or Integromat, which will look for the checkbox change and make the new client record.

On a side note, I suggest using a single-select field instead of a checkbox. A checkbox is easy to accidentally change with a careless click, while a single-select is a little more “stable”. The field could be named {Status}, and have options like “Review” and “Approved,” with the “Approved” option triggering Zapier or Integromat to make the new record.

See Solution in Thread

2 Replies 2

Welcome to the community, @Luis_Ferreira! :grinning_face_with_big_eyes: Unfortunately this can’t be done directly within Airtable. You’ll need to enlist the help of an integration tool like Zapier or Integromat, which will look for the checkbox change and make the new client record.

On a side note, I suggest using a single-select field instead of a checkbox. A checkbox is easy to accidentally change with a careless click, while a single-select is a little more “stable”. The field could be named {Status}, and have options like “Review” and “Approved,” with the “Approved” option triggering Zapier or Integromat to make the new record.

Thank you @Justin_Barrett. I’ve been using Zapier and the side note was perfect!