Encerrado

Fix small issues with Google Sheet App Script that creates Sub Folders & Files on edit.

Job Description:

I have a Google sheet that I use as an index for all my product stock. Inside this sheet, I already have two working App Script functions created that work, but I am having some small bug issues. So I am looking for a fresh pair of eyes to debug and help fix.

The first function is createFolderSubFolders to work On Edit and as the name suggests it creates folders and files based on edit from values from column A & B. The second script function WriteURLs works with an On Open trigger and it searches the parent folder to find the Folder and File containing specific text related to values in column A and B, gets the URLs and puts the values inside Column L & M.

1. The createFolderSubFolders script already has a find test implemented in the code to check If Folder Already Exists but it doesn't seem to work. Therefore, the issue is file and folder Duplicates are created with the same exact title, so I need help to debug and fix to avoid this unnecessary action.

2. Small Improvement, the createFolderSubFolders script works with values from Col A & B, however I think it would be better now to set an extra IF condition to only create folder when ‘Draft’ is selected from Colum C, this provides extra protection when adding new values on edit.

3. The second script function WriteURLs works when tested in a separate sheet but I unfortunately can’t get it to execute when used in the same index sheet as createFolderSubFolders. So I need some help to implement both scripts in same sheet.

I am happy to discuss more details with you on chat and work alongside you to complete the task. If you have experience with app script, I believe this will be a very quick, easy job for you.

Comment with "INDEX" in your bid proposal so that I know you're genuine and have read this project bio.

Thanks,

Habilidades: JavaScript, Google App Engine, Google Sheets, Google Apps Scripts

Sobre o Cliente:
( 6 comentários ) Ayr, United Kingdom

ID do Projeto: #35449210

20 freelancers estão ofertando em média £24 nesse trabalho

kanwalrafique

INDEX Hello, I'm an experienced Google Apps Scripts developer. I can help you fix the bugs in your code and improve it. I'd like to know why you're not using DriveApp's searchFolders method to find a specific property Mais

£20 GBP em 1 dia
(50 Comentários)
6.3
aryan151

Hello Sir Hope you doing well I just checked your project details *Fix small issues with Google Sheet App Script that creates Sub Folders & Files on edit* and It matches my expertise. I have 14+ years of experience i Mais

£100 GBP in 2 dias
(141 Comentários)
6.0
BitLabs

Hello, I have gone through your outsourced requirements " Fix small issues with Google Sheet App Script that creates Sub Folders & Files on edit. " and have analyzed that I have right skills ( JavaScript Google App Mais

£13 GBP in 7 dias
(22 Comentários)
5.3
Actisoft2017

Hello, Nice meet you! I have read your project requirements and then I am sure I can complete that project. I can help you. Thank you.

£13 GBP in 7 dias
(7 Comentários)
4.7
softechk

Hello, as mentioned in project description, here is word "INDEX". As mentioned in project description, 1) You have a Google sheet that you use as an index for all your product stock. 2) In this Google sheet, there are Mais

£15 GBP in 3 dias
(27 Comentários)
4.7
ZosneS

INDEX Hi, I am senior Web developer. I have a lot of experiences in PHP and JavaScript. I am also very familiar with PHP templates such as Laravel and CodeIgniter. I can build backend with Laravel, frontend with React. Mais

£15 GBP in 7 dias
(1 Comentário)
3.5
younesboulahya

I can debug this for 25, contact me if it's still available

£25 GBP in 7 dias
(6 Comentários)
3.3
lou997

INDEX Hi I have experience with Flutter and MERN for 2 years with an year of freelancing experience. And i can build quality web app within your budget and timeline. Let me know if you're interested so we can talk more Mais

£13 GBP in 7 dias
(3 Comentários)
1.7
RubenBorja1988

"INDEX" Hi Dear client! I am a Data Processing Expert with 5 years of experience in Google Apps Scripts so I can surely make you happy. Best regards. Jaime.

£50 GBP in 2 dias
(2 Comentários)
1.5
mna9226

Hello, "INDEX" Please review my profile as I have the relevant skills and experience required for this project. I can start working right now. Kindly send me a message to discuss further for references, portfolio, a Mais

£50 GBP em 1 dia
(0 Comentários)
0.9
Akbaryusufzai007

Greetings I can surely help you for Fix small issues with Google Sheet App Script that creates Sub Folders & Files on edit. I am in the IT industry since more than a decade and serve so many clients for building and Mais

£10 GBP in 2 dias
(0 Comentários)
0.0
devastatingram

ok i understood your requirement but I have few doubts, text me so I can clear all my doubts right away, I can help you and i am ready for work. Thank you.

£13 GBP in 7 dias
(1 Comentário)
0.0
Jaweria101

Hi Sir , INDEX I can create a new Responsive Wordpress website design and development...I am a Responsive WordPress, CSS and PHP HTML Excel Java Script developer with 12 years of experience .. I have done 100's of W Mais

£13 GBP in 7 dias
(0 Comentários)
0.0