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
hank you very much Jeff for the quick response and suggesting 2 solutions! 1st solution will work better in my case.
------------------------------
Mrunali Kadam
------------------------------
------------------------------
Mrunali Kadam
------------------------------
Hi Jeff,
I'm trying to combine both checkboxes selection in one new column on the report called change type. Because we've such 5 checkboxes and instead of going through each column, it's easy to see only one column which shows everything.
I'm creating formula but it's not working when both checkboxes are selected. Please advise.
If([Create or Delete a Product] = true, "Create or Delete a Product",
[Provision a Data Store] = true, "Provision a Data Store",
[Create or Delete a Product] and [Provision a Data Store]= true, "Create or Delete a Product, Provision a Data Store",
" ")
------------------------------
Mrunali Kadam
------------------------------
I'm trying to combine both checkboxes selection in one new column on the report called change type. Because we've such 5 checkboxes and instead of going through each column, it's easy to see only one column which shows everything.
I'm creating formula but it's not working when both checkboxes are selected. Please advise.
If([Create or Delete a Product] = true, "Create or Delete a Product",
[Provision a Data Store] = true, "Provision a Data Store",
[Create or Delete a Product] and [Provision a Data Store]= true, "Create or Delete a Product, Provision a Data Store",
" ")
------------------------------
Mrunali Kadam
------------------------------
- Your line with AND need the =true for both conditions.
If(
[Create or Delete a Product] = true, "Create or Delete a Product",
[Provision a Data Store] = true, "Provision a Data Store",
[Create or Delete a Product]= true and [Provision a Data Store]= true, "Create or Delete a Product, Provision a Data Store",
" ")
------------------------------
Jeff Peterson
------------------------------- Thanks Jeff! I modified the condition but it's still not working. Looks like 1st condition is true so report is just showing that text and not checking the next conditions.
------------------------------
Mrunali Kadam
------------------------------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
------------------------------
