0

Record create date function

Hello Ninox community,

I wanted to create a field that displays the record creation date and which user created the record. Would it be possible to do this? And would it be possible to display this in a singular field instead of two? Thanks for any help on this. 

4 replies

null
    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    create a date filed  and call it ie created

    in the default value put Today

    whne you creat a new recods todays date will be auto input in that filed ( or yyoy can overtyope on old records)

    now add a formula field 

    and enter in that filed script

    userFullName() + " " + Created

     

     

    note - I have used userFullName but you have other options ie firstname the id etc

      • Zhu
      • 2 yrs ago
      • Reported - view

      Mel Charles Thank you for the reply! Is there a way to find date created for previously created records? Or would I have to go back and select them all manually. 

    • Fred
    • 2 yrs ago
    • Reported - view

    I'm guessing you are using the cloud version since you mention users. You can use the Created On and Modified On function.

    See this Nioxus post for more info.

    • Ninox developper
    • Jacques_TUR
    • 2 yrs ago
    • Reported - view

    table._cd return création date of record. 
    table._md modification date. 
    table._cu  creator  
    rable._mu modifier

    Formula exemple :

    “Created on “ + this._cd + “ by “ + this._cu;

Login to reply

Content aside

  • 2 yrs agoLast active
  • 4Replies
  • 274Views
  • 4 Following