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. 

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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

    Like 1
      • LZhu
      • Zhu
      • 3 mths 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. 

      Like
    • Fred
    • Fred
    • 3 mths 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.

    Like
  • 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;

    Like
Like Follow
  • 3 mths agoLast active
  • 4Replies
  • 63Views
  • 4 Following