I should add, they lack the permission to be able to drill down into records from the "upcoming confirmed reservations" report - because EOTI submits "new reservation requests" to the same table that the report drills down into (to view individual confirmed records). We don't want all of our park constituents who submit reservation requests (functionally, "EOTI") to be able to look at reservation records that others have submitted. Which in turn makes it so that the non registered email recipients of the "upcoming reservation report" (also functionally "EOTI") cannot drill down into and view individual records linked on the emailed report.
Qrew LegendMy suggestion is to have a table of Park Managers. In fact you may already have that to drive a drop-down list.
Then create a specific form which will end up getting emailed to that Park Manager which has the embedded report of whatever you want.
Put a field on that report which is just a date time data entry field and create an "OPEN" notification the park manager.
Tested by manually entering any Date / Time to that field. (tip, you can just type "n" for now and it will auto complete.).
Once you have that working then create an admin table where there is only one record and use that one record being edited (say a date / time field being set the the current date time with a Formula URL button) to trigger a Pipeline to update all of the park mangers' records which have up coming reservations with the current date time into a trigger field for the Notifications. When a pipeline runs to update multiple records like that these are seen as individual record changes which will trigger the individual email notification that we want.
Mark, thanks for the great response. Will get to work on that and update you once it is working.
Hey Mark,
Forgot to update you earlier but this is working great. Thanks.
