I am working on in a table whose purpose is to have all aircraft on market & recently sold as a mechanism to build an MLS type system. I am trying to create an automation to delete a record IF a record that is being imported/create whose MSN matches and the Sold Price was filed where as before it might have been blank (signifying the aircraft was available). For ease of explanation here is a simple table structure to reference. What is the best way to achieve that?
The question I have is that is I create a new record (via import of records) and the Aircraft Serial matches one t
Hmm, would it be right to say that, if a record has an "MSN (from Aircraft)" value, as well as a "Price Sold ($)" value you want it to be deleted automatically? So with reference to the screenshot you've provided, records 2, 3, and 4 should be deleted?
If so, you can try an automation that triggers when "MSN (from Aircraft) and "Price Sold ($)" are not empty, and its action would be to run a script to delete that record:
let {recordId} = input.config()
let table = base.getTable("[NAME OF THE TABLE YOU WANT TO DELETE RECORDS FROM]")
await table.deleteRecordAsync(recordId)
Link to base
Note that this'll use one automation run per record deletion so if you're importing and deleting a lot of stuff frequently this might be an issue, and we'd need to find an alternative method to handle this. For your reference, a Teams plan has 25k automation runs per month!
I'm actually kind of curious what the business logic is too. It seems like this might be better handled via rollups and lookups, but I'm not really sure what you're trying to do and so can't say for certain. If you'd like to have a chat about that or could use some help setting up the automation above you can book a free half hour call here and we can see what we can do to improve your base!
