How to fetch data from mongoDb to display in Jotform?

  • Profile Image
    sanacu003
    Asked on January 03, 2022 at 02:18 AM

    Is there any way to fetch data from mongoDb and display in Jotform ?

    Becoz in my Db there are some values which should be saved which the form is submitted and its hidden to the user . So how to fetch data from Db and display in Jotform and make it hidden and save back the data to DB

  • Profile Image
    Patrick_R
    Answered on January 03, 2022 at 02:33 AM

    Hello there,

    Kindly note that we don't have any way to fetch data from MongoDB and display in the form. But, we do have similar functionality in which you can upload an Excel file and the data from it can be loaded to the form before submitting.

    The widget used for this purpose is Spreadsheet to Form widget. Here is the implementation guide: how-to-use-the-spreadsheet-to-form-widget

    Here is the demo form that you can test: https://www.jotform.com/213275499944975

    If you can export your MongoDB data to an Excel file; then you can use that Excel file with this widget to achieve this functionality.

    If you have questions or if this doesn't solve your purpose, let us know.

    Thank you!

  • Profile Image
    sanacu003
    Answered on January 03, 2022 at 04:22 AM

    So if the data get updated I again need to upload Excel file ?

  • Profile Image
    ashwin_d
    Answered on January 03, 2022 at 04:43 AM

    Yes, that is correct. The uploaded Excel file in the "Spreadsheet to Form" widget can't be updated automatically. You will have to upload the updated Excel file in the widget again.

    Hope this helps.

    Do get back to us if you have any questions.

  • Profile Image
    sanacu003
    Answered on January 03, 2022 at 05:22 AM

    ok Thank you