Ideas for multi record notification when records are deleted?

Question

I have a table of leases, and a child table of expenses. When expenses change, it fires a notification off. When expenses are deleted, it also fires a notification. This all works great, except in the specific scenario when multiple child records are deleted at once. In this case, the multi record notification fires, but there is very little information available. I would like to put in a link to the parent record, but I don't think that is possible since I cannot reference a field in the multirecord.

My only idea is to make a report of recently changed expenses, but that would only work if they click on the link to the report the same day the notification is fired. Anyone else have creative solutions to this issue?

------------------------------
Mike Tamoush
------------------------------

markshnier__you · Answer

One solution is to take away the permissions for normal users to delete. And please give them a check box on the expense records called [Request Deletion].

Then have a pipeline watch for that checkbox and delete the record. I think you will find that if 100 records are deleted the pipeline will fire 100 separate times and the app will see that as 100 single record update Notifications.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

miketamoush · Answer

That's the solve for now, though I used a webhook instead of a pipeline so it would happen instantly. I used a button push instead of a checkbox, so they are forced to delete one by one.
------------------------------Mike Tamoush------------------------------

markshnier__you · Answer

Can you post your multi record webhook code?&nbsp; It mjkst use the Repeat On syntax?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

miketamoush · Answer

Since I am forcing a button push, I used API_DeleteRecord which is pretty simple, but wont work for multi record. However, I was just watching the Kirk Trachy video, and think I know what the code would be for multi delete. Ill post it shortly let me grab it.------------------------------Mike Tamoush------------------------------

miketamoush · Answer

Below is my best guess,&nbsp; but untested. It would use API_PurgeRecords (rather than API_DeleteRecord). I tried to adapt using what is at the 10 minute mark in this Kirk video.https://www.youtube.com/watch?v=-eY6ZAivCZYIn his video he is not deleting the record that triggered it, but rather a related record. Also, in the middle of his explanation he realizes he has an error, and has duplicated some of the code. But he doesnt fix it on video, so I am using my best guess on how it would work. Worst case, we can duplicate his 'error' because his actually still works, it is just not clean code.&lt;qdbapi&gt;&nbsp;&nbsp; &lt;usertoken&gt;enter user token here&lt;/usertoken&gt;&nbsp; &lt;apptoken&gt;enter app token here&lt;/apptoken&gt;&nbsp; &lt;udata&gt;mydata&lt;/udata&gt;&nbsp; &lt;query&gt;&nbsp; %RepeatOn%{'3'.EX.[Record ID#]}%RepeatOff%&nbsp; &lt;/query&gt;&lt;/qdbapi&gt;
**Also, I would test this in a test environment, as the API help page says if there is no query, all records in the table will be deleted. Not sure what happens if your query just isnt right.....but seems risky for sure so use with caution.
------------------------------Mike Tamoush------------------------------

Forum Discussion

Ideas for multi record notification when records are deleted?

6 Replies