Method:Classic General Q&A

Re: How do I insert multiple records into a table?

seny — Mon, 20 Sep 2010 16:41:13 GMT

Thanks Ryan. I was using that work around, but I found it a little bit awkward. I guess I have to stay that way until there is a better one.

By the way, did you get a chance to see my other post? which is about the PO number from ItemReceiptLineItem.

Would you please let me if you found something? Thank you.

Re: How do I insert multiple records into a table?

Anonymous — Mon, 20 Sep 2010 15:30:14 GMT

Hey Seny,

I to needed a feature like this, and we are looking into adding more loop options. Currently we cannot just loop X number of times, but we do have a work around for now.

Start off with creating a table with a field called "Number" (type = textbox), add a bunch of records numbering each one from 1 to 50. Now on your screen, in the list of actions, use an Action Result to capture the number of Items to create in your Asset table. Next use the "Loop Through Table" action, and loop through your temp table. To stop your loop, use a conditional Statement at the end of your loop(but inside) that says "If Number = (the number of items to enter) stop processing more actions.

This should get you going.

How do I insert multiple records into a table?

seny — Wed, 15 Sep 2010 23:06:02 GMT

If I received a PO, and I want to insert the items I received into anther table (Called Asset), the number of records need to be inserted depends on the Quantity I ordered in the PO, so how do I insert multiple records into the other table (Asset)?