Hi Meredith,
I needed somthing like this for customers to fill out a form and submit it to our Quick Base.
I used a "pages" Code Page to make a stand alone HTML page with a standard HTML Input form.
w3schools.com is a great resource for the details of the HTML page.
This may be a bit of a learning curve, and it is worth it!
The web page is submitted to Quick Base as an API call.
In summary, these are the key elements.
1) Start the HTML form:
Tutorial here:
https://www.w3schools.com/tags/att_input_type.asp<!-- Standard QuickBase form Header. Update the Token ID as needed. -->
<form name=qdbform method=POST onsubmit='return validateForm(this)'
encType='multipart/form-data' action=
https://intuitcorp.quickbase.com/db/your-db-id-here?act=API_AddRecord&apptoken=your-token-here>
<input type=hidden name=fform value=1>
2) Ask for the fields you want to input (I used a table for formatting, which may be old-fashioned these days -- but it works.):
<table cellpadding=0 cellspacing=0 border=1>
<tr> <!-- Set up the Yes / No response area -->
<td bgcolor="#F4F4EA" style="text-align:center;"> Yes </td>
<td bgcolor="#F4F4EA" style="text-align:center;"> No </td>
</tr>
<tr> <!-- The Answer Buttons. Set the desired Field ID. This is a Yes/No question. -->
<td bgcolor="#F4F4FA" style="text-align:center;"><input type='radio' name= _fid_9 id= _fid_9 value="Yes" /></td>
<td bgcolor="#F4F4FA" style="text-align:center;"><input type='radio' name= _fid_9 id= _fid_9 value="No" /></td>
</tr>
</table>
_fid_9 is the Quick Base Field ID I want this specific data to be placed in. You can get the Field ID numbers from the Fields list in Quick Base.
3) End the HTML form with the SUBMIT button:
<!-- * -->
<!-- Quietly pass the fact that this is the OM Save VOC. -->
<!-- * -->
<input type="hidden" name= _fid_13 id= _fid_13 value="OM Save VOC.">
<!-- * -->
<!-- You can Pass a piece of standard information to the Quick Base record with This Method -->
<!-- * -->
<input type="hidden" name= _fid_11 id= _fid_11 value="The Text You Want to Send in Quotes>
<!-- * -->
<!-- Pass the URL for the Thank You page (which is another Quick Base Code Page) -->
<!-- Used the HTML form's "rdr" for Redirect URL option -->
<!-- * -->
<input type=hidden name=rdr value='
https://intuitcorp.quickbase.com/db/your-dbid-ID-here?a=dbpage&pageID=the-page-ID-Number-of-your-Thank-You-Page-Here'>;
<!-- * -->
<!-- Center the Submit button on the page. -->
<!-- * -->
<table width = 100%>
<tr>
<td> </td>
<td>
<input type=submit value="Submit Survey">
</td>
<td> </td>
</tr>
</table>
</form>
The page was set as the dashboard for the customer role (in my case "everyone on the internet".)
It was the only thing they could do for security.
If your audience is internal and you can just give them a link and have them bookmark it.
Then anytime they want to come and submit a form they just go to the page directly.
I trust this is useful.
- David