Forum Discussion

DanaHauser's avatar
DanaHauser
Qrew Cadet
6 years ago

Update Child Records Button Using DoQuery and EditRecord API

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 use...
APIs and custom code
DanaHauser's avatar
DanaHauser
Qrew Cadet
6 years ago

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.  I'm trying to have it text each person in the child table when a meeting is scheduled.  Only certain people would be going to the meeting, they are the child records of the parent record, which is the meeting. 

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.  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.  I have the info in both the single and multi-record areas of the notification. 

Hopefully this gives you a better understanding of what I'm trying to accomplish.

Thanks again,

Dana



------------------------------
Dana Hauser
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
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
------------------------------