To @Wiz.Wazeer and @ThinhDinh
I could read your posts and the little discussion about the script used in your APP and I understand both points of view. but I think Wiz was refering to use scripts in general to these cases and not to your specific script but anyway, l’m not going to re-open that misunderstanding.
The scripts have these problem with GS when a spreedsheet has many movements or changes and in my opinion, GS loses the control of events queue therefore, the triggers are not fired always. I have seen and dealt with these issues before in other real-time systems including the annoying ping pong effect!
If Glide can modify a little (or eliminate) this restriction and let any lookup (multiple relation) can be written to one cell in a GS, we will save much effort, scripts, columns and the life will be easier.
And now with the new Sheet Edits quota (1000 per month) on Free apps, the classic procedure used by custom Shopping Carts where each item/product is written to GS using one (1) new row now, it wil consume 2 “edits” and any APP will have problems with its capacity and funcionality very fast. It’s not my case because my APP is a Pro but I’m thinking about new users and their no complex APPs.
This improvement or change associated to lookup (multiple relation) can help to many people with medium/big APPs.
May @Mark give us a hand with it in order to have a final solution or hope? Sorry if I bother you my virtual friend.
Thanks eveyone for your help!
Feliz día para todos.