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
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/
------------------------------