Populate a field from a report
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 exam...
Forum Discussion
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.
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.
