To specify the original file you may for example use the Find file building block. After having selected the original file you need to specify the target folder and name of the file copy.
When working with file templates - for example a monthly time sheet - you would like to create a copy for every employee and every month. Therefore use the Find File building block to find the correct template and create a copy to enter the current data. Also when working with Google Forms you may want to create user specific copy of a source form.
Automatically create template copies for timesheets
Working hours should be recorded for each user. The user data should be separated by month so each employee should have an individual timesheet for every month.
In this example the data is recorded in a form. The data is then added to a timesheet for which the name contains employee name and month. So before the data is added the Find file building block checks if a file for the inserted date and the given employee already exists.
In order not to rely on spelling mistakes the employee make could also be loaded from a worksheet (Load worksheet) or from a Google contacts group (Load contact group) in order to be available as a drop down selection.
In case the file cannot be found the template file used to create a new copy for the relevant timesheet the employee working hours need to be added to.
After either the existing timesheet was found or a new file was copied the working hours are added to the given file.
Questions and Feedback
If you have any comments on this page, feel free to add suggestions right to the Google document that
we are using to create this site.
If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.
Last Updated: 11/30/18