Quick rundown of what I’m trying to do here.
- Page of ‘daily jobs’ sorted into 12 repeating groups (all taking data from 1 hidden repeating group).
- Each section of the job requires 1 truck, 1 driver and 2 trailers. There can be up to 3 sections in each job.
- Total of 3 trucks, 3 drivers and 6 trailers allocated to any one job.
I’m trying to work out an efficient way to highlight all duplicate values shown in a repeating group (for example, a truck from one job is also allocated to another job). In the past I had run a search in the database, and then using the :count function basically said if there was more then 1 found for a certain date then conditional formatting would highlight it red.
This slowed down the page dramatically (which is already rather heavy in terms of workflows and data), resulting in having to remove it from the page.
I’m hoping there is something I can run based on the hidden repeating group?
This post had a similar issue How to highlight a word appearing multiple times in RG however this is not based on an API call (but the database directly).
Can organize a public version of the app if need be! Thanks in advance