Skip 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.

selecting value in list based on separate value

Featured Replies

  • Newbies

I have a layout termed job list that is set up in list view with all of the records. I have a field defined as terms. It has a value list defined with 4 values in a pop-up list that are: (1)Due upon receipt, (2)net 30 days, (3)payable at closing and (4)Paid, Thank you. On the same layout, there is a field defined as paid status with 2 radio button values set as (A)paid and (B)pending. When one of the three values in the terms field are selected; (1)due upon receipt,(2)net 30 days or (3)payable at closing, I would like for the (B)pending radio button in the paid status field to be highlighted. If (4)Paid, thank you is selected, I would like for the (A)paid radio button to be highlighted. Can this be done? Users are required to select one of the four values from the terms field, but not required to select the paid or pending from the paid status field. A script would solve my problem because I have a separate script that sorts the paid and unpaid accounts based on the paid status field.

IIUC, you want the PaidStatus field merely to reflect what the user selected in the Terms field.

If so, make PaidStatus a calculation field (result is text) =

Case ( Terms = "Paid, thank you" , "Paid" , "Pending" )

(or something like that - it's not clear if (1) and (A) are parts of your value lists or what).

  • Author
  • Newbies

It worked, thank you. I was missing the quotation marks around the value list values.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.