Forum Discussion
BenjaminGolden
6 years agoQrew Cadet
Hi Mark,
Here's the current relationship diagram for the app
Now, the interesting thing here is that, when typing it like this, instead finding the related punch pair using the proxy field "Tuesday 2", for example, it will find the punch pair with a record ID of 2. And it does do this as well when typing "Tuesday 2" manually as a value. So working with proxy fields at all may be out of the question; at this point the best thing I can think of is creating a few new fields (and possibly more automation steps) to try and juggle values around so the RID of the correct punch pair can get copied in.
------------------------------
Benjamin Golden
------------------------------
Here's the current relationship diagram for the app
Basically, I have an automation that triggers when a user provides a particular input (i.e. selecting a shift number from a list under the Default Shift field). Each Punch Pair has a day of the week and a number indicating when a given shift should stop and start (Monday 1 starts at 7:00 and ends at 15:00 (military time), Monday 2 starts at 15:00 and ends at 23:00, Tuesday 1 starts at 7:00 and ends at 15:00, etc. etc.). When the user selects the number 1 for Default Shift in a Schedule and saves the record, the automation clears the child Shifts and should add a new shift for each weekday (e.g. Monday 1, Tuesday 1, Wednesday 1). Note that in Shifts, the Related Punch Pair has a proxy field, Name, which consists of the day of the week and number written as listed. So, this is how I've been trying to add said shifts (one for each day of the week):
Now, the interesting thing here is that, when typing it like this, instead finding the related punch pair using the proxy field "Tuesday 2", for example, it will find the punch pair with a record ID of 2. And it does do this as well when typing "Tuesday 2" manually as a value. So working with proxy fields at all may be out of the question; at this point the best thing I can think of is creating a few new fields (and possibly more automation steps) to try and juggle values around so the RID of the correct punch pair can get copied in.
------------------------------
Benjamin Golden
------------------------------
BenjaminGolden
6 years agoQrew Cadet
Or, of course, making a separate Automation for each shift number. It feels like not the best practice but it's quick and works.
------------------------------
Benjamin Golden
------------------------------
------------------------------
Benjamin Golden
------------------------------