Button to run a script that deletes the record

I need read-only users to be able to click a button and delete a record. I am just about to start learning JS (how many people are saying that now Airtable Scripting exists!) but currently have no coding knowledge!

Can anyone help with a script I can run on a button being clicked to delete the relevant record? Thanks in advance!

Writing that script would be easy except I’m pretty sure read-only users wouldn’t be able to use it. Either a user can edit/delete a record by any means or they can’t.

1 Like

I was worried about that. Ok, will just have to wait till our Stacker solution is all setup. Never mind!

Thanks for your response Kamille.

Any chance you could provide me the script so I can test to confirm?

Straight from the Scripting documentation: table.deleteRecordAsync(recordId)

You could have a button that opens an Airtable form prefilled with the record id of the record to be deleted. The user submits the form, then have an automation script trigger do the actual deletion.

1 Like

That’s definitely one way to do it. Very, very clever.

Thanks Kuovonne. It’s a great workaround. Unfortunately the impact on user experience outweighs the functionality - I think we’ll have to get an initial front end setup via Stacker to cater for our need to accomodate read-only users updating and deleting records.

Thanks for your help