July 26, 201213 yr Hi, I don't know is possible to define a field with an automatic intro of 12 digits number: year/month-Day-hour-minute-second (12/0726184752). Is possible? Thanks!
July 26, 201213 yr No, but it is possible to enter a serial number and translate it (in a calculation field) to the corresponding timestamp. What would be the purpose here?
July 26, 201213 yr No Why not ? For example this: Let( t = Get ( CurrentTimeStamp ) ; Right ( Year ( t ) ; 2 ) & "/" & Right ( "00" & Month ( t ) ; 2 ) & Right ( "00" & Day ( t ) ; 2 ) & Right ( "00" & Hour ( t ) ; 2 ) & Right ( "00" & Minute ( t ) ; 2 ) & Right ( "00" & Seconds ( t ) ; 2 ) ) in an auto-enter text field. Naturally NOT to be used as an unique ID.
July 27, 201213 yr Author Thanks, really works!! "Serial" number (for each job in my case) is necessary discontinued because the same number is an FTP access, thus in a single day there are 86400 possible numbers and never can be repeated a number
July 27, 201213 yr the same number is an FTP access, Not sure what that means. in a single day there are 86400 possible numbers and never can be repeated a number No, that's not true. There are 86400 seconds in a day, and if you (or another user) create more than one record in the same second, you will have a duplicate.
Create an account or sign in to comment