Skip to main content
Question

Overwrite [update] a timestamp field / control a timestamp from multiple checkboxes

  • February 9, 2018
  • 0 replies
  • 94 views
Hi all,

I have a timestamp field that's is controlled by a checkbox-field and filled by the dynamic-rules
"When checkbox is equal to checked than action change timestamp to current date/time"
quite standard setup so-far.

I have now a second checkbox that should preferably update (or overwrite) the same timestamp field.
As you can control a field only once via a dynamic-rule I've added a second condition on the same rule.
"Multiple conditions when any checkbox A is equal to checked or checkbox B is equal to checked than action change timestamp to current date/time"

But this doesnt't seem to work this way.
It seems that the rule ignores the second change in box B.
If it helps the flow from box A to B is always in the same logical order of the delivery process.


(my alternative would be to create timestamps for every checkbox and than formula field getting the MAX date/time value as the realtimestamp for the last checked box. But as there are quite some checkboxes inline I would prefer another approach)

THXS JWS
      This topic has been closed for replies.

      • JanWillemSpeck
      • Author
      • Quickbase Alumni
      • February 9, 2018
      mmmm. I've found this thread and unless somebody has a brighter idea I fear it's going to be a workaround

      https://community.quickbase.com/quickbase/topics/timestamp-field
      • anomDiebolt
      • Quickbase Alumni
      • February 9, 2018
      Is this the behavior your want?

      Checkbox Timestamp
      https://haversineconsulting.quickbase.com/db/bnf75qdhj?a=q&qid=1

      Feel free to edit or add records.

      Don't worry about the numbers appearing in the timestamp - they are just millisecond values - easy to change for humans to read. Just lazy.

      Pastie Database
      https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=624
      • JanWillemSpeck
      • Author
      • Quickbase Alumni
      • February 9, 2018
      Yes it looks like it's possible.
      This is probably replicatable over multiple CB's.  What is the magic behind it?
      • JanWillemSpeck
      • Author
      • Quickbase Alumni
      • February 10, 2018
      Dan, I understand the concept of this though this is a bit out of my comfortzone yet. But i'm willing to read, experiment and learn.

      I followed the instructions here https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 ; or I better say I tried as the outcome is different as expected.

      step1 = OK
      step2 = OK (I assumed this should be a 'code page')
      step3 = ?? (I created a field in my table named it 'test' for the time being. The type of the field is 'formula-text'. I don't undertsand the instruction: '..with some HTML allowed using this formula..' properly. I can;t find that option on a field in the table. I recognize that 'HTML allowed' from a text field in a form but I doubt what is correct here.
      I copied the '[iol] & "moduleJumpTheShark.js" & [/iol]' code in the formula section of the field
      step4 = the check instructin I don't undertsan (see step 3);  all the unchecks are clear and removed form the advanced section of the field-properties
      step5 = the field 'test'is placed on my form and I see this code on the form:
      test      <img qbu='module' src='/i/clear2x2.gif' onload="javascript:if(typeof QBU=='undefined'){QBU={};$.getScript(gReqAppDBID+'?a=dbpage&pagename=module.js&rand='+new Date().getTime())};">
      I do not see the alert alert("module.js is now loaded - I now own your page");



      Hope this make some sense and you able to see my mistake.

      Thanks JWS
      JWS

      How about trying this single Rule

      When the record is saved
      And any of the following

      Checkbox 1 has changed
      Checkbox 2 has changed

      ...

      Checkbox 10 has changed

      Action:
      Change the value of [Last checkbox change date] to the current date /time

      The only flaw in this is that it presumed your checkboxes advance to completion, as unchecking a box will also trigger the form rule.

      But in typing this, I didn�t text bu5 it may also allow the rule

      When checkbox 1 has changed to checked. (As opposed to simply changed)
      Terms & ConditionsAccessibility statement