Discussions

 View Only
  • 1.  Adding an Excel Spreadsheet to a Homepage

    Posted 07-21-2022 11:57
    Hi,

    I have an app to record requests for access and some of them require a spreadsheet to be filled out and sent.

    Is there a way to add an excel spreadsheet to the home page? I want users to be able to click on the spreadsheet and fill it out.

    ------------------------------
    Fatima Khan
    ------------------------------


  • 2.  RE: Adding an Excel Spreadsheet to a Homepage

    Posted 07-21-2022 14:09
    Would it be out of the question to instead just create the fields inside of Quickbase itself on the form and have them fill those out? It could be done in a similar way and the fields/answers would still be associated with the record it just would not be attached as a file. This record link could be shared instead of the Excel file if it requires sharing.

    If you wanted you could then move this to excel weekly or monthly, whatever you wanted, by just exporting it. 

    Another option would be to simply have a link point them to office 365 Excel or whatever they use. Then they could click that and do their task, save it, and add it to the record.

    You may also be able to embed it as a web page in the home page but I think that is unlikely to run well in the end, you could try it though and see. It may not work at all I didn't test it.


  • 3.  RE: Adding an Excel Spreadsheet to a Homepage

    Posted 07-21-2022 14:17
    Thank you for you help.

    The spreadsheets are formatted a certain way for the different departments so they would have to use those specific ones. 

    I like the idea of a link to 365. I haven't done something like that before so I'll have to research to see how I can do it.

    ------------------------------
    Fatima Khan
    ------------------------------



  • 4.  RE: Adding an Excel Spreadsheet to a Homepage

    Posted 07-21-2022 14:15
    Just have a documents table and make a link on the home page to run a report which will show the one record for your excel template form.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Adding an Excel Spreadsheet to a Homepage

    Posted 07-22-2022 14:41
    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
    ------------------------------