![]() ![]() The data validation part is another essential part of data entry forms. You can use the clear() function to clear the required fields after submitting the data to the “Data” sheet. The above code does not clear the input fields after submitting the data. In the text box type your function name, submitData and click OK. To do that, click on the image and then click the menu icon in the top right corner of the image. Now you can assign the function submitData() to the save button (actually the image). We are going to copy the data in the Form to this “Data” sheet. Rename your sheet with the form as “ Form” and another sheet as “ Data“. Then copy the following script to the script editor and save it. To access Script Editor, go to Extensions > Apps Script. This task can be achieved through Google Apps Scripts. Once you click the save button, the data in the input field should copy to another sheet. Apps script to copy data from the form to another sheet Then add your text and add colors using color tools. To create this image go to, Insert > Drawing and then draw a rounded rectangle using the Rounded Rectangle shape tool. (Later I will assign Apps Script function to this image to copy the data into another sheet once you clicked it). Here I am using an image as the save button. ![]() You can protect the entire sheet except the input fields to prevent users from editing the other cells. The following form includes six input fields namely “Region”, “Country”, “Population” “GDP”, “Area”, and “Literacy” in D4, D6, D10, D12, G10, and G12 cells respectively. You can simply create the form interface by taking the cells as input fields. ![]() Wrapping Up Creating the form interface.Apps script to copy data from the form to another sheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |