0

How to get Multiple Choice selections to appear on Print

I've looked at some example and still struggling to figure this out and basically I am using an "Invoice" like form and I have to instructions that need to be printed depending on if they are selected in a Multiple Choice Box. For example with Payment Instructions Field, Choice 1 = Pay Instructions, Choice 2 = Bank Routing, Choice 3 = Payment Terms. If all three are selected, all three sets of instructions would be printed and so. I was thinking maybe a Formula Field using If Statements or something as an idea.

6 replies

null
    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    Hi Holly

    Hint - add your fomula field to layout and set it as something like this :-

    if xyz = 1 then "this is test line1" or if xyz = 2  then "this is test line 2" end

    insert your field anme for xyz 

    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    Holly

    If you have your messages in other fields then you can just point to them.

    also you may find this useful

    https://ninox.com/en/manual/calculations/reference-of-functions-and-language

    Mel

    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    case will work too

    switch Status do
    case 1:
    "line1"
    case 2:
    "line2"
    default:
    "Line3"
    end

    all of above are hints to show ONE selected option but you should be able to build on this using OR etc

    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    soryy menat to say combindation of OR or AND in your statements

    • Holly_M
    • 4 yrs ago
    • Reported - view

    Thanks Mel and I did try the Formula approach with an IF statement and it worded well!

    • saffron_car
    • 3 yrs ago
    • Reported - view

    Hi, I have a similar problem with a Dynamic Multi Choice field.

    How Can i get it appears on a print layout ?  I can't fix it ..

    thanks  in advance

Login to reply

Content aside

  • 3 yrs agoLast active
  • 6Replies
  • 608Views