Skip to main content
Question

Capturing the time a form is entered

  • April 5, 2017
  • 0 replies
  • 22 views
I need to capture a create time related to the time when the form is opened - not when it is saved. I can create a formulate that if the recordid is null it will get the time of day from now() but the else resets to null if I leave it blank and cannot reference itself. Is there a way to capture this and not have a formula run again?
      This topic has been closed for replies.

      • MCFNeil
      • Quickbase Alumni
      • April 5, 2017
      Where is the button being pushed from?  

      Because you could possibly modify that URL to write the "Now()" to a normal Date / Time field.  So it should load when the button is first pushed...

      There are some limitations there too... I'll ponder this a bit.

      Curious what your use case is?
      • anomDiebolt
      • Quickbase Alumni
      • April 5, 2017
      Use IOL technique with this one line of script:

      _fid_7.value = new Date().toString();

      Use a form rule to hide the field from view if you want.

      If you are unfamiliar with IOL you can convince yourself this works by just opening your from in edit mode and paste the above line of script into the console and you will see the instant date/time appear in the field's entry box.



      ASK: Please Give Me Your Formulas
      https://community.quickbase.com/quickbase/topics/formula-parser-in-javascript#reply_18555784
      No problem. Make a field called [Record ID# mirror] with a formula of [Record ID#]

      Then a form rule that says
      When [Rcord ID# mirror] is blank
      Change [Date time when fiporm opened] to the current date time.
      Terms & ConditionsAccessibility statement