October 15, 20196 yr Newbies How do I conditional farmat a portal row based off matching fields in another portal? I have created a table for employees with thier schedule for next 3 weeks. A global table so I may have two incidents of the same table filtered by global fields. This way I can display two employees schedules side by side using one table. So Table1 with Store Number, Employee Name, Work Date, Start Time, End Time. Table2 Store Number, Trainer Name(Global), Traniee Name(Global). Related field Table1::Store Number to Table2::Store Number. Table1 Copy::Store Number to Table2::Store Number Layout based on Table2 Two Portals Portal 1 (Table1) Portal 2 (Table1 Copy) Portal 1 is filtered by Table1::Employee Name = Table2::Trainer Name Portal 2 is filtered by Table1 Copy::Employee Name = Table2::Trainee Name This works fine, I am able to display Trainer schedule next to Trainee Schedule. What I would like to do is add conditional formating to Portal 2 Start Date Field by comparing the same date from Portal 1 when Portal 1 Start Time is between Portal 2 Start and End Time. I tried this formula in conditioanl formatting (Table1 Copy::Work Date = Table1::Work Date and Table1::Start Time > Table1 Copy::Start Time and Table1::Start Time < Table1 Copy::End Time) This works only for the first portal row. It does not evalualte the 15 other rows in the portal. Is there a way evaluate portal rows that match date and the additioanl conditions throughout the complete portal? Thank you for you assistance.. Dan
Create an account or sign in to comment