Forum Discussion
AdamKeever1
3 years agoQrew Commander
Not sure I fully understand your use case here. More information may be needed to communicate exactly what you want.
I agree that having the fields in Quickbase is ideal. Once the data is entered you could eliminate the manual step of emailing the spreadsheet by having an email notification trigger when the data is entered and it could include the data that was entered. If the spreadsheet format is important for getting people to adopt Quickbase, the spreadsheet can be published as a webpage and the HTML code can be entered into a code page. Then you can enter Quickbase field syntax and turn your Excel HTML code page into a custom form. The form can then be embedded on the home page. It is a bit tedious and requires some low level coding ability, but it can be done.
Here is an example of an Excel sheet published as a webpage, the code added to a code page, fields mapped to Quickbase, and embedded on a home page:
Here is an example of the syntax for posting the data entered in the code page form to Quickbase as a new record:
<form id=5S name=qdbform method=POST onsubmit='return validateForm(this)' encType='multipart/form-data' action=https://[YOUR_REALM_NAME].quickbase.com/db/[YOUR_DBID]?act=API_AddRecord&apptoken=[YOUR_APP_TOKEN]>
Here is an example of the field mapping syntax for creating the slider button for scoring:
<td class=xl6618786 style='border-top:none;border-left:none'><output id="sort1">0</output><br><input type="range" class="sort_slider" id="sort" value="0" max="5" oninput="sort1.value = this.value" name=_fid_[YOUR_FID] list="ticks" /></td>
<datalist id="ticks">
<option>0</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
</datalist>
------------------------------
Adam Keever
------------------------------
I agree that having the fields in Quickbase is ideal. Once the data is entered you could eliminate the manual step of emailing the spreadsheet by having an email notification trigger when the data is entered and it could include the data that was entered. If the spreadsheet format is important for getting people to adopt Quickbase, the spreadsheet can be published as a webpage and the HTML code can be entered into a code page. Then you can enter Quickbase field syntax and turn your Excel HTML code page into a custom form. The form can then be embedded on the home page. It is a bit tedious and requires some low level coding ability, but it can be done.
Here is an example of an Excel sheet published as a webpage, the code added to a code page, fields mapped to Quickbase, and embedded on a home page:
Here is an example of the syntax for posting the data entered in the code page form to Quickbase as a new record:
<form id=5S name=qdbform method=POST onsubmit='return validateForm(this)' encType='multipart/form-data' action=https://[YOUR_REALM_NAME].quickbase.com/db/[YOUR_DBID]?act=API_AddRecord&apptoken=[YOUR_APP_TOKEN]>
Here is an example of the field mapping syntax for creating the slider button for scoring:
<td class=xl6618786 style='border-top:none;border-left:none'><output id="sort1">0</output><br><input type="range" class="sort_slider" id="sort" value="0" max="5" oninput="sort1.value = this.value" name=_fid_[YOUR_FID] list="ticks" /></td>
<datalist id="ticks">
<option>0</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
</datalist>
------------------------------
Adam Keever
------------------------------