Automate

 View Only
  • 1.  VA42 Loop - Update contract with serial number

    Posted 03-21-2023 11:52

    I have to update rental contracts and add serial numbers. Each contract may have different number of line items. I created a loop condition but it's not working. Any inputs would be appreciated



    ------------------------------
    Rohit R
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: VA42 Loop - Update contract with serial number

    Employee
    Posted 03-21-2023 17:34

    Rohit, Can you share your script and data file (dummy data is fine)?

    what part is not working?



    ------------------------------
    Jayasri Varyani
    Winshuttle North America
    ------------------------------



  • 3.  RE: VA42 Loop - Update contract with serial number

    Employee
    Posted 03-24-2023 10:24

    Hi Rohit

    It would be helpful to see what you're doing in your script, as Jayasri suggested. 

    In lieu of that, you have to either know the data you want to update or extract it first.

    (1) if you know which row(s) you need to update, use the position button to find the right row, which moves it to the top row.  Then go into details and update it.

    (2) if you don't know the rows you need to update, extract the data in your contracts with Query (or another method you might have available), update that data and then use option 1 to find those rows and update them.

    Best Regards,

    Sigrid



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