Sending Single Record Notifications to All Child Records Related to Parent

Question

I would like to click a button on the parent record and have it send "Single Record" type notifications to all of the child records. Would anyone know the most efficient way to do this?

What I have tried so far was doing an automation but that could only seem to send out 15 notifications before disabling itself.

Appreciate any *free* help that could be provided on this, as I have tried reading through the community but have not found any detailed steps to accomplish this.

Thanks so much!

quickbasecoachd · Answer

I don't have any free help, but I can write a script for you which can do that. It usually takes me an hour of consulting time to set that up. QuickBaseCoach.com

It may be possible to do with some kind of looping Automation, but I have not tried to do that myself.

ericknudson · Answer

Understood, and to be honest I've got a lot of free help from you - reading all your highly useful posts.&nbsp; So definitely don't expect to ask for more of your time.&nbsp; Really appreciate all you have done in this community and you have learned a lot from you.&nbsp; I am learning writing script so this looks like a good place to learn.&nbsp; Thanks for giving me some assurance this isn't native to QuickBase.&nbsp; &nbsp;&nbsp;

quickbasecoachd · Answer

But there actually now is another solution now that as of the December release we have summary text fields.

You can make a text field equal to the value of the email address to be emailed.

Then make a summary text combined field in the relationship.

Then on the Project, use 25 similar formula fields to parse out the individual email addresses. Then send 1 email to all those addresses..

ericknudson · Answer

Thank you so much!&nbsp; I have every part set but a bit unsure of the last part where you mentioned to send 1 email to all those addresses.Any recommendation on how I'd go about doing so?&nbsp; In the notifications it only allows me to send to one field which doesn't accommodate selecting 25 emails, so not sure if I'm missing something there.&nbsp;&nbsp;

ericknudson · Answer

Actually dug a bit deeper and found this from&nbsp;Bob Jordan&nbsp;"create individual email formula fields and list them within the "specific list of email addresses" field on Open notification page".&nbsp; Looks like that works for far - I think.&nbsp;&nbsp;

Forum Discussion

Sending Single Record Notifications to All Child Records Related to Parent

Related Content

New Notifications

Custom Record Titles

Notification with attachment

Notification to EOTI user

Using Grid Edit to Edit Multiple Records at Once