Skip to main content

I have a student assigned to a homeroom in the column “current homeroom”. I am adding a checkbox “Withdrawn”. I would like to do this:

IF the student is withdrawn THEN move the value from “current homeroom” to “homeroom 22-23”.

The result being: cell in column current homeroom: empty, cell in homeroom 22-23: previous homeroom teacher.

How can I do this ? Do I need to use the remarkable integromat or can I do it without external tools just with formula?

You can use a native Airtable automation for this.


Trigger: when record meets conditions

Trigger conditions: the {withdrawn} checkbox is selected


Action: update record

Fields updated:

{homeroom 22-23} set to existing {current home room}

{current homeroom} make blank

You can use a native Airtable automation for this.


Trigger: when record meets conditions

Trigger conditions: the {withdrawn} checkbox is selected


Action: update record

Fields updated:

{homeroom 22-23} set to existing {current home room}

{current homeroom} make blank


Thank you for your support. This is what I have done but in integromat (part of z bigger scenarios).

Reply


Terms & Conditions