Set Date Field with a choice Field is Made
I have a choice field for project status (Open, Pending, Closed) and I have a date field "Closed Date".
I want the "Closed Date" Field to update with the current date when the project status field is changed to Closed(3).
I have tried
if 'Date Closed' = 0 and 'Project Status' = 3 then
'Date Closed' = 'Date Created'
end
Any ideas why this does not work? Is if 'Date Closed' = 0 correct for testing an empty date field?
6 replies
-
Update
The code I have tried should have read
if 'Date Closed' = 0 and 'Project Status' = 3 then
'Date Closed' = 'Today'
end -
Hi.
The syntax for 'Date Closed' should be "void" or "null".
Try this:
------------------------------------
if 'Date Closed' = null and 'Project Status' = 3 then
'Date Closed' := today()
end
------------------------------------
Fabio
-
Works Great. Thanks.
Do you know if there is a good code language reference for Ninox?
What language syntax is Ninox based on?
-
Hi.. the best source is the function and language reference in the manual.
Ninox has its own syntax which is a functional language: the core system is based on Javascript. -
Thanks, I have enjoyed this program so far. One of the best to be mobil on IPad and PC Desktop.
-
BTW, if you want to make your code a bit more readable, you can compare choice field values with text using 'like', as in:
------------------------------------
if 'Date Closed' = null and 'Project Status' like "Closed" then
'Date Closed' := today()
end
------------------------------------
Content aside
- 5 yrs agoLast active
- 6Replies
- 2104Views