# Prefill {% embed url="" %} **In the Form Editor** #### 1. In the form editor Click on Prefill Settings ![Step 1 screenshot](https://images.tango.us/workflows/37776416-0cab-4b4a-9b52-1fd6ee9eb486/steps/145668c8-ca36-4cde-afd0-49381eda0f3f/d087ecdc-7d6a-41cd-abbd-aa0116d96088.png?crop=focalpoint\&fit=crop\&fp-x=0.8920\&fp-y=0.0314\&fp-z=2.7949\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=763\&mark-y=7\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz0xNTAmaD0xNTAmZml0PWNyb3AmY29ybmVyLXJhZGl1cz0xMA%3D%3D) #### 2. Select the preferred Prefill Source #### 3. After Selecting Google Sheets, Select prefill-\[boloforms] ![Step 3 screenshot](https://images.tango.us/workflows/37776416-0cab-4b4a-9b52-1fd6ee9eb486/steps/03150c0b-783b-4484-b63f-11fe5c9bbb2d/972ff2f0-f627-4f62-9dd5-37b2dc6df0d3.png?crop=focalpoint\&fit=crop\&fp-x=0.7305\&fp-y=0.1840\&fp-z=2.6495\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=257\&mark-y=411\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz02ODcmaD04NCZmaXQ9Y3JvcCZjb3JuZXItcmFkaXVzPTEw) #### 4. Click on Edit Sheet ![Step 4 screenshot](https://images.tango.us/workflows/37776416-0cab-4b4a-9b52-1fd6ee9eb486/steps/c3779e6d-59fa-45ec-9362-4c4f83b68c07/6d17aa46-e21c-46a6-9766-9f9ea1af8dcf.png?crop=focalpoint\&fit=crop\&fp-x=0.6454\&fp-y=0.2224\&fp-z=2.6813\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=483\&mark-y=427\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz0yMzUmaD03NSZmaXQ9Y3JvcCZjb3JuZXItcmFkaXVzPTEw) #### 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](https://images.tango.us/workflows/37776416-0cab-4b4a-9b52-1fd6ee9eb486/steps/4d86b522-c15c-430c-b147-df2776c2dfbe/9c5a33cb-909f-423a-95e4-0c0772e5e25f.png?crop=focalpoint\&fit=crop\&fp-x=0.5000\&fp-y=0.5000\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n) #### 6. Click on Sync Data ![Step 6 screenshot](https://images.tango.us/workflows/37776416-0cab-4b4a-9b52-1fd6ee9eb486/steps/09c09faa-e977-4c49-b49a-43701120e0ee/b5dbaaa1-bf1c-44f2-b328-93b2fe679fa5.png?crop=focalpoint\&fit=crop\&fp-x=0.8998\&fp-y=0.1840\&fp-z=2.8247\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=666\&mark-y=394\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz0zODkmaD0xNDImZml0PWNyb3AmY29ybmVyLXJhZGl1cz0xMA%3D%3D) #### 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) ![Step 7 screenshot](https://images.tango.us/workflows/37776416-0cab-4b4a-9b52-1fd6ee9eb486/steps/9fd9a878-e78b-4364-8163-cbc9cb8867f8/c63b1d3e-99de-440e-ba17-005d1909e4bf.png?crop=focalpoint\&fit=crop\&fp-x=0.7840\&fp-y=0.4428\&fp-z=2.6427\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=85\&mark-y=423\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz0xMDMwJmg9ODMmZml0PWNyb3AmY29ybmVyLXJhZGl1cz0xMA%3D%3D) #### 8. Click on Refresh Columns to refresh changes in Google Sheets ![Step 8 screenshot](https://images.tango.us/workflows/37776416-0cab-4b4a-9b52-1fd6ee9eb486/steps/5dbc2cc9-92a8-4c93-8157-8334445dfda5/b891e399-5441-48ac-b283-df9b0baf6491.png?crop=focalpoint\&fit=crop\&fp-x=0.9027\&fp-y=0.4001\&fp-z=2.9503\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=652\&mark-y=411\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz00MDYmaD0xMDcmZml0PWNyb3AmY29ybmVyLXJhZGl1cz0xMA%3D%3D) #### 9. Map the rest of the questions with columns in the Google Sheet ![Step 9 screenshot](https://images.tango.us/workflows/37776416-0cab-4b4a-9b52-1fd6ee9eb486/steps/9af1fdc3-14a8-4dd2-a663-0e4687917d3d/324a4bf6-4116-4b99-bfdc-184b5f94b1fd.png?crop=focalpoint\&fit=crop\&fp-x=0.5000\&fp-y=0.5000\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n) #### 10. Remember to Save ![Step 10 screenshot](https://images.tango.us/workflows/37776416-0cab-4b4a-9b52-1fd6ee9eb486/steps/04d70ad1-f7fe-48d8-934f-55959c293e90/92748aa7-52a2-499a-a0e1-0c9bdbb12b64.png?crop=focalpoint\&fit=crop\&fp-x=0.4883\&fp-y=0.0308\&fp-z=2.4807\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=447\&mark-y=6\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz0zMDcmaD0xMzAmZml0PWNyb3AmY29ybmVyLXJhZGl1cz0xMA%3D%3D) *** --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://approval-docs.boloforms.com/guides/boloforms-dashboard/prefill.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.