Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Conditional Formatting Portal from another Portal

Featured Replies

  • 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

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.