I am totally new to Google-apps-script and this may be very poor question
I am making a basic setup using google forms and google apps script
From the responses of form I change my content in Google Spreadsheet accordingly
For example my query from form needed 10000 records to be selected and produced in whole another spreadsheet
I just wanted to know that is there some kind of delay introduced when I set and get values of any cell of spreadsheet on such a large scale? If so on what it depends and how as a programmer can I remove or optimize them?
Thanks is advance!
Delay in changing Google Spreadsheet content via Google apps Script?
914 Views Asked by AAMBol At
1
There are 1 best solutions below
Related Questions in GOOGLE-APPS-SCRIPT
- How to display a Google Document inline image on HTML page?
- How to add Named Ranges to sub-paragraph elements in Google apps-script
- Output API data to a csv file
- automated email sending - variable in Htmlbody
- union data in multiple tabs
- How to real-time monitor the emails?
- How to pass function arguments to another function?
- Google sheers: On edit event trigger
- TypeError: Cannot read property "length" from undefined
- How to upload any file to FTP Server using Google Apps Script
- Authentication Error while using google SpreadSheet API
- Javascript on Google Sheets - Get Column Number from Prompt Input
- Apps Script, Count BG Color function on conditionally formatted cells
- Edit a google spreadsheet using javascript/client side code
- Import google spreadsheet data to google doc app script
Related Questions in GOOGLE-SHEETS
- Ignore #VALUE! error in SORT function
- Count Unique Values Repeated Dates
- Skyscanner Flights API and Google script
- Not able to access spreadsheet using google spreadsheet API
- SPLIT using " " delimiter in Google Sheets won't always preserve period following number
- union data in multiple tabs
- Google sheers: On edit event trigger
- Conditionally formatting multiple rows with the same conditions
- Authentication Error while using google SpreadSheet API
- Javascript on Google Sheets - Get Column Number from Prompt Input
- Apps Script, Count BG Color function on conditionally formatted cells
- Unable to authenticate with Google through the Java SDK for reading spreadsheet data
- Edit a google spreadsheet using javascript/client side code
- Google Spreadsheets, match/lookup in ALL rows, except the current one
- Google apps script for Spreadsheet - russian symbol substitute as a question mark
Related Questions in GOOGLE-FORMS
- Google forms to SMS
- How to prevent Google Forms from converting form input to scientific notation format
- Uploading Image to Google Forms
- Automatic quiz selfgrading websolution
- Don't have the permission to Operate Sheets of Google Form Destination
- How to get the last entry containing a certain value in Google Spreadsheet
- Google Apps Script - Sharing outside of domain
- How can I map a Google form submission to a template and email to specific individuals as a PDF?
- How-to include two text inputs in one answer
- Changing value of a cell based on another value in the same row on Google form submit
- How to send contents of a 'Form inside of a spreadsheet' to an email address?
- how to limit form grid to one response per column
- Custom sorting google scripts
- How to pass data to a field in Google forms
- Check if Spreadsheet.getRange() Returns full cells
Related Questions in TIMEDELAY
- Delay in loading Html Page(WebView) from assets folder in real android device
- Android - How to improve osmdroid offline map performance in term of reponse time
- Delay in changing Google Spreadsheet content via Google apps Script?
- Longer Time Delay When More Then One "while" Polling Instruction
- Display an image after a time delay on html canvas
- How to force dde23 function to generate output after fixed time step
- Time delay estimation between two audio signals
- Measuring delays using .NET libraries
- How we can calculate the delay given by the following for loop in embedded C?
- time delay for sprite, cocos2d
- Loaded time zone names for en
- How to create a sleep/delay in nodejs that is Blocking?
- How to use delay() function in c using codeblocks 13.12(mingw)?
- how to apply a signal after a period of time in simulink
- How to deal with time delay when a SWTableView is being loaded?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The Best Practices article by Google is the primary reference for this. The most important advice is to minimize the number of calls to spreadsheet methods by batching operations. So, select a range that contains all the records you need, get them all at once with
getValues, process without further interaction with the spreadsheet, and output the result usingsetValues.If you follow this advice, 10000 records is still a reasonable amount of data to process by a script.