Forum Discussion

HeatherBryant2's avatar
HeatherBryant2
Qrew Assistant Captain
8 years ago

Autopopulate Date Completed with a formula text field

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 a...
Ask about Quickbase functionality
JohnThomas's avatar
JohnThomas
Qrew Cadet
8 years ago
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