Forum Discussion

EOMDevelepors's avatar
EOMDevelepors
Qrew Captain
7 years ago

Refresh time before editing record with current time using the now() method.

Can anyone help me with refreshing the time before editing a record via url formula with current time being posted to end date/time field. Here is my current code: If(IsNull([End Date/Time] ...
APIs and custom code
Formulas and functions
JasonJohnson's avatar
JasonJohnson
Qrew Assistant Captain
7 years ago
You can do 2 of the following as well.

1. Put the word "today" in the date time field as below:
& "&_fid_645="& URLEncode("today")

2. Or you can use separate tables and take advantage of the Date Created field Kurt Trachy has an app showing how to do this. The app is ABC Tracking In/Out Time

Either way is much better than the dysfunctional Now(). Depending on the use case we alternate between the 2 methods .
JasonJohnson's avatar
JasonJohnson
Qrew Assistant Captain
7 years ago
Today does put the time in as well when used like I showed.