Freelance projects

Freelance projects

Google App script that lasts over 6 to 30 minutes

Javascript and Typescript — incorrectly specified categories?

11 USD

Client's review of cooperation with Andrew Kr

Google App script that lasts over 6 to 30 minutes

11 USD

Andrei carried out my project from A to I. He considered all my wishes, made the project perfectly. I strongly recommend this specialist. Contact, speed at work, awareness - I am pleasantly impressed by Andrea's work. I’ll talk again! I bet 10 out of 10.

5.0

Andrey Akopov

Reciprocal Feedback

14 November 2023

Freelancer's review of cooperation with Andrey Akopov

Google App script that lasts over 6 to 30 minutes

11 USD

Very easy communication during the performance of the work, clear task, quick check, immediate payment. I recommend cooperation!

5.0

Andrew Kr

Reciprocal Feedback

14 November 2023

Project translated automatically. Log in or register, to view the original The script listFilesAndFolders downloads into the Google table all the files and their information that is on the Google disk.There are a lot of files, the download time is more than 6 minutes (30 minutes).Also on the list is a formula (the next column after the data downloaded) that processes the results obtained.It is desirable that this formula remains after the list is downloaded.A similar task (downloading files from a table to a Google disk and re-name) that lasted more than 30 minutes was solved by a trigger that activated the function.I checked the file status through the end column and then processed it.(The word “Do” )Here is the link to the file. https://docs.google.com/spreadsheets/d/1QSWdUOPJ-rA1QbO65tSRsdhsE9GnNBzzm4QIXYg4kI0/edit#gid=86329294 Filed to Files Fragment of the script to be performed (download the file list) function listFilesAndFolders() { var folderid = '1rHWkdcVPSzxbLkHY3C-EGUSlgB9KMQYu'; // change FolderID var sh = SpreadsheetApp.getActive().getSheetByName("Files"); by sh.clear(); sh.appendRow([“parent”,“folder”,“folderID”,“name”,“size”,“URL”,“ID”,“description”,“type”]); try { is parentFolder =DriveApp.getFolderById(folderid); listFiles(parentFolder,parentFolder.getName()) listSubFolders(parentFolder,parentFolder.getName()); by catch (e) { Logger.log (e.toString() ) The The function listSubFolders(parentFolder,parent) { is childFolders = parentFolder.getFolders(); while (childFolders.hasNext()) { is childFolder = childFolders.next(); Logger.log("Fold : " + childFolder.getName()); listFiles(childFolder, parent) listSubFolders(childFolder,parent + "♰" + childFolder.getName()); The The function listFiles(fold, parent){ var sh = SpreadsheetApp.getActive().getSheetByName("Files"); The data is []; is fold.getFiles(); while (files.hasNext()) { is file = files.next(); The data = [ The parent, by fold.getName( ) by fold.getId( ) by file.getName( ) file.getSize( ) by file.getUrl( ) by file.getId( ) by file.getDescription( ) file.getMimeType() and the sh.appendRow (data ) The The

Proposals 3

Please select

Oleh Patrushev

21 0

Projects 21
Rating -
Rating 612

Budget: 500 UAH Deadline: 3 days

Hello to you! I can do. There is experience. Write, we will agree.

Mikita Maslov

1 1

Projects -
Rating -
Rating 73

Budget: 500 UAH Deadline: 1 day

I am working with Google Apps Script.
Ready to implement the project.
I have a few details, waiting for the contact.

Andrew Kr

Winning proposal

8 0

Projects 8
Rating -
Rating 270

Budget: 500 UAH Deadline: 1 day

Good day . You can try some approach. We need to discuss a few questions. Write to me

Andrey Akopov
Kyiv, Ukraine
Швейний цех Велма

Projects 3
Rating -
Rating 89

Google App script that lasts over 6 to 30 minutes

Client's review of cooperation with Andrew Kr

Google App script that lasts over 6 to 30 minutes

5.0

Andrey Akopov

Freelancer's review of cooperation with Andrey Akopov

Google App script that lasts over 6 to 30 minutes

5.0

Andrew Kr

Oleh Patrushev

Mikita Maslov

Andrew Kr

Proposals are currently absent

Current freelance projects in the category Javascript and Typescript

Development of Telegram Mini App (RPG Game)

Automation of creating vertical videos of one type using a plugin in After Effects.

Development of a Tampermonkey script for automating responses in the internal CRM via the OpenAI API.