Populate a field from a report

Question

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?

MCFNeil · Answer

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.

Sign up

Login to the community