I have a credit card expenses form which contains a sublist where the user enters all the items they've bought. I want the Item No field to automatically populate so the first row is 1, the second 2 and so on. However, I'm having trouble getting this to work.
I tried using [[@SubLists.Credit_Card.Item_x0020_No.Max]]+1 but this continually adds 1 to the field as the max value is also always changing. I also can't use the ID field of the sublist as this wouldn't start at 1 for each new form.
I'd be grateful if someone could let me know if this is possible? If it's not I'll just have to get the users to enter the item number manually but ideally would rather it was done automatically.
Thanks for your help in advance.