This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Do you have any idea why this happen cause it only occur after I add new table or regenerate schema which is weird as it will not happen to small changes to existing table.
Check if the script produces an error message on the apps script interface, are the scripts and the table come from the same file or does the apps need permissions granted.
what do you mean by scripts and table come from same file? For scripts i used appscript file and table is from spreadsheet. it does not show any error in the apps script interface.
It all looks fine until I regenerate other table or add new table. The script does not change. If the error happens then I just put some double quote or remove it from the function parameters and save it then it will works fine. Its just that it is weird why that error keep on happening.
Thats what I did to save it again cause usually after saving it it works fine. The error also occurs on bots that were related in the particular spreadsheet that i am regenrating or adding new table from. Even if initially it have the double quotes, the error still show.
Regeneration rebuild the structure and re add the rows. I dont suppose you will add new column every so often. Disable the bot before regeneration and enable it after the process completed.
Maybe that could work, I will give it a try. But I still feel weird cause some of the bots works fine. Its just that one app have around 50-100 bots... I will ask for support. Thanks for helping though thank you ๐
LinkedIn
Twitter
