Discussions

Expand all | Collapse all

HTML Form Submission

  • 1.  HTML Form Submission

    Posted 10 days ago
    Trying to develop a form on our website that when populated and submitted will add a new record to QB.

    Can get to the form and create a record but no data is saved to the fields.

    Here is an example of what we are using.  

    Anything off hand that you see is causing this problem?

    <form name="qdbform" method="POST" encType="multipart/form-data" action="https://quickbase.corp.com/db/bp2na9h30?a=API_AddRecord&apptoken=123thiaofj456">                                                                                                                                                                                                                              
    Field 1: <input type="text" name="_fid_6" id="_fid_6"><br>
      Field 2: <input type="text" name="_fid_7" id="_fid_7" ><br>
      Field 3:<input type="text" name="_fid_8" id="_fid_8"><br><br>


    ------------------------------
    cowannbell
    ------------------------------


  • 2.  RE: HTML Form Submission

    Posted 7 days ago
    I'm not sure you can do it via HTML like that. For one thing the URL you are trying to use is not going to work. I assume you switched that out for posting to the forum though.

    https://help.quickbase.com/api-guide/add_record.html

    You can check Stack Overflow to see how you can intercept your form data and build the xml before submitting it. There might even be an easier way but I found this. https://stackoverflow.com/questions/2088862/how-to-post-xml-to-server-thru-html-form

    If you want it to post via a URL you are going to need to follow the URL example from the first link above. 
    https://target_domain.quickbase.com/db/target_dbid?a=API_AddRecord&_fnm_second_year=1776
    &_fid_8=changed&ticket=auth_ticket&apptoken=app_token



  • 3.  RE: HTML Form Submission

    Posted 7 days ago
    What is this part "&_fnm_second_year=1776" of the url?

    ------------------------------
    cowannbell cowannbell
    ------------------------------



  • 4.  RE: HTML Form Submission

    Posted 7 days ago
    That is just another way to identify a field. Fnm = field name similar to how fid = field id. They can usually be used interchangeably, I just copied the URL alternative QuickBase gave. 

    Also I think this help doc might be good to read. If you do the URL alternative I mentioned previously you will need to make it a GET request, one of the things it mentions. https://help.quickbase.com/api-guide/understandreference.html#sample_text

    Another option to do what you are wanting would be using some kind of intermediary like Workato or Zapier or something else that can send a webhook. That might be easier to do but that will depend no how comfortable you are with coding.


  • 5.  RE: HTML Form Submission

    Posted 7 days ago
    We actually got it working.  It was just the url that was wrong.  We used to house our own version of quickbase on our servers.  We just recently moved to the cloud so the url changed but we were still trying to use the old url.

    Thanks for your input.

    This is what we used.

    <!doctype html>
    <html>
    <head>
    <meta charset="utf-8">
    <title>QuickbaseTest</title>
    </head>
    <body>
    <form name="testform" method="POST" encType="multipart/form-data" action="https://test.quickbase.com/db/bp2na9k01?act=API_AddRecord&apptoken=app token # ">
    Field 1: <input type="text" size="40" name="_fid_6"><br>
    Field 2: <input type="text" size="40" name="_fid_7"><br>
    Field 3: <input type="text" size="40" name="_fid_8"><br>
    <input type=submit value=Submit>
    </form>
    </body>
    </html>


    ------------------------------
    cowannbell cowannbell
    ------------------------------



  • 6.  RE: HTML Form Submission

    Posted 7 days ago
    Ah yeah that was my first suggestion posted but I figured you had just changed the URL yourself to hide it when posting.

    That's interesting though, from what I was reading it should not have worked that way. Thanks for posting your solution.