I have a SP list from which I want to dispense calculated lot numbers, that is, the user clicks New, and a form opens with the new, calculated lot number. When saved, the lot number is committed to the list, along with some details the user has filled out. An example of the lot number format is D11005-01, D standing for the decade of the '20s, D1 meaning 2021, 1005 meaning October 5, and the 01 is a sequential suffix...but the format isn't particularly important; I can build that out.
My problem is that if it's calculated in a Nintex form (I'm using New Responsive), it can be viewed immediately, but apparently can't be saved back as a SP column. If it's a calculated SP column, it can't be viewed in the New form because it only gets calculated when the item is saved. Am I stating this correctly? Do you have any ideas for getting around this problem?
Solved! Go to Solution.