Hello,
I have a database with 5185 records in 58 categories.
It’s a collection of comic book puzzles, and the different categories correspond to the comic book titles, as shown in the screenshot.
In the database, there are two scripts that highlight puzzles in the collection and those that are incomplete (scripts created by a form user at least 6 years ago).
I would like to automatically retrieve the number of puzzles in the collection and the number of missing puzzles for each category into a table.
I don’t know if this is possible with a script, and I don’t know how to do it either, as I’m not familiar with scripting.
Thank you for your information, and perhaps it’s not feasible. The screenshots show my database, the relevant fields, and a table as it could be created.
Attachments:
You must be
logged in to view attached files.
Your best bet for now would be to export your records to an Excel spreadsheet and then import it into Excel (or Numbers) and do some summarization there. At the moment I don’t have a function that would do that. Tap Forms will compute totals for each category, but it will also display the details.
But of course you could write a script for it to just dump out the summary data in the console. But it would be easier for you to use Excel. Especially if you’re not familiar with scripting.
Thanks,
Brendan
Hi Brendan,
Thanks for your response
I’ill test with Excel 👌
This shouldn’t be difficult to do with a script. Would you be willing to share your Tap Forms template with me? (You can find it under File > Export > Form Template (TFF). If you’d rather, feel free to email it to me. Once I have the template, I’ll give it a shot.)
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
.
