Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Hide Checkboxes


Recommended Posts

I have a sales module which uses conditional value lists to populate checkbox sets for product options on different products. For products with no options, I have a single checkbox with the title "no options available." This is fine for the people making sales, but I need to also print this information on invoices.


Is there anyway for me to hide the checkboxes on my invoice report if there are no choices selected?


Does this make sense?

Link to comment
Share on other sites

If you display the field as a normal field without checkboxes, the selected options will show as a list (return-separated). If there are no options selected, the list would be empty.


So on your invoice I would use a CheckboxDisplay field with the calculation:


Case(IsEmpty(CheckboxField); "No options available"; CheckboxField)


And make sure you uncheck the option "Do not evaluate if all reverenced fields are empty" so it always returns a result.


Bonus Tip: If you want the selected options to display as a comma separated list, use this calcualtion:


Case(IsEmpty(CheckboxField); "No options available"; Substitute ( CheckboxField ; "¶" ; ", " ))

Link to comment
Share on other sites

Thanks, that seems like it will work nicely.


I still have on problem though. My product options display as a checkbox set of titles, but they actually add IDs to the field to get the price of the option from another table. If my field contains the IDs of product options, how can I display the names of the options as a list?

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use