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.  If it put in a date in text (i.e. 1/10/2021) it will show up, but it will not "find" and enter today's date.



------------------------------
Jeff Elliott
------------------------------
APIs and custom code
Buttons
    • 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/
        ------------------------------