Populate a field from a report

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
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? 
Photo of SF

SF

  • 222 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
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.