Discussions

Expand all | Collapse all

URL button to edit then refresh page

  • 1.  URL button to edit then refresh page

    Posted 16 days ago
    I put the following code into a Formula URL field.  The purpose is to change the status to completed by clicking the button.

    URLRoot() & "db/" & [_DBID_LOTO] & "?a=API_EditRecord&rid="&[Record ID#]&"&_fid_37=Completed"

    Works great, but it then goes to the response page below.  Which I don't want.  How do I modify the code above to simply change the status and refresh the page.



    ------------------------------
    Steven Nelson
    ------------------------------


  • 2.  RE: URL button to edit then refresh page

    Posted 16 days ago
    I figured it out

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &

        "&rid=" & [Record ID#] &

        "&_fid_37=Completed" &

        "&_fid_39="&Now() &

        "&_fid_44="&UserToName(User(),"FF")&

        "&rdr=" &

        URLEncode(URLRoot() & "db/" & AppID())



    ------------------------------
    Steven Nelson
    ------------------------------



  • 3.  RE: URL button to edit then refresh page

    Posted 16 days ago

    In fact this should refresh the page you were on ..

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &

        "&rid=" & [Record ID#] &

        "&_fid_37=Completed" &

        "&_fid_39="&Now() &

        "&_fid_44="&UserToName(User(),"FF")




    & "&rdr="&URLEncode( URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------