Automate

Hello,

I have made a script for the MIRO transaction for Evolve that reads the line items from the currently selected purchase order in MIRO. I have a loop in the script for the line items and so it is in the Evolve form as a repeating table. The read script will also read the number of line items from the PO and populate a "number of items" field in the form with a number.

I would like to automatically set the number of rows in the repeating table to match the number in the number of items field. For example, the read script reads a PO in MIRO with 5 lines and populates the number of items field to 5. I am wondering how to use this value to set the rows in the repeating table. I know there is an "add new row" rule but if someone decided to click a different PO with a different number of line items, I don't see a way to delete those rows/add more rows to the existing row count. Please let me know if there is a way to do this.

Thanks for the help,

Ryan Hipson

------------------------------
Ryan Hipson
Clearwater Seafoods
------------------------------

Hi Ryan

If you have two structures in your form, one for the PO and one for MIRO, please try the COPY TABLE rule. 

It will let you copy from the PO output (source) into the MIRO input (target) table with mapping and even conditions, as needed.  It was designed for something just like this.  You just have to decide when to trigger it.  Some documentation is located here:  https://help.precisely.com/r/Automate-Evolve/Latest/en-US/Automate-Evolve-User-Guide/Solution-Developer-Help/Rules?tocId=5OUlwawXzU1DjnBQfw3r1w 

Best Regards,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 04-22-2024 11:07
From: Ryan Hipson
Subject: Winshuttle Evolve - Automatically Set Rows Based on Field Value (Repeating Table)

Hello,

I have made a script for the MIRO transaction for Evolve that reads the line items from the currently selected purchase order in MIRO. I have a loop in the script for the line items and so it is in the Evolve form as a repeating table. The read script will also read the number of line items from the PO and populate a "number of items" field in the form with a number.

I would like to automatically set the number of rows in the repeating table to match the number in the number of items field. For example, the read script reads a PO in MIRO with 5 lines and populates the number of items field to 5. I am wondering how to use this value to set the rows in the repeating table. I know there is an "add new row" rule but if someone decided to click a different PO with a different number of line items, I don't see a way to delete those rows/add more rows to the existing row count. Please let me know if there is a way to do this.

Thanks for the help,

Ryan Hipson

------------------------------
Ryan Hipson
Clearwater Seafoods
------------------------------

Hi Sigrid,

I am currently pulling up the PO by using a query script to search the PO in the EKPO table. This is working fine and querying all of the rows of the PO. I then want to be able to copy this data to my write script fields, however when I use the copy table rule to copy the query table data to the write script line items (repeating content loop), it only copies over the first row. I tried with a different table, and it copied all rows leading me to believe the problem is the query table not working with the copy table rule.

Any advice of this? Thank you for your help.

Hi Ryan

If you have two structures in your form, one for the PO and one for MIRO, please try the COPY TABLE rule. 

It will let you copy from the PO output (source) into the MIRO input (target) table with mapping and even conditions, as needed.  It was designed for something just like this.  You just have to decide when to trigger it.  Some documentation is located here:  https://help.precisely.com/r/Automate-Evolve/Latest/en-US/Automate-Evolve-User-Guide/Solution-Developer-Help/Rules?tocId=5OUlwawXzU1DjnBQfw3r1w 

Best Regards,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 04-22-2024 11:07
From: Ryan Hipson
Subject: Winshuttle Evolve - Automatically Set Rows Based on Field Value (Repeating Table)

Hello,

I have made a script for the MIRO transaction for Evolve that reads the line items from the currently selected purchase order in MIRO. I have a loop in the script for the line items and so it is in the Evolve form as a repeating table. The read script will also read the number of line items from the PO and populate a "number of items" field in the form with a number.

I would like to automatically set the number of rows in the repeating table to match the number in the number of items field. For example, the read script reads a PO in MIRO with 5 lines and populates the number of items field to 5. I am wondering how to use this value to set the rows in the repeating table. I know there is an "add new row" rule but if someone decided to click a different PO with a different number of line items, I don't see a way to delete those rows/add more rows to the existing row count. Please let me know if there is a way to do this.

Thanks for the help,

Ryan Hipson

------------------------------
Ryan Hipson
Clearwater Seafoods
------------------------------