How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?
Ninox Profile

No clue as to what is required here

Ninox Profile

maybe with this? :

Get the creation date of the current record: _cd
Get the date of last modification: _md

Ninox Profile

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.)

Ninox Profile

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

Ninox Profile

Same for _md

Ninox Profile

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

 

Ninox Profile

Thank you so much!

Ninox Profile

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?

Ninox Profile

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

Ninox Profile

Created on, Modified On and _cd, _md don't work with Mac app.

I use triggers for that:

 

Screen Shot 2018-11-06 at 21.46.21

 

Nick

1 2
Reply