Forum Discussion

AlexWilkinson's avatar
AlexWilkinson
Qrew Assistant Captain
8 years ago
Suggested strategy:
  1. On the parent record and on the child records, create a checkbox field "Delete This Record"
  2. On the parent record, create a Quick Base action to make "Delete This Record" on related child records to be the same as "Delete This Record" on the parent record, when that field on the parent is modified.
  3. Use the method outlined in this QB tutorial, which explains how to use a service like Zapier (or your own API calls) to accomplish tasks like bulk archiving or deletion:  https://university.quickbase.com/series/advanced-training/record-archiving-and-snapshotting-2503
If desired, you could also modify the report on your table homepage to either not display records where the box is checked or sort them to the bottom. And, perhaps before automating step 3, you could do it manually with reports that filter for records where the box is checked.
  • NirajShah1's avatar
    NirajShah1
    Qrew Cadet
    8 years ago
    Thanks, Alex. I don't think this will work for what I am trying to do. Here is the challenge I am trying to find a solution for:

    Create a button in the employees table that allows for the user to delete that employee. This
    button should confirm with the user using a JS popup and then delete all child records (address
    change log) and delete the record and return to the table home page.