Prefill

Prefill is a function where a predefined set of questions can be auto-filled based on a question. eg. Based on the employee ID, his name, email, department, and age can be auto-filled in the form.

In the Form Editor

1. In the form editor Click on Prefill Settings

Step 1 screenshot

2. Select the preferred Prefill Source

3. After Selecting Google Sheets, Select prefill-[boloforms]

Step 3 screenshot

4. Click on Edit Sheet

Step 4 screenshot

5. Create/Upload the details you want to be prefilled, make sure to a parameter by which you want other details to be prefilled

Step 5 screenshot

6. Click on Sync Data

Step 6 screenshot

7. Select the Trigger question, which will trigger the prefill. This is the parameter by which other details will be prefilled. This is taken from the form.

Make sure the parameter is also an input in the form and match it to the Answer Column ( Google Sheet Column)

8. Click on Refresh Columns to refresh changes in Google Sheets

Step 8 screenshot

9. Map the rest of the questions with columns in the Google Sheet

Step 9 screenshot

10. Remember to Save

Step 10 screenshot

---