I have a SharePoint form for recording expenses, which uses a sublist to hold the individual items for the monthly expenses. The sublist automatically numbers each item and there is also a total expenditure field that holds a sum of all items in the sublist:
This works fine when items are added but if I remove an item from the sublist, the Item No field is out of order:
To automatically calculate the item no I use two lines of code. The first is set to run on form load:
window.lastPositionNumber = [[@SubLists.Monthly_Items.Item_x0020_No.Max]];
The second is used as the calculated expression for the Item No field:
I can see that my code doesn't take into account if an item is deleted from the sublist, but I wondered if this is possible? I'm not sure if there is a way I can test for whether an item has been deleted and then recalculate the item numbers accordingly?
I'd be grateful for any advice anyone could give. Thanks in advance.
Please sign in to leave a comment.