If you’re on iOS/iPadOS, I’d just copy the values out and paste into Numbers (Apple’s spreadsheeting tool) or Excel (free for phones, I think a charge exists on iPads). If you change the console output to use commas, it should paste fine.
A small change could also directly put this on your pasteboard:
var lines = [];
// log to console the aggregated values.
for (var month in rollups) {
var line = month + "," + rollups[month]
console.log(line);
lines.push(line);
}
Utils.copyTextToClipboard(lines.join("\n"));
The Mac version of Tap Forms has some charting functionality, I’m not entirely sure if it supports aggregation or not but that would be the first place I’d look. Supporting aggregation seems like a reasonable feature ask if it doesn’t exist but that can only be answered by the Keymaster.
If you’re on the Mac, then an alternative could be to just write it to a new form and then chart it. To do this is going to be a bit more of a rewrite so that we can sort things easier
function Aggregate_By_Date() {
// this is where we're going to store the rollups per day.
var rollups = {};
// iterate to all of the records in the form
for (var rec of form.getRecords()) {
var purchase_date = rec.getFieldValue('fld-ccbd9a8f51d34246bebfb31aa4e397dd');
var price = parseFloat(rec.getFieldValue('fld-08129d71ab0f4fa4a2749456281fca07'));
// Skip entries that don't have a price or date set.
if (!price || !purchase_date) {
continue;
}
// format the date for use in the rollup.
var formattedDate = purchase_date.getFullYear() + "-" + purchase_date.getMonth() + "-" + purchase_date.getDay();
// Rollup to this date, add to the existing value or set it if not set.
rollups[formattedDate] ? rollups[formattedDate] += price : rollups[formattedDate] = price;
}
// Get the rollups form.
var rollupsForm = document.getFormNamed("Rollups");
// Delete previous roll up records.
rollupsForm.getRecords().forEach(rollupRec => rollupsForm.deleteRecord(rollupRec));
var lines = [];
// log to console the aggregated values.
for (var month in rollups) {
var line = month + "," + rollups[month]
console.log(line);
lines.push(line);
var rollupRec = rollupsForm.addNewRecord();
rollupRec.setFieldValue("fld-cd1d454672c84bce8103a4267507ca03", month);
rollupRec.setFieldValue("fld-9eeeff7120db401b830ccec4e06f2bc3", rollups[month]);
}
document.saveAllChanges();
Utils.copyTextToClipboard(lines.join("\n"));
}
Aggregate_By_Date();
Change to match the form name and field IDs but that should populate a new form with the records in the right format. Then you can use the chart feature on the Mac to visualise it.
Major changes in the full script, the formatted date is done by getting each value out:
// format the date for use in the rollup.
var formattedDate = purchase_date.getFullYear() + "-" + purchase_date.getMonth() + "-" + purchase_date.getDay();
This produces a format that is easier to sort on but not zero padded, doing so would require grabbing the sprintf implementation via the Script Manager so I’ve left it out for simplicity sake.
Next big change is our loop, I’ve incorporated the above pasteboard change but the core is as follows:
// Get the rollups form.
var rollupsForm = document.getFormNamed("Rollups");
// Delete previous roll up records.
rollupsForm.getRecords().forEach(rollupRec => rollupsForm.deleteRecord(rollupRec));
var lines = [];
// log to console the aggregated values.
for (var month in rollups) {
var line = month + "," + rollups[month]
console.log(line);
lines.push(line);
var rollupRec = rollupsForm.addNewRecord();
rollupRec.setFieldValue("fld-cd1d454672c84bce8103a4267507ca03", month);
rollupRec.setFieldValue("fld-9eeeff7120db401b830ccec4e06f2bc3", rollups[month]);
}
document.saveAllChanges();
We’re getting a form named “Rollups”, we’re going to clean it out each script run and then as we go through the rollups, we’ll add a new record and set a text field and a number field. We need to tell Tap Forms to save the changes as well which is the last line of that snippet. As with previously, replace the field ID’s with your own.
When doing this roll up, if in your main form you add a new script field (I called mine “Purchase Date Simplified”) and put this content in it:
function Purchase_Date_Simplified() {
var purchase_date = record.getFieldValue('fld-ccbd9a8f51d34246bebfb31aa4e397dd');
if (!purchase_date) {
return;
}
// format the date for use in the rollup.
return purchase_date.getFullYear() + "-" + purchase_date.getMonth() + "-" + purchase_date.getDay();
}
Purchase_Date_Simplified();
Then in your rollup form you can create a new “Link to Form” field, link it to the original form, then you set it to the JOIN type and you can match the text field to the script field. Then you can easily go from a roll up record to see which items were in the rollup.
