How can I have a form that auto-fills multiple fields based on the information entered in one field

Hello @Oana A.

The functionality of the form currently does not support a true lookup where you need information-returned that is outside of data available within the form. If you are wanting the form to make an instantaneous decision of data entered within the form and display certain fields based on that decision, the form may be able to do that (form logic).

As a workaround for needing a lookup, I have used an additional sheet where the user starts their data input in a sheet (mine has only a single row of data that gets overwritten each time). This Landing Page sheet performs the required lookup, then using an Active URL, the answer(s) are forwarded into the form. If desired, those answers can be visible in the form - which makes them editable. In my case, I made the sheet available to anyone by publishing this sheet and providing the published-page-link to my organization. This is the same as providing a link to a form. Once the user starts the process the data entry is very seamless. This process works quite well for me.

If this workaround sounds like it has application to your process, let me know of any additional details you need.

Kelly