URL Button not assigning date in Date field on Form.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have a URL button on a report that changes the status of a Drop down field to Yes. I also want to capture the date this status was changed to Yes. Therefore I have another Date field to capture this. 

The button does not change the Date field to Today(). Here is the formula I am Using: 

var text url=

URLRoot()& "db/" &Dbid()& "?a=API_EditRecord" & 

"&rid=" & [Record ID#]&




"javascript:" &

"$.get('" & 

$url & 

"',function(){" &


"});" &


Photo of Akash


  • 20 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
Try this

"&_fid_521=" & ToText(Today()) &
Photo of Akash


  • 20 Points
Worked like a charm. You are the Man. Thanks for the quick response have a good weekend.