HTML Form Submission

Question

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.&nbsp;&nbsp;Anything off hand that you see is causing this problem?
&lt;form name="qdbform" method="POST" encType="multipart/form-data" action="https://quickbase.corp.com/db/bp2na9h30?a=API_AddRecord&amp;apptoken=123thiaofj456"&gt;                                                                                                                                                                                                                              
Field 1: &lt;input type="text" name="_fid_6" id="_fid_6"&gt;&lt;br&gt;
  Field 2: &lt;input type="text" name="_fid_7" id="_fid_7" &gt;&lt;br&gt;
  Field 3:&lt;input type="text" name="_fid_8" id="_fid_8"&gt;&lt;br&gt;&lt;br&gt;
​------------------------------cowannbell ------------------------------

carolmcconnell · Answer

We actually got it working.&nbsp; It was just the url that was wrong.&nbsp; We used to house our own version of quickbase on our servers.&nbsp; 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.
&lt;!doctype html&gt;
&lt;html&gt;
&lt;head&gt;
&lt;meta charset="utf-8"&gt;
&lt;title&gt;QuickbaseTest&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;form name="testform" method="POST" encType="multipart/form-data" action="https://test.quickbase.com/db/bp2na9k01?act=API_AddRecord&amp;apptoken=app token # "&gt;
Field 1: &lt;input type="text" size="40" name="_fid_6"&gt;&lt;br&gt;
Field 2: &lt;input type="text" size="40" name="_fid_7"&gt;&lt;br&gt;
Field 3: &lt;input type="text" size="40" name="_fid_8"&gt;&lt;br&gt;
&lt;input type=submit value=Submit&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;
​------------------------------cowannbell cowannbell------------------------------

austink · Answer

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

carolmcconnell · Answer

What is this part "&amp;_fnm_second_year=1776" of the url?------------------------------cowannbell cowannbell------------------------------

austink · Answer

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.

austink · Answer

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.

Forum Discussion

HTML Form Submission

Related Content

Submissions on Mobile form requests for users to sign in

Switch between forms

Prevent save a record - New forms

Form Rule Question

Landing Page after form submission - On Mobile