0

How to make the selection of a value in one choice field force the selection of a value in another choice field

I've tried the following formula, but while it doesn't throw up any error messages, it also doesn't seem to have any effect!

if 'Choice 2' = "A" then
'Choice' := "Q IN"
else
'Choice' := "Q SENT"

What am I doing wrong ...?

2 replies

null
    • Support
    • 6 yrs ago
    • Reported - view

    Hi, 

    as the choince fields do not show the same behavior like a text field you have to use 

     

    if text('Choice 2') = "A" 

     

    to check if it contains a certain text or check for the index number of the value in the value list of the choice field:

     

    if 'Choice 2' = 1

     

    To set the content of a Choice field you have to use the index number of the value in the value list of the choice field:

     

    Choice := 2

     

    Best, Jörg

    • David
    • 6 yrs ago
    • Reported - view

    Brilliant. Thanks!

Content aside

  • 6 yrs agoLast active
  • 2Replies
  • 1981Views