Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7174 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

Posted

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

This topic is 7174 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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