Forum Discussion

JeffElliott's avatar
JeffElliott
Qrew Member
5 years ago

Formula Rich Text - editing a record field to today's date

I am using the Formula Rich Text to edit a record.  It is easy to update a field in the record to text, but I need to update a date field to today's date.  I can't seem to make today() or date() work....
APIs and custom code
Buttons
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Can you post your current code?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JeffElliott's avatar
JeffElliott
Qrew Member
5 years ago
var text url =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=XXXXX" &
"&_fid_12=Completed" &
"&_fid_99=today()";

It's the last line....

------------------------------
Jeff Elliott
------------------------------
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Try this:

    "&_fid_99=" & URLEncode(Today())"

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    np

    "&_fid_99=" & Today();


    the first part is a text string, so it goes in quotes.   Today() is a Function so it needs to be concatenated onto the string with the & , but  functions don't go in quotes.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JeffElliott's avatar
      JeffElliott
      Qrew Member
      5 years ago
      Perfect!  thanks so much!

      ------------------------------
      Jeff Elliott
      ------------------------------