Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Create number of records in 1 table based on Qty Field in another table

Topic Labels: Scripting extentions
1223 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Harry_McDonald
6 - Interface Innovator
6 - Interface Innovator

Hey there,

I’m hoping someone will be able to help (my scripting ability is limited) - I want to be able to create a specific number of records in Table 2 based on the Qty field in Table 1.

I have a script which creates a singular record in Table 2 from the data in Table 1 but does not consider the QTY field and creates the X number of rows.

Would anyone be willing to help please?

Thanks in advance

2 Replies 2
Harry_McDonald
6 - Interface Innovator
6 - Interface Innovator

Screen Shot 2022-09-05 at 11.43.33 am

Harry_McDonald
6 - Interface Innovator
6 - Interface Innovator

Solved by changing ‘originalLineItem.Length’ to ‘Quantity’ input variable.