To create a template project with tasks and checklist per task, means Parent child grandparent tables and records.
Knack does this well. But to create a duplicate of all Parent child grandparent. We need to use flows.
But when we have 10 projects with 32 tasks and a checklist per task that varies from 3-30 items. The transaction count goes through the roof.
We only have 2000 transactions per month, just one project would take up to 1000 items with possibly 3 transaction to find and duplicate a create an item making 3000 transactions for just one project.
Is there a way around this? The alternative is Tadabase as they have one action to do this . Not what I want . But any situation with templates are making knack difficult
For this kind of thing I always use Make.com; it is a fairly common use case and not normally complex to build. It is perfect for getting a bit more out of Knack (as well as integrating it with other tools). And most organisations don’t go beyond the $9 package.
If you use JS and code it out, it will be cheaper.
Your Daily API call for pro version is 3,000 call and reset every night.
This mean that if you are triggering an event task template.
You are creating all the record in that template in a day. So if you have 10 record in the template and you want to clone 10, the API will call 10 time.
This is far cheaper than your transaction base or use flow.
Just have to code it out. I am experimenting with it right now.