Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

What's the easiest way to create a generic HTML data entry form for a QuickBase application that I can embed on my website?

Using IE7 or IE8, the easiest way to create the HTML for a QuickBase data entry form is to use the following wizard:

https://www.quickbase.com/db/6mztyxu8?act=DBPage&pagename=formWizard.html

Note: This wizard does not currently work with IE9.

Note: This wizard works with application tokens (read more at https://www.quickbase.com/help/app_tokens_wizards.html). If you want to use Application Tokens with this wizard add the following token to your application: cwfcy7gdzqrsyncqbi2bn4u4kr (read how at https://www.quickbase.com/help/app_tokens_wizards.html). If not, you can leave the application's token requirement set to disabled.

Comments

Form Wizard?

When I click save,  where does the information populate?  I want to send customers a certain form built with this wizard, and when they click save, I want it to populate a certain record in quickbase.

Is that what this is for?

 

Thank you.

A

Data is saved to the app you specified...

The information is saved into the application and table you specified in the first step of the wizard. Clicking Save on the data entry form creates a new item in that table; it cannot be used to modify existing records. From that point on, you can access the data you entered within QuickBase.

Hope this helps,

--Sybil

XML file does not appear to have any style info

after following the wizard, I get this error, in IE8 and Firefox.

anyone know how to fix that?

------------------------------------------------

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<qdbapi>

 <action>API_AddRecord</action>

 <errcode>0</errcode>

 <errtext>No error</errtext>

 <rid>10</rid>

 <update_id>1331568758465</update_id>

</qdbapi>

standard browser response

Hi Rey --

That's not a QuickBase error -- if you look at the response content from <qdbapi> down, the XML you're seeing indicates that record ID# 10 was added with no error. The "error" you're seeing is the standard browser response when there is no stylesheet present to display the XML data. Since the QuickBase APIs communicate via XML, this is expected.

Thanks for writing,

--Sybil

IE9

Can't get it to work in IE9. The Form Wizard just shows up blank. Do you not support IE9?

re: IE9

This wizard doesn't currently work in Internet Explorer 9. We've updated the article above to reflect that; we'll update again when we've resolved the issue. Thanks for pointing this out.

Regards,

--Sybil

Wonderful But!!

The wizard works awesome as long as you are not using Intuit's website builder program (homesite) will not generate a new record in quickbase.  Works great if you copy html to notepad a save as .html and input data that way..otherwise...click to save and nothing happens.

Wounderfull But

I have this same problem homestead is not giving me a solution can some one help?

The wizard works awesome as long as you are not using Intuit's website builder program. Homestead will not generate a new record in quickbase.  Works great if you copy html to notepad, save as .html and input data that way..otherwise...click to save and nothing happens.

Homestead and the wizard

Many website builder programs consider the HTML code to be under their control -- that is, when you make changes manually, they may be overwritten. Homestead may also not allow certain types of scripts to be run. Either of these would interfere with the wizard. I would suggest that you contact QuickBase Support directly to try to find a solution: http://quickbase.intuit.com/support

Regards,

--Sybil

Since the HTML produced by

Since the HTML produced by the wizard appears to be valid, I would suspect that the issue is due to something in your website. I suggest opening a case with the Intuit Homestead group.

Homestead issue

In working with a customer via a support case, the issue with Homestead appears to be the two functions this wizard generates at the end of the code. If you deleted the "function CheckForOther" and "function validateForm" sections, this code will work as expected.

html form wizard

Hello,

I used the wizard and two things would be nice, but not sure if it's possible:

1) Is there a way for the wizard to output the HTML form, based on a form that's already been setup in Quickbase, specifically form layout, ordering of fields, and outputting the section headings/text?

2) Is it possible to pass in hidden fields, so the form input can be related to a record in another table? 

Thanks!

Jan

Web forms

I was able to follow the directions all the way to creating the page in that application section. The new page is listed and the URL posted correctly, but it isn't clear to me how I now get to the web from. I can launch it from my reports section in Quickbase, but how do I get there when outside of QB? I also got lost in the rdr section and am concerned that when I am able to get to the page, I will be directed to the Quickbase site. Can anyone offer additional help?

Thanks a lot. that's very

Thanks a lot. that's very detailed explanation. I would also like to know how can I create this quickbase database application in IE8...

Thanks a lot. that's very

Hi Stephen, The instructions in this article work for IE8 as well as IE6 and IE7. You'll want to run in compatibility mode, however, as we don't fully support IE8 at this time. To enable compatibility mode, log into QuickBase, then look just to the right of your address bar and you should see a padlock icon, to the immediate right of that is the button to enable compatibility mode. Thanks, Karis QuickBase Support

Hello,I used the wiz

Hello, I used the wizard and two things would be nice, but not sure if it's possible:1) Is there a way for the wizard to output the HTML form, based on a form that's already been setup in QuickBase, specifically form layout, ordering of fields, and outputting the section headings/text? 2) Is it possible to pass in hidden fields, so the form input can be related to a record in another table? Thanks! Jan

re: suggested changes

Hi Jan --

Those are useful suggestions, but most of our wizards are presented as-is to accomplish a specific task in a specific way. Probably not the answer you were looking for -- but I can tell you that most if not all of our wizards have been built using the QuickBase HTTP API. Our partners can assist you in building custom solutions if there are a specific set of changes you are interested in.

Thanks for writing in,

--Sybil

I like quickbase too, can you

I like quickbase too, can you post a guide to use it on IE8? Thank you.

I like quickbase too, can you

Hi, The instructions in this article work for IE8 as well as IE6 and IE7. You'll want to run in compatibility mode, however, as we don't fully support IE8 at this time. To enable compatibility mode, log into QuickBase, then look just to the right of your address bar and you should see a padlock icon, to the immediate right of that is the button to enable compatibility mode. Thanks, Karis QuickBase Support

Redirect

The one piece of this HTML that you will almost certainly want to customize is the hidden field called "rdr". The value of this field determines the page that the user sees after filling out the form. It's set to "https://www.quickbase.com" initially like this.

Redirecting

I want to get the record id of the record that was just added and then redirect the user to that record in display mode. How do I do that? Any sample code would be greatly appreciated.

already happens

Hi --

When you add a record, the new record is shown in display mode when you click Save. Was there another use case you were thinking of?

Regards,

--Sybil

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2012 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit