AutoCode

It is possible to add pre-filled text from an Excel-file to a survey.

For example, we have a question in the survey asking for a ZIP code. Then we the Excel file where the ZIP code will be verified, and then it provide us the CITY automatically.

You need to create an Excel file, with all the ZIP codes, and then a column for CITY.

There must be a sheet called Sheet1, in the header above all columns following normal "variable" conventions, e.g. just use a-z, 0-9, like "amount", "age" etc (no spaces).
All columns should be formatted as text fields, even though they contain numbers. You need some column to use as the lookup column, e.g. a company "number".

So for example:

ZIP CITY
1000 Amsterdam
2000 Oslo
3000 Malmö
4000 London

You upload the Excel file to file storage.

The filename we use in the autocode script is the URL you see at File location, in the example above this is: