Discussions

 View Only
Expand all | Collapse all

Populating checkbox text/label on the report

  • 1.  Populating checkbox text/label on the report

    Posted 06-23-2022 15:25
    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:

    Report:

    Is there a way I can show actual text or name of that checkbox in the report instead of yes/no? If multiple checkboxes have been  selected then can we handle that scenario? 

    Thanks in advance!

    ------------------------------
    Mrunali Kadam
    ------------------------------


  • 2.  RE: Populating checkbox text/label on the report

    Posted 06-23-2022 16:12
    Edited by Jeff Peterson 06-23-2022 16:16

    You can just create a formula text field for each of these and use if statements to handle it like this:
     
    If([Create or Delete a Product]=1, "Product Created or Deleted", "Product Not Created or Deleted")   

    Then show that field in your report instead.

    Alternately:

    You can use report formulas to do this directly in the report.   

    In the report builder,  under the 'Report Formulas' Section,  create a new report formula and enter the formula above:

       


    That formula will then appear as a column you can add to the report.

    Note that these values would only be visible in that report and not usable anywhere else (if that matters for your purpose).

    ------------------------------
    Jeff Peterson
    ------------------------------



  • 3.  RE: Populating checkbox text/label on the report

    Posted 06-23-2022 17:35
    hank you very much Jeff for the quick response and suggesting 2 solutions! 1st solution will work better in my case.

    ------------------------------
    Mrunali Kadam
    ------------------------------



  • 4.  RE: Populating checkbox text/label on the report

    Posted 06-24-2022 11:50
    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
    ------------------------------



  • 5.  RE: Populating checkbox text/label on the report

    Posted 06-24-2022 12:07
    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
    ------------------------------



  • 6.  RE: Populating checkbox text/label on the report

    Posted 06-24-2022 13:02
    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
    ------------------------------



  • 7.  RE: Populating checkbox text/label on the report

    Posted 06-24-2022 13:10

    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
    ------------------------------



  • 8.  RE: Populating checkbox text/label on the report

    Posted 06-24-2022 13:34
    Great! It worked! Thanks Jeff and a nice weekend.

    ------------------------------
    Mrunali Kadam
    ------------------------------



  • 9.  RE: Populating checkbox text/label on the report

    Posted 06-24-2022 17:23
    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
    ------------------------------



  • 10.  RE: Populating checkbox text/label on the report

    Posted 06-24-2022 20:46
    @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
    ------------------------------



  • 11.  RE: Populating checkbox text/label on the report

    Posted 06-27-2022 09:48
    Thank you Mark!

    ------------------------------
    Mrunali Kadam
    ------------------------------