Parent child grandparent

  • Knack Hacks NEEDED

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

Hi James,

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.

Hugo

Thanks Hugo.

Was hoping to avoid it. But may be only thing that makes sense