Setting a cell to a fixed value

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
584 viewsScriptingPoke

I would like to record automatically the date a certain record is created in a cell in Quantrix – like you would do in a database.
To do this I need to be able write (in early times one would have said “poke”) a value into a cell. A script could do it but this would need to be triggered somehow. Is there an internal “poke” function or something similar? Then you could use something like “if(isempty(), poke(date),value).¬†Any suggestions are welcome!

Answered question

I am not sure this is possible outside of scripting…I tried this:
= if(isempty(A1), now(), “”)
But now() is a volatile function and recalculates each time the model is forced to recalculate or a cell value changes.

Answered question

Latest Questions