Jun 11, 2023 08:05 AM
We use automation to combine records from more than one field and find that they remain in the automation field when a record is deleted from one of the original fields. Is there a way to remove these linked records from the automation field when they are removed from the trigger field? We don’t want to clear all the linked records, just the removed ones.
Jun 11, 2023 08:35 AM - edited Jun 11, 2023 08:36 AM
Hi @Kongtho_Imarith,
Are you looking to delete the linked records that are no longer necessary?
If so, you'll need to use an automation script step with the following code:
//DELETE UNLINKED RECORDS VIA AUTOMATIONS
//Usage: On record updated trigger, if linked record field is emptied then delete self
//Automation variables: trigRecID as trigger record ID, linkedRecField as trigger rec linked record field
let config = input.config()
let table = base.getTable('YOUR_TABLE') //replace w/ trigger record's table
!config.linkedRecField.length && await table.deleteRecordAsync(config.trigRecID)
Hope that helps!
-Stephen
Jun 11, 2023 04:38 PM
If it can be generated by Automation (without scripting), it should also be possible to update or delete it.
How about using the trigger "When record updated" to regenerate when there is a change?
Jun 11, 2023 05:54 PM
@Sho It's not possible to delete records via Airtable automations without scripting.
@Kongtho_Imarith If you're not looking to delete records (sounds like you aren't but I threw it out there just in case), you can unlink records by using an Update Record action and changing the value of the linked record field.
Jun 11, 2023 11:10 PM
Yes, it is possible to remove linked records from the automation field when they are deleted from the trigger field. This can be achieved by implementing logic that detects the deletion and removes the corresponding linked records from the automation field while leaving the rest intact.