Test are OK but nothing happens when I turn on the automation

I have created a two step automation where the condition is based on a date. If any of the dates in a certain field is before today, which they all are, the automation is supposed to update that record and create a new one. The test works fine but nothing happens when I turn the automation on. Why? :slight_smile:

This is my automation: Sign in - Airtable

@Kamille_Parks I tried to copy/paste the {End date} value but that didn’t help. {End date} is a formula. Does that matter?

Let me clarify what I want to accomplish.

  1. If any of the records have an {End date} that is before today…
  2. change that records’ {Status} to ‘Inactive’ and…
  3. create a new record with the same field values exept for {Start date}, which should be set as the triggering record’s {End date}

I want this to happen to all the records that meet the criteria. This should create a loop until the records’ {End date} is not before today.

With the “when record meets conditions” trigger, the action will not fire for records that meet the condition before the automation was turned on. You must turn on the automation first, before the record meets the conditions. Then the record must switch to meet the conditions while the automation is turned on.

In order to run the automation on existing records, you must find some way get the records to change state while the automation is turned on. The most common way to get an automation to run for old existing records is to actually use a different trigger, such as a temporary manual checkbox,. Then after you have processed the backlog of records, switch the automation to the proper trigger.

You might want to change the condition to be
{End date} is before today AND {Status} is not ‘Inactive’

In order to create a new record with the same field values, you need to tell the automation the field value for every field. This can be tedious to setup the first time, but at least you only need to do it once.

I tried that but that did not help.

The most common way to get an automation to run for old existing records is to actually use a different trigger, such as a temporary manual checkbox,. Then after you have processed the backlog of records, switch the automation to the proper trigger.

Should I replace my current trigger with the temporary checkbox? What do you mean with ‘processed the backlog of records’? I’m not sure I understand…

@kuovonne Hey, I actually worked now! I set the {Start date} to 2029-01-01 for a record, activated the automatisation and changed it back to 2019-01-01. The current record was set to inactive, a new record was created and then set to inactive as {End date} still was before today. A new record was created which had an {End date} AFTER today. Then the automatisation stopped, just like I intended it to.
So how do I do this for all records? :smiley:

(post deleted by author)

As I said in my earlier post. To process a backlog of existing records, you need to have a different trigger that you can manually activate after the automation is turned on. For example,

  1. Create a temporary check box field.
  2. Change the trigger so that the automation is triggered when the checkbox is selected.
  3. Turn on the automation.
  4. Select the checkbox for all the records. The automation will run for all the records with checkboxes. You may need select the checkbox for some newly created records.
  5. Change the trigger back to the actual desired trigger.
  6. Delete the temporary check box field.

That almost worked. It created a never ending loop since I removed the criteria {End date} is before today. Any suggestions?

I left that criteria in there as well and now I think it worked. Have to double check!

@kuovonne I’m so close! A criteria for not creating a new record is if {Terminated} is before {:gear:Last notice day} but I can’t specify that as a criteria. Any ideas?

I solved it! Thanks!

1 Like