DonCollier

Repeating Fields and Conditional formatting to generate visual Representation

Discussion created by DonCollier on Apr 27, 2017
Latest reply on Apr 29, 2017 by DonCollier

I am sure I have done this before and I have even seen others do it but I can't recall how on earth I did it. Can anyone help?

 

I have a table of Vehicle registrations with includes Insured start date and Insured end date.

 

And a table of dates which has a global repeating field with registrations in it.

 

In the table of dates I want to see a list of dates showing which vehicles were registered on a given date.

 

I am using a global repeating field for the registrations in the date table and want to use conditional formatting to Colour in the background showing which were insured.

 

I have it working so that it shows the first one that is valid but I obviously need it to show all of them on any given date.  In the enclosed picture all three vehicles are insured on the 21/8/2014 but only vehicle one is showing.

 

All help appreciated

Outcomes