Google Spreadsheet Script Help

종료 등록 시간: 3년 전 착불
종료 착불

Hello,

I've created a Dynamic Dependant DropropDown List that works well (Problem 1 screenshot) if the data is creating the list from is no more than 2000 rows (Problem 2 Screenshot). More than that it gets stuck, either giving me and endless "Loading..." message or not responsive.

Code in problem 3 screenshot.

I need some help here to see where I missed something.

Thanks!

JavaScript Google Sheets Excel VBA Excel Macros

프로젝트 ID: #24751257

프로젝트 소개

11 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 3년 전

이 일자리에 대한 프리랜서 11 명의 평균 입찰가: $29

schoudhary1553

I can help you with your project - Google Spreadsheet Script Help I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several 기타

$100 USD (3일 이내)
(68 리뷰)
6.5
legioner80ru

Hello. thank you for your interest in my profile. I am ready to implement the project. Best regards, Dima

$30 USD (2일 이내)
(2 리뷰)
1.3
venibimal

I am well fitted for the job , as I do typing in a very fast manner. I have some fast typing speed up to 65 to 75 words per minute.. which will make me to do this job easily and could deliver this work on time.

$20 USD (2일 이내)
(0 리뷰)
0.0
kajal0794

An Experienced professional looking for work, can complete it within time, Request you to offer we the work. Regards, Kajal Raghuwanshi

$20 USD (7일 이내)
(0 리뷰)
0.0
clearatul0

Problem 1 works fine Problem 2 (will happen if you have 2000 options. but you can divide it into main category & sub category so that only few options will show up if 1 main directory is selected) Problem 3 can be solv 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
abhijeetkr

Hi! I saw your code that's fine. What I suggest you to use formulas to generate dependent drop down instead of using script. I will set up this on your sheet.

$20 USD (1일 이내)
(0 리뷰)
0.0
Tandui

i think am the person to do this project because am i have studied for the skills over 2 years and and have the ability to solve any problem coming across

$20 USD (7일 이내)
(0 리뷰)
0.0
vw1661769vw

I have the necessary experience to develop a solution to your problem, I have 10 years of experience in information management, Excel Macros and Google Sheets, Google Appscripts

$12 USD (2일 이내)
(0 리뷰)
0.0