We've all been there, we or someone we work with has permanently deleted data that should have been kept. Then we spend hours recreating the data, finding out who deleted it, or hoping no one will notice. In this tutorial, you'll learn that it's possible to allow users to delete records, without actually deleting them.
You may be in need of some role controls if you answer yes to any of the following:
Who's ready to save some records from the trash!
Delete button URL formula code
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_24=1&rdr="& URLEncode(URLRoot() & "db/" &[_DBID_TIME_CARDS] &"?a=td")
The "fid_24" refers to the field ID for the Delete checkbox.
The "[_DBID_TIME_CARDS]" refers to the table alias, which can be found in the advanced settings of the table.
Version with an app token
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=XXXXXXXXXXXXXXXXXXXXXXXXXX&rid=" & [Record ID#] & "&_fid_24=1&rdr="& URLEncode(URLRoot() & "db/" &[_DBID_TIME_CARDS] &"?a=td")
FROM THE TUTORIAL: "...When editing an individual record I also have the option to delete. I want to be able to stop that from happening. To do so I'll need to navigate to the application settings. Once here I can open the roles, choose the manager role, and then look at the timecard settings. So here for time cards, I see that the checkmark for delete is checked enabling them to delete those time cards. I'm going to want to uncheck that box which should remove their ability to delete. Going back to that time cards table I'll check again as a manager. And now you can see I don't have the ability to select all the records in order to delete them. And when I edit a record I also no longer have the ability to delete. Now that's great, but you might also want to be able to give them the option to at least feel like they're deleting in case there was a mistake..."
Feeling like a Junkie? Subscribe on YouTube now!
Tips, shortcuts, checklists, reviews, tutorials, and courses from Quick Base Junkie!
Don't worry, your information will not be shared.
Take your Quick Base skills to the next level with Premium Courses.