Autopopulate Date Completed with a formula text field

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hello, I'm using this formula text field to change a text multiple choice field to Completed, as well as change % Complete to 100, and Date Completed to the current date. Everything is working great aside from the Date Completed field not being updated. Any ideas why? Thanks!

var text url =

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Task ID] &
    "&apptoken=u8pt65bmk9v8jdrvxhrsdbycgqb" &
    "&_fid_12=Completed" &
    "&_fid_99=Today()" &
    "&_fid_98=100";

"<a class=\"Vibrant Success\" href=\"javascript:" & "$.get('" & $url &
    "', function(){" & "location.reload();" & "});" &
    "void(0);\">Complete</a>"
Photo of Heather Bryant

Heather Bryant

  • 952 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of John Thomas

John Thomas

  • 1,062 Points 1k badge 2x thumb
var date todaysDate = Today();
var text url =

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &"&_fid_6=Completed" &
    "&_fid_7="&$todaysDate&" " &
    "&_fid_8=100";

"<a class=\"Vibrant Success\" href=\"javascript:" & "$.get('" & $url &
    "', function(){" & "location.reload();" & "});" &
    "void(0);\">Complete</a>"

Tested Working Fine!! i think this will solve your issue
Photo of Heather Bryant

Heather Bryant

  • 952 Points 500 badge 2x thumb
John, thank you! This works perfectly. So good to know how to do this. 
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Another option without having to deal with variables is this:

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