Forum Discussion

JasonJohnson's avatar
JasonJohnson
Qrew Assistant Captain
8 years ago

How can I use javascript to get current date/time to use as a variable in a formula

I have tried to find a way to put a javascript in as a variable to get the current date and time. It would have been great to use the native 'Now()' function but it only uses the time that the page la...
App builders
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
The formula language does not have access to JavaScript. Formulas evaluate server-side to Now() evaluates to the time a page is  initially loaded as you have noted. Script evaluates client-side so it has access to every event the user initiates as well as the time of those events.

You did not mention what you wanted to achieve overall but I would guess the four use cases in this new demo might come very close to what you want:

New Demo: Time On Form
https://community.quickbase.com/quickbase/topics/new-demo-time-on-form

If you need assistance in implementing one of the use cases in this demo (or some other use case) feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt/
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    >And honestly I am such a low coder that this will probably not work.

    BTW, don't be so self-deprecating - you can do the code stuff.
    Low Code platforms  like QuickBase are a great way to learn code.
  • JasonJohnson's avatar
    JasonJohnson
    Qrew Assistant Captain
    8 years ago
    The use case -
    We run IT projects (some overnight) in 8 different time zones and our staff or the technicians will have to check-in and out for each site. I have a check in/out button that populates the times but all in eastern time (our main office time and the app is set to eastern). I have the ability to translate time to any time zone and take into account daylight savings time. The organization is wanting to move toward capturing all those times in local time on the project site which I can make happen but only in a separate field but not immediately with the button.
     It is just that pesky now() function standing in my way at this point. I like the concept of the demos and could find a few use cases. In this case I need the real time/date the button is clicked on.

    Thanks for the words of encouragement, I am not that self-deprecating it is frustrating being on the verge of understanding and knowing you are there but not sure if how long it will take to get there.