When a record is created, run action on previous records.

[acrawford]

I have records in an "Equipment" table with related records in an "Inspections" table.

When I add a record to the Inspections table, I want a bot to change the Status of the previous records to "Expired".

I have managed to get the bot to change all the related records, not just the old ones. I want to keep the Status of the newly added record as "Current".

How do I get it to just change the old records?

 Action SettingsEvent SettingsProcess SettingsBefore Bot RunAfter Bot Run

[WillowMobileSys · Accepted solution]

In your bot step, "Set [Status} to Expired", change the "Referenced Rows" expression to:

[Equipment #].[Related Inspections] - LIST([_THISROW]) 

I hope this helps!

[acrawford]

It works! Thanks so much!