Comment Pré-remplir un formulaire à partir d'une base de données Notion ?

  • ortho.orleans
    Demandé le 8 décembre 2023 à 11:25

    Avez-vous une astuce pour pré-remplir un formulaire à partir d'une base de données Notion ?

  • Waqas Jotform Support
    Répondu le 8 décembre 2023 à 11:39

    Hi Majbruch,

    Thanks for reaching out to Jotform Support. Unfortunately, our French Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in French, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. Unfortunately, it is not possible to pull data from your database and prepopulate it to your form. Here are a couple of workarounds to consider:

    1. You can query the necessary data from your database and export it to an Excel or CSV file. After that, upload the file to a Spreadsheet To Form widget added to the form. This works like a database query tool, but instead, it uses the Excel file that you uploaded. We have a guide here on How to Use the Spreadsheet to Form Widget
    2. You can copy the form's source code and embed it on your own custom page. Add an API call there to pull data from your database and prepopulate the embedded form with it using JavaScript.
    3. Also, you can use the Jotform API to post the submissions. In the backend code, you can call your API to fetch submissions from your database.

    Give it a try and let us know if you need any help.