How to fetch data from mongoDb to display in Jotform?

  • sanacu003
    Asked on January 3, 2022 at 2: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

  • Patrick_R
    Replied on January 3, 2022 at 2: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!

  • sanacu003
    Replied on January 3, 2022 at 4:22 AM

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

  • Ashwin JotForm Support
    Replied on January 3, 2022 at 4: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.

  • sanacu003
    Replied on January 3, 2022 at 5:22 AM

    ok Thank you