Can I create a dynamic form that will bring name and prior donations from a spreadsheet

  • Profile Image
    jfgpapps
    Asked on February 01, 2021 at 01:48 PM

    I want to create a form that will brings in the donors name (from an excel spreadsheet is fine) along with previous giving history. Like their 2019 pledge amount. I also want to be able to suggest current giving amounts based on a 10% increase, 20% etc. That can be in the spread sheet also.

    Is it called a dynamic for or some other name? Is this possible

  • Profile Image
    Jovanne_A
    Answered on February 01, 2021 at 06:32 PM

    Hi, thank you for contacting Jotform support.

    You can use the Spreadsheet to Form widget that allows you to upload a spreadsheet to your form and use the values you have on the spreadsheet to pre-populate the form. Kindly refer to this guide for more information:

    Guide: https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget

    I hope this helps. Let us know if you have further questions.