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#]&

"&apptoken=xxxxxxxxxxxxxxxx"&

"&_fid_521=Today()"&

"&_fid_519=Yes";


"javascript:" &

"$.get('" & 

$url & 

"',function(){" &

"location.reload();"&

"});" &

"void(0);"

Photo of Akash

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

Akash

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