Knowledge Base

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

How do I create an HTML form that adds records to a QuickBase application that is not publicly accessible?

Just add two hidden fields called "username" and "password":

<input type="hidden" name="username" value="screen-name">
<input type="hidden" name="password" value="not-very-secret">

1. Set the value of these fields to a screen name and its password.

2. To maintain the security of your QuickBase application, create a user just for this form. Go to the QuickBase home page and click on the "Sign In" link. Sign in to QuickBase and then on your "My QuickBase" page click on "My User Profile". Then click on "I want to..." and select "Manage User Accounts". Then click on the "register" link. Pick a screen name and password that you feel comfortable putting in the hidden fields of your form. A word of caution here. QuickBase lets application administrators grant access to all QuickBase user accounts whose email matches a particular domain. So for instance to grant access to everyone whose email address ends in "@yourcompnay.com" you just grant access to "@yourcompany.com" as if it was a real email address. QuickBase understands this to mean everyone whose email address ends in "@yourcompany.com". This is a convenient way to grant everyone in a company access to an application. However in the case described above the newly created depositor user account will belong to the same email domain as your original account. This means that anyone who gets access to the username and password for this account will be able to access to all the applications that have been shared with the entire email domain. To prevent this from happening it's best to create a new QuickBase account with a Yahoo or Hotmail email address. No one in their right mind shares a QuickBase application with "@yahoo.com" or "@hotmail.com".

3. To change the permissions, go to the overview page of the not-publicly accessible QuickBase application. Create a new Role by clicking on the "Customize" drop down menu and select "Roles". On the "Customize Roles" screen click on "Create a New Role". Check only "Add Records", give it the name "depositor" and click "Save". Now share the application with the "depositor" user by following the steps in the help file you can access by clicking the link below:

https://www.quickbase.com/help/sharing_a_database.html

4. Now that you have two screen names, it's important to pick the screen name associated with your original account as the default screen name for your e-mail address.

5. Log into QuickBase and click on "Edit your user Profile". Then click "Manage User Accounts". Click on the radio button next to the screen name you want to use as the default for your e-mail address. Be sure not to use the screen name that you created for your form the default! Then click the "OK" button.

Comments

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-2013 Intuit Inc. All Rights Reserved.

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