0

Multiple Choice items on print invoice

I have a multiple choice box with 8 options.  On the printed invoice I must break each of those out with a X in a box in front of each item.  

I can make it work as long as only 1 line item is selected, but if additional line items are checked in the multiple choice box--the X does not appear on the invoice.  

I was using .  if 'service' = 1 then X

Can someone please help? 

7 replies

null
    • Kari.1
    • 4 yrs ago
    • Reported - view

    Anyone have any ideas on this?

    • netSME_Sylvain_Moesching
    • 4 yrs ago
    • Reported - view

    Have you tried for each option to use  if chosen('service') like "label..." ?

    • Kari.1
    • 4 yrs ago
    • Reported - view

    No, I haven't -- I will try that.  Thank you so much!!

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view
    • Kari.1
    • 4 yrs ago
    • Reported - view

    I'm still struggling and can't get this to work.  Here is my multiple choice options:

    Services:

    Develop 1

    Revise 2

    Adopt 3

    Modify 4

    Submit 5

    My invoice

    Text w/border (code put here) Develop

    Text w/border (code put here) Revise

    ....

    What I need is to have the text w/ border insert an X if the service is checked on the form.  My problem is that I can get it to work ONLY if a single box is checked.  I can't get the X if more than one box is checked.  Can someone assisdt me by providing code?  Thank you

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Since a 4 option multiple choice field can give 16 states it will be difficult to extract which options are selected. You can use string('Multiple Choice') to determine which state of the 16 states it gives ( see this post: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/if-statement-not-running-5e055e968ffdac33e8165f3b?post=5e0850898ffdac33e8165fa1&page=1

     

    and maybe with a 'case' loop determine what you want... Personally, in your case I would use check box (Yes/No) fields instead.

    Steven

    • Kari.1
    • 4 yrs ago
    • Reported - view

    Steven, that was what I was afraid of.  I will have to go convert all the records.  But I agree that is the easiest way to do it.  There are actually 13 choices--yikes!

    Thank you so much for taking the time to respond.

Content aside

  • 4 yrs agoLast active
  • 7Replies
  • 1288Views