AnsweredAssumed Answered

Conditional Format based on the last related record

Question asked by dgardner362 on Jul 9, 2015
Latest reply on Jul 9, 2015 by dgardner362

Title

Conditional Format based on the last related record

Post

I have a table of job sites, I have another related table of jobs.  When there is a new job at a job site they are linked using the job site number so when you look at a job site record you see all of the jobs that have been sold at this site from newest to oldest through a portal.  New jobs have not been assigned a warranty date yet because they are not complete.  I would like to use conditional formatting to show a text notice on the main page of the site when there is a job in progress.  This is easy to determine because the warranty date on this related record will be empty.   I have not been able to come up with the correct conditional formatting formula to say if the warranty date of the last (first in portal because of sorting) related job is empty.   Any assistance appreciated.   FMP13

 

 

Outcomes