My client has an app which her Technicians use to know when,how and which pools to service. Each Tech can generate his/her daily Route through a button (using a gallery view from a “Menu” table). Each “CLIENT_POOL” has an ASSIGNED_USER_UID (which refers to the tech) and a Service Day (which is used to know on which Day’s route to add a visit for this pool). The Route generating button should do two things.
- Create a new Route entry in the ROUTE_MASTER table (which works fine)
- And then, it should select all of the currently logged-in Tech’s assigned Pools and schedule a Visit to each one of them for this day’s Route (based on the pool’s service day). (Doesn’t work).
Now as a method of debugging, i’ve added confirmation dialogs on each of the 3 actions to see which one isn’t running. The “Create Daily Visit” action on the “Client Pools” table, doesn’t seem to run at all.
However, the Referenced Rows condition seems to return the correct results on which that action should be executed. What am i missing here?
Action Group called upon clicking on the gallery button:
Create Route Action :
Add visits to route Action :
Row filter condition for this action :
SELECT(CLIENT_POOLS[CLIENT_POOL_UID], AND([ASSIGNED_USER_UID] = USEREMAIL(), [Service Day] = INDEX(
Create Daily Visit action (not running) :
What am i missing here?