Populate Form Fields Using Unique Abbreviations

  • chgtraunstein
    Perguntado em 2 de maio de 2023 às 05:37

    I also strongly support this feature request:

    Wir sind eine Schule mit 100 Lehrkräften. Jede Lehrkraft hat ein unverwechselbares Kürzel aus zwei Buchstaben, zum Beispiel "Ra"

    Es wäre sehr komfortabel, wenn die Lehrkraft, die ein Formular ausfüllt, nur noch ihr Kürzel eingeben müssten und dann alle anderen Felder zu den persönlichen Daten, die bereits in einem anderen Formular erfasst wurden, automatisch ergänzt würden.


    Vielen Dank!

    Markus

  • Saeed Support Team Lead
    Respondido em 2 de maio de 2023 às 05:42

    Hi Markus,

     We have the Spreadsheet to Form widget for this purpose that allows you to upload an external spreadsheet to your form and use the values on the spreadsheet to prepopulate your form. You can download Form Submissions as Excel and upload the Excel file to the widget. Values can be automatically populated when the abbreviation entered matches the unique value of the spreadsheet. This widget supports full name, email, phone number, scale, single and multiple choice, short and long text entries, drop-down, and rating values. We also have a guide to help you learn How to Use the Spreadsheet to Form Widget

    Here's a Demo. You can check out the form using this link.

    1682070609 64425c51a743b  Screenshot 0 Screenshot 10

    But, if you were referring to something else, can you explain it a bit more so we can help you with it?

    Keep us updated and let us know if you need any more help.