Hi JP10, I did a demo file for COFMUG (central ohio filemaker user group) that demonstrated that method (grouped conditional formatting).
I'm happy to share this file, look for the layout "grouping Number-Free" as the final result.
It's a good demonstration file for the GetNthRecord() function
getnth.fmp12.zip 13.0 K
Mike, thank you so much I will review it later and let you know if I have further questions. Appreciate it.
This gives me a direction for how to display the alternating rows with different colors. Thank you. Now I still need to know how to display the data from the drop down and date selections? Appreciate it.
Mike, I'm looking at the getnth.fmp12 file, but am still not sure where the actual color selection is assigned? Can you guide me where I can find where this occurs? Appreciate it.
just filter the portal to show what you need
you need the 3 fields to be global and a script trigger in each field
Refresh Window(flush cash joined results)
so the portal will show the filtered ones