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
------------------------------

shawns · Answer

In case anyone ends up here looking for a similar solution here is what worked for me:&lt;qdbapi&gt;&lt;usertoken&gt;user token&lt;/usertoken&gt;&lt;apptoken&gt;apptoken&lt;/apptoken&gt;&lt;query&gt;{3.EX.[Record ID#]}%RepeatOn%OR{3.EX.[Record ID#]}%RepeatOff%&lt;/query&gt;&lt;/qdbapi&gt;From the documentation %RepeatOn% repeats what's inside it. So:&lt;query&gt;%RepeatOn%{'3'.EX.[Record ID#]}%RepeatOff%&lt;/query&gt;results in:&nbsp; &lt;query&gt;&nbsp; {'3'.EX.[Record ID#]}{'3'.EX.[Record ID#]}...for however many records&nbsp; &lt;/query&gt;While:&lt;query&gt;{3.EX.[Record ID#]}%RepeatOn%OR{3.EX.[Record ID#]}%RepeatOff%&lt;/query&gt;results in:&lt;query&gt;{3.EX.[Record ID#]}OR{3.EX.[Record ID#]}OR{3.EX.[Record ID#]}....&lt;/query&gt;Since this only triggers once you need the logical OR in the resulting repeated list to make sure you match any and all of the Record IDs. It took me too long to realize what RepeatOn is doing and how that interacts with building a query string with more than one condition.&nbsp;Good news is that doing it the incorrect way did not purge my whole table. I'm still building my app so there was only test data at risk.

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------------------------------

Forum Discussion

Ideas for multi record notification when records are deleted?