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?
1. To maintain the security of your QuickBase application, you'll want to create a new role which allows your form to operate but locks down everything else. To do this, open the not-publicly accessible QuickBase application and click Users. Create a new Role by selecting Manage Roles then + New Role. Name the role 'Public Web Form' and click OK. On the Permissions tab, click the Add checkmark for the table your form will be adding data to. The change is saved automatically.
2. Create a user just for this form (read how to invite a new user to your app here: http://www.quickbase.com/user-assistance/#sharing_a_database.html). Pick a username 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. Now you can add two hidden fields called "username" and "password" to your web page:
<input type="hidden" name="username" value="user-name">
<input type="hidden" name="password" value="not-very-secret">
4. Set the value of these fields to the username and password for the web form user.
Browse by Category
Knowledge Base Categories
- Accounts (35)
- Application (46)
- E-Mail (7)
- Fields (42)
- Forms (20)
- Formulas (18)
- General (69)
- Other Product (7)
- Pages (1)
- Product (5)
- Reports (15)
- Roles (4)
- Search (1)
- Tables (6)