add timing to formula

[mohamedabdo]

i have code in google sheet and i need to set pause timing between per request ,

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

[janmorris]

Try adding SpreadsheetApp.flush()

This finalises the previous work before the next continues.

If this doesnt work (for example in cases where files are being created in the background), then try adding a "sleeper" function to flush, pause for few seconds (to allow file creation to do its thing), followed by another flush. Like this:

Please Login or Register  to view this content.

[mohamedabdo]

thanks brother [janmorris for your support i added the full formula as below but not work or can edit full formula and send me again

Please Login or Register  to view this content.

[6StringJazzer]

To all participants:

Administrative Note:

You should include code tags around your code. This has already been noted by Ali and ignored.

I have added the tags.

Although you are not subject to penalties for not using code tags, they are essential in readability of your code. Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

[janmorris]

Here is how you would call the sleeper function from within another function:

Please Login or Register  to view this content.

HOWEVER, it seems you have only given a part of your script, so it is doubtful that the above method will work. Instead, you should be calling the sleeper function within the loop of your other function that is calling the FETCH function.

I suggest you try posting an enquiry to the Google Apps Script group... keep in mind that you should provide enough of yoru full script so that others can understand what is actually happening.

Here is the link to the Group:
https://groups.google.com/g/google-a...ript-community