Hey folks, i could really use some help here.
Long story short
i have a photo storage app that contains 2 Google Sheet tables
A “LOCALE” spreadsheet - listing unique names of locations
A “FEED” spreadsheet - listing photo descriptions, including the locations
Both of these tables have a “Location” column, which references each other with a REF column.
Problem is this:
I created an action that, when i edit a location name in the “LOCALE” spreadsheet, it automatically updates all the location names in the “FEED” spreadsheet.
It works fine for most items. However, if i try to edit a LOCALE name that has a lot of entries in the FEED spreadsheet (over 300 or so) i receive a “413 - Request Entity Too Large” error from the Google server, and will not update the name. Troubleshooting indicates i cannot simultaneously update numerous entries without encountering this error.
My question is this: Can anyone recommend an alternative method to update multiple entries other than a custom action (or Google formulas)? This feature is a core feature of my application, no not being to do this severely limits it’s usefulness.
Appreciate any help.
LinkedIn
Twitter
