Automatisches Ausfüllen anderer Felder

Hallo, ich möchte ein Formular erstellen, dass es ermöglicht bei einem vorgebenen Code z. B. 24 automatisch der Nachname, Vorname, IBAN und Steuernummer in den nächsten Feldern erscheint.

Weitere Felder sollen, dann vom Benutzer ausgefüllt werden

Der Benutzer gibt einen Code ein, dann werden die anderen Felder automatisch, wie oben beschrieben ausgefüllt.

Hi Cordula, 

Thanks for reaching out to Jotform Support. Unfortunately, our German 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 German, 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. Sure, you can achieve this if you have an Excel sheet with the codes and the associated fields. Then, you can use our Spreadsheet to Form widget. This will allow you to upload all data in an Excel file with a unique code. You may like to take a look at the following example if it will work with you:

• In Form Builder, click on the Add Form Element menu on the left side of the page.
• Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.
• In the Widget Settings window that opens up, upload your data file and customize the other options. 
• Select the Access Code Column to populate the remaining fields, ID on our example.
• Then, click on Update Widget.

This is the used Spreadsheet:

Check out the result below:

Give it a try and let us know how it goes.