Populating checkbox text/label on the report
Hi, I've checkboxes on the form and wanted to use them in the report. In report, it only shows yes/no that is if checkbox is selected or not and doesn't show the checkbox text. Form: Rep...
Forum Discussion
Oops! My fault. The reason is because it evaluates the conditions from the top down and will show the output from the first true argument. Try this code instead:
If(
[Create or Delete a Product]= true and [Provision a Data Store]= true, "Create or Delete a Product, Provision a Data Store",
[Create or Delete a Product] = true and [Provision a Data Store]=false, "Create or Delete a Product",
[Provision a Data Store] = true and [Create or Delete a Product] = false, "Provision a Data Store",
" ")
------------------------------
Jeff Peterson
------------------------------
Great! It worked! Thanks Jeff and a nice weekend.
------------------------------
Mrunali Kadam
------------------------------
------------------------------
Mrunali Kadam
------------------------------
- MarkShnier__You
Qrew Legend
@Mrunali Kadam
Try this as a formula Multi-Select field type
Split(List(";",
If([Create or Delete a Product], "Create or Delete a Product"),
If([Provision a Data Store], "Provision a Data Store")))
You will be able to use this field as a Dynamic Filter.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - Is there a way we can show text similar to the format in the below screenshot on the report ?
Right now it just shows next to each other and unable to filter out the specific column for a specific value.
------------------------------
Mrunali Kadam
------------------------------ - Thank you Mark!
------------------------------
Mrunali Kadam
------------------------------
