changing the second field values

[Nippon Maru]

Hi,

Can anyone help me how to solve this ?

I have a 2 drop down list field on my portal with two values in each field .  Is it possible When I select the first or the second values from the first field it will change the second field values based on the value of second field using the conditional formating Formula...?

e.g field(1) have two values from Drop-down List (Pass) and (failed)
    field(2) have two values from Drop-down List (Good) and (Bad)

If I select (Pass) it will change the second field values to (Good) automaticly and commet the record

Or if I select (failed) it will change the second field values to (Bad)

Ahmed

 

[Lee Smith]

Do a search for Conditional Value List.

[bcooney]

Nippon,

If there is only one choice in field(2), then you are creating an unnecessary field, and do not need a conditional value list.

Can you describe your use case using your real situation rather than abstract terms? How many choices are in field1 (use actual field name please)? 

[Pavlk]

Make Field 2 of a Calculation Type with the next formula:

If ( Field1 = "Pass" ; "Good" ; "Bad" )

 

Edited January 24, 2018 by Pavlk