Update Child Records Button Using DoQuery and EditRecord API

Question

I need to update child records without using an Automation. The automation in QuickBase won't trigger a Notification, which I'm wondering if there's a work around.

Can a Javascript button be used to query the child records and then update any child records the query passes back? In my head I could see this maybe working, but I don't have enough Javascript experience to figure it out unfortunately.

Or, if anyone has figured out a workaround for getting an Automation to trigger a notification, that's what I'm trying to accomplish in the end.

Thanks,

Dana

------------------------------
Dana Hauser
------------------------------

markshnier__you · Answer

Are you saying that an Automation will not trigger Notifications as they are seen by the system as a Mass update and not individual Notifications?

I do have a script that I can install for about an hour of consulting time which would allow you to press a button and then the script will walk down a list of records on a report and jiggle them one by one to trigger individual Notifications. So the typical use case is that a human would receive a Subscription report of emails needing to be sent, and they would click one button to trigger all the Notifications. They can just leave that screen running with the progress bar moving along in an open tab while they go on with other work in another tab.

Contact me directly if you would like a demo.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

danahauser · Answer

Hi Mark, thanks for your reply.
My exact need is to trigger the Juiced Text My QuickBase add-on, which uses notifications as a trigger.&nbsp; I'm trying to have it text each person in the child table when a meeting is scheduled.&nbsp; Only certain people would be going to the meeting, they are the child records of the parent record, which is the meeting.&nbsp;
When I setup an automation to set a checkbox to true on the child records, it won't trigger the notification, which is what triggers the Juiced add-on to do the texting.&nbsp; Each child record should trigger its own notification, but I understand there's been a change in QB that treats them as multi record instead.&nbsp; I have the info in both the single and multi-record areas of the notification.&nbsp;
Hopefully this gives you a better understanding of what I'm trying to accomplish.
Thanks again,
Dana------------------------------Dana Hauser------------------------------

markshnier__you · Answer

So the closest I can get is to install a button on the Parent Meeting record called Notify Attendees. It would run the script.

The Alternative may be to float up all the mobile numbers of the children attendees up to the parent using a combined text summary field on a mirror field of the mobile numbers set to text format.

Then use 10 formula fields on the Parent Meeting to parse out say the first 10 attendees into 10 separate phone number fields

Then set up 10 Notifications to fire to trigger to Juiced when a meeting is scheduled and Attendee # X is not blank. You will probably need to ask Juiced for 10 text my quick base templates as each of the 10 needs to look at a different field to send the text to (unless Juiced can accept a comma delimited list of phone #s to text).

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Forum Discussion

Update Child Records Button Using DoQuery and EditRecord API

Related Content

Custom Record Titles

Using Grid Edit to Edit Multiple Records at Once

Record Details

Many parent records on a single child record

REST API - doQuery - get record ids