davit79Answered on August 07, 2019 06:09 PMCan i use Jotform where i have form created which other users use. I need to create vehicle inspection checklist form, where i have several users (mechanics) and they log in, and submit "inspection Checklist Form". After form is submitted users must be able to retreive it later, modify, change, delete, etc
Michael JotForm SupportAnswered on August 07, 2019 06:53 PM
If you would like other users to have the option to retrieve, modify, change the submissions made to your form, you can create submission reports and enable the "Show Edit URLs" option of the report that you will be creating.
The option is only available to some of the reports that you can generate.
When the users of your form access the report, they will be able to view the submission data. In the report, there will be an edit link that when they click they will be able to update a submission.
You can also set password protection to the report. Other users will need to enter a correct password first before they can access the report.
However, if you would like other users of your form to have the ability to delete the submissions, I'm afraid that the feature is only available on the account that owns the form and can only be done on the submissions page of the form.
davit79Answered on August 08, 2019 11:57 AM
also, Is it possible to retrieve data from existing database? For example, auto-fill data of customer information, such as name, address, etc... Search customer using phone number, name, etc and insert data to form
roneetAnswered on August 08, 2019 12:33 PM
It is not possible to retrieve the data from a database but you can retrieve the data from an excel sheet. The best widget that we can suggest you is Spreadsheet to Form widget:
This widget would be used to populate the details in the Form fields using a unique Id.
By using a unique code that is present in every row of your spreadsheet, you can access that specific row that matches the unique code.
The values are automatically populated on your form fields, as long as the spreadsheet column headings match your form field labels.
Hope this helps!