Parent Record has a field called 'Priority'. Priority is currently a lookup on the Child Record. When Priority changes, I need a notification to go to the user listed on the Child Record. I've tried adding a formula field to the child record that uses the value of priority, but that's not triggering the notification. That's what was suggested to me by QuickBase support, but it's not working - and I've run out of ideas on how to trigger this notification. Thanks in advance!
Can you tell me how many children a Parent can have in practical terms in your app. Is is just a few like maybe 5 or fewer?
Somehow, each of the child records need to get updated in order to trigger a Notification. So how to do that?
Option 1. The user triggers the Notifications by Grid Editing a date or date/time field in Grid Edit. User will get a consolidated report of those changes via a single email with a link.
Option 2. The users click 20 buttons on say 20 child records to trigger the Notifications. On each click the line would change color so you know which ones were clicked. User gets 1 Notification per Task they are assigned to.
Option 3. The user clicks a single button to run a script which will trigger the Notifications. That would require one on one assistance from myself or another QuickBase Service Provider (QSP) to set up that script. That would result in one Notification per Task, but just 1 button click.
Option 4. There is a setup I could to to trigger a single consolidated Notification of all changed records to each respective Assigned user. It would like the grid edit, but the user would not need to go into Grid edit.
If there were a smaller number of child records, it would be possible to do a series of reverse relationships to float up all the Unique task owners to the Parent record and consolidate them into a UserList formula field. But doing like 40 reverse relationships would get to be nuts and may affect the performance of your app, or sometime in the future not be supported by QuickBase to have that many "loops".