Forum Discussion

NeveLeem's avatar
NeveLeem
Qrew Trainee
9 years ago

Date stamp formula for checkbox

Hello. I have a quick question regarding date stamps. I have two check-boxes on my form: import and export. For both, I hope to create a formula date stamp field to see when users ticked these b...
APIs and custom code
Button
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
The last part with the JavaScript to run the update and refresh is not supposed to be a formula variable. Formula variables are intermediate placeholders to simply formula. 


var text TodaysDate = ToText(Today());

var text Update = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=dhxpiidu5cj4edz3d8kvbn2cium"
 & "&_fid_1469=" & $TodaysDate
 & "&_fid_1468=" & totext(User())
& "&_fid_805=1" ;



"javascript:" &
"$.get('" &
$Update &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Mariana_Alejand's avatar
Mariana_Alejand
Qrew Member
5 years ago
Hi,

I'm trying to do the same and I'm using the formula recommended since for some reason even being admin on my app I'm not able to configure the ACTION editing related records.

I'm not really experienced on URL formulas, and I'm not receiving any error on the formula, but the date stamp is not working as I was expecting.  I would appreciate additional information on how I can make it work.


Thanks in advance

Regards
Mariana Ayala

------------------------------
Mariana Alejandra Ayala
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Can you post your formula code?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • Mariana_Alejand's avatar
      Mariana_Alejand
      Qrew Member
      5 years ago
      Here is the formula

      var text TodaysDate = ToText(Today());

      var text Update = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
      & "&apptoken=dhxpiidu5cj4edz3d8kvbn2cium"
      & "&_fid_1469=" & $TodaysDate
      & "&_fid_1468=" & ToText(User())
      & "&_fid_805=1" ;



      "javascript:" &
      "$.get('" &
      $Update &
      "',function(){" &
      "location.reload(true);" &
      "});"
      & "void(0);"

      I'm not sure if the name or features of the field could be the issue. The formula seems to be right. Not error message.

      ------------------------------
      Mariana Alejandra Ayala
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        When you use that Javascript syntax it hides any error message. 

        Comment out the bottom javascript lines and just do this to help us debug.


        var text Update = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
        & "&apptoken=dhxpiidu5cj4edz3d8kvbn2cium"
        & "&_fid_1469=" & $TodaysDate
        & "&_fid_1468=" & ToText(User())
        & "&_fid_805=1" ;

        $Update


        Then post back with the response from the button.

        It will either be an error message or a success message. 


        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------