SharePoint Integration

Re: Check list autonumber and increment by 1

Hilary Stoupa — Thu, 21 Sep 2017 14:48:37 GMT

If you are returning all the IDs, I'd think you'd use the max function - max(SelectIDFieldHere) + 1

Re: Check list autonumber and increment by 1

shabbaranks — Thu, 21 Sep 2017 11:37:14 GMT

Just to modify this slightly I've changed the way the submit works. So I've created a data connection which queries the SharePoint list and retrieves the ID list number. In theory the submit then sets the field Im trying to assign a the number ID = 1 and then submits the data.

What's happening now is I'm getting the word false in the fields textbox before submission.

Check list autonumber and increment by 1

shabbaranks — Thu, 21 Sep 2017 10:08:00 GMT

Hi,

I cant seem to work out how I achieved this last time but when I am trying to do is query a SharePoint online list (column) and increment the number by one. I've added the data connection to the form load and the fields type is number. Within the field I have added a formula of count(preceding-sibling::*) + 1 but all I get is the starting value 1 where I have already submitted a test form so in theory the value should be 2?

Thanks