I am trying to use a formula in Infopath 2013 to accomplish the following (btw I'm a IP noob - and not even conceived in SPD2013 )
- Set the autonumber field equal to 1 when count(@ID) = 0
- Set the autonumber field equal to max(@ID) + 1 when count(@ID) > 0
To me it would seem like a simple if/than statement but that's not one of the options in the "Insert Function" dialog box.
Thanks.
So you know what I'm trying to accomplish, I need to have a form saved with a unique number. The now or today funtion won't work as it creates names that are too long.I would like the names to be "SIR - 001, SIR - 002, etc)