InfoPath Dev

 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 

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.