Forum Discussion

JaimeFonseca's avatar
JaimeFonseca
Qrew Trainee
5 years ago

Text registration button in html form

Hello colleagues, I am new to quick base and I am trying to create a button that contains a url with a form of x fields, I want that when you click on the button of the page, it registers the fields in the form that I have, but I only you are registering a single field.

This is my code, what do I do?


var text urlToExecute = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=XXXXtokenXXX"
& "&rid=" & [Record ID#]
& "&_fid_30=" // It works
& "&_fid_111=" // Does not work
& "&fids=30.111" // Does not work
;
URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=11" 
& "&url=" & URLEncode($urlToExecute)

------------------------------
Jaime Fonseca
------------------------------
  • Are you intending to call an advanced dbpage here (which seems unlikely as you say you are new to Quickbase) or just trying to be on a native Quickbase form on a record and click to update some fields and refresh the record.?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JaimeFonseca's avatar
      JaimeFonseca
      Qrew Trainee
      The second appreciation!!

      ------------------------------
      Jaime Fonseca
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Try this syntax.  It is intended to update the record and refers the user back to that same record.  if there are any syntax error please post you code back here as an update.

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=XXXXtokenXXX"
        & "&rid=" & [Record ID#]
        & "&_fid_30=" // this will blank out field ID 30.
        & "&_fid_111="  & URLEncode (Application Approved")// put words into field ID 111
        & "&_fid_123=1"; // Set a checkbox to true

        var text URLTWO = 
        URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];

        $URLONE
        & "&rdr=" & URLEncode($URLTWO)



        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------