Column "Folder in Drive"
In the column "Folder in Drive," you can specify the folder where the file created in this row should be placed. This way, you can organize your files into folders in Drive based on the data.
The "Folder in Drive" column supports data in the following formats:
- Folder name. The folder must be in the root section of "Drive". If there are multiple folders with the same name, none will be selected. So when specifying the name, make sure that there is only one folder with that name. The folder name can consist of multiple words.
Different folders in Drive are specified in the "Folder in Drive" column. - Name and full path. The target folder can be in some other folder, so you can specify the full path to that folder. When specifying the path, make sure that there are no folders with duplicate names in the parent folders.
Different folder names located in subfolders are specified in the "Folder in Drive" column. - Folder ID. When specifying the ID, there should be no slashes at the beginning or end. The folder can be located in any folder. You can take the folder ID from the address bar when it is open.
Various folder IDs are specified in the "Folder in Drive" column.
In the "Create Files" dialog box, you can specify the creation folder for all files. If a folder is specified in the "Folder in Drive" cell, then the file in this row will be saved in the folder specified in that cell. However, if the folder specified in the cell is not found, is incorrectly specified, or two folders with the same name are found (if the path is specified, including intermediate folders), then the files in these rows will be saved in the folder specified in this dialog box, not the one specified in the cell.
Example of use
For example, there is a list of participants. When creating files, it is necessary to organize the ready files based on the city of the participant.
Filling in the "Folder in Drive" cell.
In the table, in the column where the city is indicated, select the variable "Folder in Drive". When creating files, corresponding folders will be created in Drive.
History of file creations based on the table. The folders from the "Folder in Drive" column were created first, and then files were added to them.