Extracting Data from Repeating Table - InfoPath Dev
in

InfoPath Dev

Extracting Data from Repeating Table

Last post 04-18-2016 01:31 AM by wilkies0106aw. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 04-15-2016 07:10 AM

    Extracting Data from Repeating Table

    Let’s start with the basics: 

    Think holiday or time and billing form.

     On the front end users have: Start Date End Date Hours


    i.e.

    Start 11/04/2016 End 16/04/2016  Hours : 35


    How can I turn those dates into a list of dates and hours i.e.


    11/04/2016 7

    12/04/2016 7

    13/04/2016 7

    14/04/2016 7

    15/04/2016 7


    Each date entry is a separate entry published to a list? I'll need to include other details such as user name.


    The end result is that the data is going to be pushed to an SQL table.


    I had thought about a repeating table, yet I don’t know how to turn the start – end into an individual list.

     

    W 


  • 04-15-2016 10:30 AM In reply to

    Re: Extracting Data from Repeating Table

    Oh interesting. I mean, my first question is "why", but we can skip that, I'm sure you have a valid reason. This is going to take code (or qRules if you use that...) in code, I'd loop, creating a new row in my repeating table inside the loop until I have as many rows as days.
    Hilary Stoupa

  • 04-18-2016 12:16 AM In reply to

    Re: Extracting Data from Repeating Table

    Thanks 

    The why......'old system, fit into new system'.

  • 04-18-2016 01:31 AM In reply to

    Re: Extracting Data from Repeating Table

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.