Skip to main content
Question

Autopopulate Date Completed with a formula text field

  • June 23, 2017
  • 0 replies
  • 33 views
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>
    This topic has been closed for replies.

    • JohnThomas
    • Registered
    • June 23, 2017
    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
    John, thank you! This works perfectly. So good to know how to do this. 
    • MCFNeil
    • Registered
    • June 26, 2017
    Another option without having to deal with variables is this:

    "&_fid_99="&URLEncode(Today())&" &
    Terms & ConditionsAccessibility statement