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

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb
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
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
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
(Edited)
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb
Yes it looks like it's possible.
This is probably replicatable over multiple CB's.  What is the magic behind it?
(Edited)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,322 Points 20k badge 2x thumb
the script in the pastie
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb
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
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,322 Points 20k badge 2x thumb
QuickBase likes to change things now and then to mix it up so to speak.
  • User Defined Page => Code Page
  • Text formula filed with some HTML allowed => Rich Text Formula field
  • QuickBase => Quick Base
  • Not Purple => Purple
From your description I think you will get it working if you use a Rich Text Formula field. You are seeing the raw HTML displayed so the script specified in the onload attribute never executes and you are left with an unenhanced page. :(
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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)