# Large record add without an iteration function

**URL:** <https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252>\
**Category:** Knacksters' Idea Lab\
**Created:** [October 18, 2022, 2:29pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252 "2022-10-18T14:29:08Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![David2](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@David2](https://forums.knack.com/u/David2)\
**Post date:** [October 18, 2022, 2:29pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/1 "2022-10-18T14:29:08Z")

</div>

I have a simple check list app with two primary tables - one for Projects and the other is a table of checklist items. There is a set of over 300 standard checklist items that need to be associated with each project. I am looking for way for a user to add a project and have the 300 new checklist items added to the checklist table, but I can’t figure out how to do this other than creating 300 separate record rules associated with an Add Project page. I can do this as an admin by just doing an import/append to the data base with the 300 items in a CSV file. I think what frustrates me is that Knack does not have an iteration function - like do this until this condition is reached. I am just curious what others might be doing in a similar situation.

![Example 1](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/8/887c115600e1e542b76add41da4a4605ec6db839.png)

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [October 18, 2022, 7:59pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/2 "2022-10-18T19:59:34Z")

</div>

If I understand this correctly, you add a project and want to create a related checklist of 300+ line items from a predefined list / template object.

Knack doesn’t have an append function like you’d find in MS Access. You could do it via record rules but setting up 300+ rules on one form would likely make the submission of that form so long the user would think the page had stopped responding.

I’m happy to be corrected but I don’t believe there is a simple native solution. I’d use Make to create the line items triggering the scenario from the creation of the project. This would still take a few minutes to complete creating all the records so may not be ideal. Depends on whether the user needs to access all 300+ items on the checklist immediately.

Also could be done with JavaScript and may be a lot quicker. Not a coder I’m afraid

---

<div class="post-metadata">

**Author:** ![David2](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@David2](https://forums.knack.com/u/David2)\
**Post date:** [October 18, 2022, 8:07pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/3 "2022-10-18T20:07:41Z")

</div>

Thanks Carl. I had not thought of using Make. General performance of the Knack data base has been spotty lately for me. I am just wondering if I should explore another platform like Bubble - Just thinking out loud.

---

<div class="post-metadata">

**Author:** ![Kat](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/kat/32/2834_2.png) [@Kat](https://forums.knack.com/u/Kat)\
**Post date:** [October 19, 2022, 7:38pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/4 "2022-10-19T19:38:17Z")

</div>

It’s definitely something we’re aware of and working hard to improve as rapidly as possible, because it’s a huge pain point. The move to the new performance environment was a huge first step (even though it might not feel that way yet!) because it is a much more scalable and performant architecture, -but- it requires some further optimization for us to be the best it can be. While I won’t ask you not to test something else, I’d also say stick with us, we’re working on it.

---

<div class="post-metadata">

**Author:** ![Wolfgang\_Brötz](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/wolfgang_br%C3%B6tz/32/1465_2.png) [@Wolfgang\_Brötz](https://forums.knack.com/u/Wolfgang_Br%C3%B6tz)\
**Post date:** [October 21, 2022, 6:35pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/5 "2022-10-21T18:35:02Z")

</div>

> [@CarlHolmes](#):
>
> This would still take a few minutes to complete creating all the records so may not be ideal.

I second your idea to use Make or a task to create the line items. Without knowing exactly your check list app’s requirements, i have been wondering whether a sufficient number of unassigned projects (incl. all connected records) could be produced “on stock” in less busy times. If a “new” projects needs to be assigned to a user, such a “prefabricated” project (most of the fields are still blank) could be displayed in a table view of projects (filtered to “Field(s) abc is blank” & “Use only the first 1 records”). Populating the empty fields in this table view (maybe triggering a rule assigning this project to the current user) will not take very much time.

---

<div class="post-metadata">

**Author:** ![BradStevens](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/bradstevens/32/140_2.png) [@BradStevens](https://forums.knack.com/u/BradStevens)\
**Post date:** [October 21, 2022, 10:05pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/6 "2022-10-21T22:05:25Z")

</div>

As @CarlHolmes said it can’t be done natively in Knack right now without using either of two options:

1. Javascript to create the checklist items from a template list somewhere. We use this for a small number of items like Estimate Items and takes some coding to work.
2. [Make.com](http://Make.com) or Zapier type automation. We’ve found this more robust for higher number of items and have settled on [Make.com](http://Make.com) as our preference.

Either way needs the setup of a Project Type in the Projects table, that has connected Checklist items that creates a ‘template’, then the automation can loop over the items to add them as new items to the new Project.

And we’d love this to be a feature in knack natively @Kat !

---

<div class="post-metadata">

**Author:** ![David2](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@David2](https://forums.knack.com/u/David2)\
**Post date:** [October 22, 2022, 12:04pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/7 "2022-10-22T12:04:29Z")

</div>

Agreed. I’ll look into Make. Seems like the most practical solution at the moment.

---

<div class="post-metadata">

**Author:** ![Godfred](https://avatars.discourse-cdn.com/v4/letter/g/b487fb/32.png) [@Godfred](https://forums.knack.com/u/Godfred)\
**Post date:** [October 22, 2022, 12:17pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/8 "2022-10-22T12:17:02Z")

</div>

David, you can reach out if you need any help with Make.

---

<div class="post-metadata">

**Author:** ![Peter2](https://avatars.discourse-cdn.com/v4/letter/p/d2c977/32.png) [@Peter2](https://forums.knack.com/u/Peter2)\
**Post date:** [October 24, 2022, 12:10am UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/9 "2022-10-24T00:10:12Z")

</div>

I am may be wrong but why wouldn’t you have the checklist items in a table and use an API call to add the checklist items into the project record? I use this function to create standard templates based on established criteria that determines which checklist items to add.  
Pete

---

<div class="post-metadata">

**Author:** ![JulianKirkness](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/juliankirkness/32/770_2.png) [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)\
**Post date:** [October 24, 2022, 9:05am UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/10 "2022-10-24T09:05:24Z")

</div>

Hi @David2

I cover almost this precise scenario in my article series “Programming Knack with [Integromat](https://www.make.com/en/register?pc=kirkness)” (Make now of course):

> **[Blog | Online Database Expert](https://www.onlinedatabase.expert/blog/search/programming)**
>
> Visit our Blog where we review database and other cloud / online platforms and where you can comment.

I hope you find this useful.

Julian

---

<div class="post-metadata">

**Author:** ![David2](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@David2](https://forums.knack.com/u/David2)\
**Post date:** [November 7, 2022, 4:35pm UTC](https://forums.knack.com/t/large-record-add-without-an-iteration-function/13252/11 "2022-11-07T16:35:09Z")

</div>

Juilian: Great series of posts on Knack and Make. I got a lot to learn.
