Forum Discussion
I have users coming from the code page because of the flexibility of the pages in utilizing not just fields and inputs but can see logos and gifs etc. Because this database contains sensitive information, I am trying to keep everyone on the internet out of the records themselves, but I am open to the user viewing, inputting, and getting a code any way possible thats easy :)
------------------------------
Lija Harris
------------------------------
------------------------------
Christine Suarez
------------------------------
- LijaHarris2 years agoQrew TraineeHi!
Yes! The next record ID available would be perfect!!!!!! That would be so ideal. But honestly it can be any formula - text field that can be displayed if the record id is too difficult of a field to display. Just something unique that is static for the user to reference as a code in the future. I just emailed you with more detail but thank you so much!!!!
------------------------------
Lija Harris
------------------------------ - LijaHarris2 years agoQrew TraineeHere is my email for reference:
My code for the code page is below: BLUE is what is a placeholder.
<p style="text-align:center;"><img src= image hyperlink class="center"></p>
<h2 span style="color: white; font-family: Sans-serif; text-align: center; background-color: #358281;">Customer Data Intake Form</h2><form name=qdbform method=POST onsubmit='return validateForm(this)' encType='multipart/form-data' action=https://xxxxxxxxxxx.quickbase.com/db/xxxxxxxxxxx?act=API_AddRecord&apptoken=xxxxxxxxxxxxxxxxxx>
<input type=hidden name=fform value=1>
<style>
form {
float: center;
text-align: center;
justify-content: center;
}
table {
float: center;
text-align: center;
display: flex;
flex-wrap: wrap;
justify-content: center;
}
td {
float: left;
text-align: center;
margin: 5px auto;
padding: 5px;
}
tr {
font-family: Sans-serif
float: center
display: flex;
flex-wrap: wrap;
justify-content: center;
}
</style>
<table class="center">
<table>
<tr><td style="font-family: Sans-serif;" class=m>Contractor Business Name:</td>
<td class=m><input type=text size=40 name=_fid_6 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>End User Customer First Name:</td>
<td class=m><input type=text size=40 name=_fid_7 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>End User Customer Last Name:</td>
<td class=m><input type=text size=40 name=_fid_8 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>End User Customer Email:</td>
<td class=m><input type=text size=40 name=_fid_9 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>End User Customer Phone Number:</td>
<td class=m><input type=text size=40 name=_fid_10 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>Installation Address:</td>
<td class=m><input type=text size=60 name=_fid_12 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>City:</td>
<td class=m><input type=text size=60 name=_fid_14 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>State/Region:</td>
<td class=m><select name=_fid_15 ><option style="font-family: Sans-serif;">California</option>
</select></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>Zip Code:</td>
<td class=m><input type=text size=60 name=_fid_16 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>Existing Equipment Type (for AC/HP only):</td>
<td style="font-family: Sans-serif;" class=m><select name=_fid_18 ><option style="font-family: Sans-serif;">Air Conditioner</option>
<option style="font-family: Sans-serif;">Heat Pump</option>
</select></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>Existing Equipment Size (Btu/hr) (for AC/HP only):</td>
<td style="font-family: Sans-serif;" class=m><input type=text size=40 name=_fid_19 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>Coupon Code:</td>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
</table><input type=hidden name=rdr value='https://xxxxxxxxxxxxxx.quickbase.com/db/xxxxxxxxxxx?a=dbpage&pageID=2'>
<input type=submit value=Submit>
</form>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<br />Powered by QuickBase <a href=http://www.quickbase.com/>Online Database</a>
<script lang="javascript">
function CheckForOther (item, origlen)
{
var sitem = item.options[item.selectedIndex];
if (item.selectedIndex == (item.length - 1))
{
var val = prompt ("ADD A NEW CHOICE:", "");
if (val == null)
item.selectedIndex = 0;
else
{
var slen = item.length;
if (slen == origlen+1){
item.options[slen] = new Option (sitem.text, sitem.value);
}
item.options[item.length-2].text = val;
item.options[item.length-2].value = val;
item.selectedIndex = item.length-2;
}
}
}
</script>
<script lang=javascript>
function validateForm(theForm)
{
}
</script>
------------------------------
Lija Harris
------------------------------- MarceloBenavide2 years agoQrew CadetHello. Did you try evaluate the httpeResponse?
------------------------------
Marcelo Benavides
------------------------------