What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Database like Excel

    Asked by Rahul on September 13, 2013 at 01:50 PM

    Hello JOT Team,

     

    You have done excellent JOB no words.. Hatts off. I wish if you also make one database like excelsheet with below requirements, would more appreciate worlwide.

     

    > Person can enter the data in the excelsheet 

    > After save as same as FORM the user can see the enteries but cant Do anything with data. 

    > If we want to give writes to Export in excel then he/she can but editting not allowed

    > One login page with below enteries

     - Customer ID

     - Project

     - Password

    > Then he/she can see the data with export option.

    excel login page hello
  • Profile Image
    JotForm Support

    Answered by Welvin on September 13, 2013 at 03:45 PM

    Hi Rahul,

    You can integrate your form to Google Spreadsheet. Here's the guide: Google Spreadsheet Integration.

    In Google Spreadsheet, you can do the following:

    - Set the sheet as Read Only. Follow this guide from Google: https://support.google.com/drive/answer/2494886?hl=en

    - Allow individual to export the sheet

    -------

    The ability to have a login details before someone can access the data and export it is also possible with Google Spreadsheet. Although, someone should have a Google Account in order to do it. 

     

    You can also share your form submissions page with a password function. Please check this guide: How to Share Form's Submissions Page.

    You can also create a report with a password function. Choose Either:

    -Create HTML Table Listing Report

    -Create Grid Listing Report

     

    Thanks

  • Profile Image

    Answered by netdzire on September 13, 2013 at 03:52 PM

    Thanks Welvin .....

    But I'm very much happy with the style and the way and the ideas implemented on Form Creation......

    Same i needed for Database entry..... I dont understand the integreated system....

     

    Is there any other resource to use database as a Front and Admin..... Update the excel data in admin and once update or upload then it can be accesible from Front/User

  • Profile Image

    Answered by netdzire on September 13, 2013 at 04:08 PM

     

    I need as below requirements

     

    > Person can enter the data in the excelsheet 

    > After save as same as FORM the user can see the enteries but cant Do anything with data. 

    > If we want to give writes to Export in excel then he/she can but editting not allowed

    > One login page with below enteries

     - Customer ID

     - Project

     - Password

    > Then he/she can see the data with export option.

  • Profile Image

    Answered by Cesar on September 13, 2013 at 05:57 PM

    Just to make sure, is the problem you are having, that the users are able to download the exported Excel file, but they are not able to edit this file on their computers, am I correct?

    If that is the case, what may he happening is that Excel has detected that this file's source is the Internet, so it disables editing on those files, In which case Excel prompts with a yellow bar at the top asking if you want to make the file editable.

    1

     

    Hope this helps, if not please elaborate further so that we may find the proper solution. Thank you.

  • Profile Image

    Answered by Cesar on September 13, 2013 at 05:58 PM

    Also, Google's Spreadsheet Integration would allow you to have more control on who may have access to view or edit your data.