Sending Single Record Notifications to All Child Records Related to Parent

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
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!
Photo of letsmakeitbetter

letsmakeitbetter

  • 108 Points 100 badge 2x thumb
  • a bit weary

Posted 7 months ago

  • 0
  • 1
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.

Photo of letsmakeitbetter

letsmakeitbetter

  • 108 Points 100 badge 2x thumb
Understood, and to be honest I've got a lot of free help from you - reading all your highly useful posts.  So definitely don't expect to ask for more of your time.  Really appreciate all you have done in this community and you have learned a lot from you.  I am learning writing script so this looks like a good place to learn.  Thanks for giving me some assurance this isn't native to QuickBase.    
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..
Photo of letsmakeitbetter

letsmakeitbetter

  • 108 Points 100 badge 2x thumb
Thank you so much!  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?  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.  
Yes

Just list them vertically

[email1]
[email2]
[email3]
Photo of letsmakeitbetter

letsmakeitbetter

  • 108 Points 100 badge 2x thumb
Actually dug a bit deeper and found this from Bob Jordan "create individual email formula fields and list them within the "specific list of email addresses" field on Open notification page".  Looks like that works for far - I think.  
Photo of letsmakeitbetter

letsmakeitbetter

  • 108 Points 100 badge 2x thumb
Thanks, I definitely learned something there but upon testing realized I will need to push unique field info from the child records so having it only populate the parent or from 1 email won't work.  

I really wish the automations could handle more load or there be more flexibility with the notification system.  Spent a lot of time trying to workaround this to no avail.