Discussions

Expand all | Collapse all

Populate a field from a report

  • 1.  Populate a field from a report

     
    Posted 05-02-2018 21:36
    I have a report that adds up the total number of checkboxes checked for various different items in a table. Is there a way to use this information to populate fields in a different table? 

    For example, option 1 was checked 5 times, option 2 was checked 8 times and option 3 was checked 4 times. I would like to use this information to make a seperate table that looks like:

    Options             # of checks
    Option 1                   5
    Option 2                   8
    Option 3                   4

    How do I use the report to populate the # of checks field? 


  • 2.  RE: Populate a field from a report

    Posted 05-03-2018 03:50
    If this is a one off thing you can create a summary report and export, or use it in the original table.

    If you are going to run this report often, or have some criteria for when those are checked...
    You can create a 'placeholder' table that has one (1) record in it. Then connect all the records in the checkboxes table via a formula reference field.  
    Then you can create a bunch of summary fields for the # of records where 'x' box is check, etc.

    Again, if you can do this with a summary report, I'd go that route.