Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoThe option to type and copy values would allow you to write into a field like
The rain in Spain falls mainly in the [Country], and the Automation will fill in the name of the country when it writes out the record. I have never actually fund that to be useful.
Perhaps you can describe what you are trying to do and we can help.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
The rain in Spain falls mainly in the [Country], and the Automation will fill in the name of the country when it writes out the record. I have never actually fund that to be useful.
Perhaps you can describe what you are trying to do and we can help.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
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
------------------------------
- BenjaminGolden6 years agoQrew CadetOr, 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
------------------------------