0

Show Ninox's Unique ID Number In Field

Hello. I'm trying to calalogue my files and want them in folders labled the same as the Ninox's ID for the record to make it easier to find as I can't find a direct way in Ninox to open Finder to the folder location. I would like a text code before the ID number if at all possible ie ABCD001? I would also like if it can be done for records 1-99 to be able to have leading zero(s) as I have upto 800 records and would like all the ID Codes field to have a number of letters followed three numbers 001-800.

 

Many thanks again

2 replies

null
    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    Does this give what you need:

    "ABCD" + format(number(Id), "000")

    • Home
    • Peter_Johnson
    • 3 yrs ago
    • Reported - view

    Hello Alain.

    Thank you for your advice. This is excatly what I wanted and works an absolute dream. Thank you so much for your support, Now I can finally get my files and folders in order now to match the system.

    Peter

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 933Views