How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?
No clue as to what is required here
-
maybe with this? :
Get the creation date of the current record: _cd
Get the date of last modification: _md -
Thank you, Steven.
I'm just starting out.
Is there a beginner's guide to Ninox scripting syntax somewhere?
Is there a list of all possible scripting elements somewhere?
Right now, I have a field of type Date/Time labelled "Date Modified". I want to take advantage of Steven's _md, but I have no idea into which option or even into which object to put it. Does it go into my "Date Modified," or is it somehow attached to the record itself?
I also don't know how to build it out into an effective formula. (Sorry for my level of ignorance.)
-
Hi ecom,
First create a formula field. Name this field Created on: or something you want. Use text(_cd) as formula for this field.
I’m also a beginner with Ninox and i find the webinars very interesting!
Sorry for my English... I’m dutch
-
Same for _md
-
Here is the Manual:
https://ninoxdb.de/en/manual/tutorial/tutorial
for the Reference of Functions and Language:
https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
Nick
-
Thank you so much!
-
Still struggling with Date Created and Date Modified using the Mac version 2.4.3.
Date Created, using the formula, "text(_cd)", auto-modified to "text('Created on')", shows proper date and time when a new record is created, but, when I touch the cloud icon and then reopen the record, the date is gone.
Date Modified, using the formula, "text(_md)", acts just the way Date Created does: It constantly shows the creation date & time, not the modified date & time, never updating when I change data even in multiple fields, and the data likewise disappears when the cloud icon is touched.
Am I doing something wrong, or are these bugs?
-
Date Modified will be set to Date Created when a new record is created. If working with an old card, field remains blank, so only time it appears to be triggered is during the creation of a new record.
Also, I am using iCloud, not Ninox Cloud
-
Created on, Modified On and _cd, _md don't work with Mac app.
I use triggers for that:
Nick
-
I see now I was working in entirely the wrong place. This function has to be done in the Edit Fields... option in the Table menu.
I first created two new Date/Time fields titled Created on and Modified on.
Then, in the Table | Edit Fields dialog, under "Trigger on create," I entered the formula: 'Created on' := now()
In the Trigger after update, I entered: 'Modified on' := now()
Everything now works perfectly!
-
Thanks, Nick. Your solution posted while I was writing mine. Apparently, they've fixed "Created on" and "Modified on" as they appear to be working now. My biggest problem was that I was trying to enter the formula in the fields I had created to hold the dates, since I didn't know about the built-in trigger boxes in the table-specific stuff under "Table | Edit fields..." So much to learn!
-
I'm having a similar problem, on both iPad and iPhone. I set the Trigger on Create and Trigger After Update as indicated in this message thread. For the Modified Date, I used the formula;
format('Modified on', "MM/DD/YY")
The creation date is put into this field when a record is created. But there are two problems:
1. The data never changes after I modify the record.
2. When I close the database, then reopen it, the dates are gone.
What am I missing?
-
Sorry, I meant "The date never changes" in point #1.
-
Is there a way to add seconds to the formula.
-
https://forum.ninox.com/t/m1hr810?r=m1hrk46
is there a way to do this as a formula instead of a trigger so I can format the output? Thanks-
Lorenzo Milani Only put _cd or _md in a formula field. _cd for creation date and _md for modification date.
-
RoSoft_Steven Rooryck This gives me the date for the entire record not for a single field.
-
Lorenzo Milani Yes your're right, didn't know that was your question. I have a solution/trick for your case: If you want to monitor for example a field called "Input" , you create two Date/Time fields, one called Created and another Modified for example.
These can be hidden in the settings of the fields > Display field only, if: null
You can "call" these fields in a formula field, which are stylable and is your use case.
Now using the "Trigger after update:" of the field "Input" you can fill the two Date/time fields:
if not Created then Created := now(); Modified := now() else Modified := now() endYes, using triggers is still needed.... and this would be a Change Request for Ninox, having the possibility to add a variable in the _md and _cd functions like for example _cd(Input) where "Input" is the field you want to monitor.
-
RoSoft_Steven Thanks, It works! Nice work around. Sorry for the response delay.
-
