Does anyone here know if there is a way to reload only some of the sheets/tabs when editing the Glide apps?
I have lots of AWS S3 links in my app and every time I reload the sheets to see my latest app edits it also re-loads the links to S3. The issue is that AWS charges per call so every time I reload the S3 links, it adds to my S3 cost.
I’m wondering if there is a way to re-load only some of the Google sheets (the ones that don’t contain the S3 links).
That is impossible, sadly. Besides, if you are going to have users using your app, then that will also be lots of calls.
@RonnieL you may be able to use importrange and a second workbook to avoid the extra charges.
I think this may be your best cost affective alternative.
Thanks for the tips.
@Eric_Penn can you elaborate on how the importrange saves the calls to S3? I am not sure that I understand it. Thanks!
I would recommend starting a second workbook and putting the data we don’t want reloaded in there.
Next we’ll use
importrange function to call the data back to the original. Here is an example of how to use importrange.
To find your link navigate to the share button. (In your new workbook)
Back in the original… copy the formula above and replace MathScore with your sheet name from the new workbook.
After the sheet name enter in your range, in this example it was A2:Z
As I understand it, any data in a second workbook will be unaffected by glide edit/reloads.
@Drearystate is truly an expert in this field and would love to hear his approach
Tip: When copying your link for IMPORTRANGE select “Restricted Only people added can open with this link”
The restricted link is inherently more secure