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.
-
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
-
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.
-
-
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.
-
table._cd return création date of record.
table._md modification date.
table._cu creator
rable._mu modifierFormula exemple :
“Created on “ + this._cd + “ by “ + this._cu;