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
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?
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?
@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.
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.