Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function SHARAPOV(){
- const ss = SpreadsheetApp.getActive();
- const sh = ss.getActiveSheet();
- const r = sh.getRange("a1:c").getValues();
- r.forEach((y, i) => {
- const range = sh.getRange(++i, 3, 1, 2);
- i > 0 && !y[2] && y[0] && y[1] ? search(query(getIdFromUrl(y[0]), y[1].toString().split(' ')[0])).length ?
- range.setValues([[true, 'есть']]) :
- range.setValues([[true, 'нет']]) : ''})
- }
- function query(folder_id, name){
- return `'${folder_id}' in parents and title contains '${name}'`;
- }
- function getIdFromUrl(url){ return url.match(/[-\w]{25,}/)}
- function search(request, pageToken){
- var optionalArgs = {
- q: request,
- maxResults: 1000,
- orderBy: 'modifiedDate desc',
- fields:
- 'items(id, title, parents(id), alternateLink, permissions, hasAugmentedPermissions), nextPageToken'
- };
- //(type, id)
- if (pageToken) {
- optionalArgs.pageToken = pageToken;
- }
- var list = Drive.Files.list(optionalArgs);
- var files = list.items;
- if (list.nextPageToken) {
- return files.concat(search("", list.nextPageToken));
- }
- return files;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement