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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
This question has been asked many times in this forum and has never really had a satisfactory answer.

But here is a low tech solution..

Instead of directly updating the date/time, use an Action or an Automation to set the current time. So the edit of a record will request that the date time be updated, rather than directly updating it.
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    7 years ago
    How about adding a get line of code to get the time from any given date time field in any table which I can set a formula field to be now().

    Can you help me with this line of code to get the date time from that field?

    Thanks
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    7 years ago
    Thanks for your reply.