Automate

 View Only
  • 1.  Use 'Upload Excel Data' to upload repeating content in repeating content

    Posted 27 days ago
      |   view attached

    Hello,

    I'm trying to create a form that has several scripts that need to loop and have additional loops inside them.  When pulling the repeating content into the form I get both sections but the upload excel data function only seems to hit the first loop level and can't be toggled on the second.  Is there a way to upload data into the second loop?





    ------------------------------
    Scott Fouss
    Shared Services Analyst
    Leprino Foods
    ------------------------------

    Attachment(s)

    Txr
    BP_FINISH_SHIP_TO - Test.Txr   1.43 MB 1 version


  • 2.  RE: Use 'Upload Excel Data' to upload repeating content in repeating content

    Employee
    Posted 26 days ago

    Hi Scott,

    'Upload Excel Data' functionality is not available for nested tables, neither we can use 'Copy Table Data' rule.

    One way to do it is :

    • Create a repeating table on the form, upload the data in this table using 'upload excel data' option
    • Now using 'Data connection' webservice  of type reference data upload this Data from repeating table to a reference list.
    • Next using a query control fetch this data on the form in Nested repeating table as per requirement.

    Refer Solution, Reference list and excel file attached on link : https://nowtransfer.de/9a17d23e03fa

    • Once you import the solution and the reference data list.
    • Deploy the solution.
    • Launch the form, On launched form upload the excel data, and press save button -> this will save data in the reference data list.
    • Click on fetch button in group4 to fetch the data in the nested table.
    • Once the data is fetched, you can click Empty table button to clear the table and click SaveData button to clear the list as well.

    NOTE :

    If your data to be uploaded in the nested table is static or does not change, you can simply create a reference data list with this data and fetch it using a query control.

    Hope this helps.

    Regards



    ------------------------------
    Hammad Naeem
    Precisely Software Inc.
    ------------------------------