InfoPath Dev

Did you trying mapping the ID to the other list. In mapping tool CLASSID is mapped to the CLASSID in the other list. That way the data written is the same ID. Button can have a rule CLASSID = CLASSID.

If you are re-opening the original form then the CLASSID should be the ID of the list item. Which would update the same ID in the list. If you are opening a new form then your would have to query the list using a date or something to get the ID you want to update. Something like this ID[Title = current()/../your field in form] Little more ...

Might be easier to set a field in your form as created and set it with today() on submit. Then Set your secondary data connection to sort by field you created and descending. Then you can place that field on the canvas and it should show the newest date.

Any update on when this will be live?

Thanks Hilary for the update this is great news!

Each repeating table has an average in the footer. How can I take all the averages and input them into another repeating table to perform the calculations of the example.

This will work but my next question is. I have 12 repeating tables with an Average in the footer. How can I take each avg from the footer and input into this repeating table to apply these functions? Trying to avoid qRules as it doesn't currently work in the browser on o365.

Basically I created a survey. 12 repeating tables with a number of questions in each one. Option button for 1-7 each table has an Ceiling Avg in the footer. How can I calculate the Overall choice? Put all the numbers in the footer in order and pick out the middle.

Anything new with this? Happy New Year

Thanks Hilary