Flexibility of a script but functionality of a calculation field?
I have a layout which has about 200 locations for information to print out. Most of these are to be filled in with counts corresponding to complex searches (eg, Male/Female, Hours worked > 0, age>40). These sort of operations seem to match well with operations available to me within regular scripts (particularly the Found Set category). But if I tie scripts to buttons, then every button would have to be triggered before printing out. Is there a way to trigger these buttons en masse or is this the wrong approach?
If I set up a calculation field for each of these 200 locations, then the user interface issue seems right, but the sets of operations available to me for calculations doesn't seem to include performing finds and then counting records in the found set.
Thanks for any insight.