Adding multiple rows based on a defined number

[bradenal]

I am creating an asset management system. How it works is, a trailer comes in with a manifest that has for example 30 pieces. I need to be able to open an app and say Trailer number 122 with manifest number 12433 has 30 pieces on it and click “Create Assets” where it creates 30 assets with incremental numbers from the previous load. I am not sure how to achieve this.

[tim.young]

Hi @bradenal

Welcome to the Tadabase Community! Happy to have you here.

This can be tricky to achieve - can you please let me know if this helps?

Create X amount of connected records based on a Number field

In the following video, I will demonstrate how to create X amount of connected Child records based on a Number field in the Parent table. NOTE: I added one more Parameter after recording the video called flagValue. This way, you can reuse the Pipe for other Parent/Child tables with different flag values. For example, instead of a hard-coded ‘Yes,’ you can use ‘True’ or any other Radio value you might have. [image] [image] Here’s the code for the Request. Please remember to up…

[moe]

Like @tim.young mentioned.

Or, you can also use the “Tadabase Record Looper” pipe.

If you need help setting it up, please let me know and I’d be happy to explain further.

[Aprada]

Hi Moe, can you explain a little more about the looper? I don’t understand the script code in request, maybe is inherited from an example?

[moe]

Here’s a very short video demonstrating this pipe:

record Looper

In the video I didn’t show you, but I first added the API credentials in the Global Parameters.

[Aprada]

Tks a lot! Pretty clear

[slimpens]

@moe
Is there a way to add addtional data to the 5 new records? E.g. Autofill/ pre-populate certain fields with certain data??