Does Jotform has dynamic prefill of forms from a database?

  • Profile Image
    ZAK 
    Asked on December 05, 2020 at 05:41 PM

    Hello

    I am discovering your form builder and i have three main questions about the features:

    does Jotform builder has the 3 following features :

    1- Forms with Dynamic Prefill & Virtual Database

    • Pull existing data in order to prefill form fields. If you already have data about a client, why ask for it again?
    • Push new data back to your database and keep your records up-to-date.

    2- My employee ( user) can display on the mobile app, the client list on map using GPS coordinates. ( GPS coordinates are available in the database)


    3- My employee ( user) can select a client from the map and the mobile app gives him the option to navigate to the client using google maps or waze or others...and then at the client shop he continues on the app to fill the form.

    Waiting your kind reply

    Best regards

    ZAK

  • Profile Image
    Welvin
    Answered on December 06, 2020 at 12:35 AM

    Hello Zak,

    1. The closest available feature we have to pull data is by using the Spreadsheet to Form widget:

    https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Unfortunately, the widget does not support any external database. We also do not have a feature that can connect to an external database.

    Pushing data to the source file of the widget is also not possible.

    2. Do you mean you want to pull your list of clients from the database and display the list of your clients on a map? I'm afraid that isn't possible either. But if you have a predefined list of clients, you could merge this into the spreadsheet to form widget. Display the list into a text field maybe since the map is not possible.

    3. It is also not possible. It would be manual. We have a GPS Directions widget that you can use to fill up the From and To address: https://www.jotform.com/widgets/gps-directions.

    The form seems to be a custom form. I'm afraid we do not provide any custom form solution.

    I hope that helps.