Forum Discussion

Jan-WillemSpeck's avatar
Jan-WillemSpeck
Qrew Assistant Captain
8 years ago

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

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
  • Jan-WillemSpeck's avatar
    Jan-WillemSpeck
    Qrew Assistant Captain
    8 years ago
    Yes it looks like it's possible.
    This is probably replicatable over multiple CB's.  What is the magic behind it?
  • Jan-WillemSpeck's avatar
    Jan-WillemSpeck
    Qrew Assistant Captain
    8 years ago
    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
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      8 years ago
      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. :(
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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)