Hello! This might be an unusual request, but I am looking for a way to create and stamp a new submission ID on multiple records each time a bulk edit is submitted for a particular DataPage. The ID needs to be unique to other IDs, but it will be stamped on multiple records in the table at the point of submission. My thought was to create a hidden field with a default value, which would be a combination of a prefix (i.e., WO-) and then a system parameter (i.e., [@cbTimestamp]). The problem I'm running into is that I would like the date to be broken down into a numeric string instead of having spaces and punctuation, such as dashes and colons.
This is what I'm currently getting: WO-08/30/2017 11:34:46. I would like to get this instead: WO-1504110886. Any ideas on this? I very well may be overthinking things, so I welcome suggestions. We don't have to use the timestamp at all, but it was just an idea for how to create a unique ID at the point of submission.