Discussions

Expand all | Collapse all

Autopopulate Date Completed with a formula text field

  • 1.  Autopopulate Date Completed with a formula text field

    Posted 06-23-2017 14:06
    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>


  • 2.  RE: Autopopulate Date Completed with a formula text field

    Posted 06-23-2017 15:02
    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


  • 3.  RE: Autopopulate Date Completed with a formula text field

    Posted 06-23-2017 16:39
    John, thank you! This works perfectly. So good to know how to do this. 


  • 4.  RE: Autopopulate Date Completed with a formula text field

    Posted 06-26-2017 03:46
    Another option without having to deal with variables is this:

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