topic Re: Dynamic view Refresh Error Issue in App Development

Dynamic view Refresh Error Issue

jjustingkm — Thu, 28 Aug 2025 16:08:57 GMT

I am getting a dynamic error refresh error issue when the template apps chart doesn't have any data to return.

this is the massage I get type error cannot read properties of undefined (reading '0)

I suspect the failure happens during the first time refresh the subsequent are successful.

Re: Dynamic view Refresh Error Issue

edwin — Thu, 28 Aug 2025 18:56:42 GMT

the first time the sheet is opened, the DV will refresh. of course if you dont have any selections, the binding variables are all null. what i do is for each binding variable i pick up the COUNT (odagcnt_....), i do this for all the binding variables i use in my script. there are constraints weve built in and if any count is wrong, i test all the COUNTS and exit script so that the rest of the script is not executed - NO REFRESH ERROR message. then in my DV, i add a calculation condition incorporating all the COUNT constraints, and in the calculation message i list out any violation of constraints

this way the failure is graceful and the message helps the user by pointing out what needs to be changed in the selections

Re: Dynamic view Refresh Error Issue

jjustingkm — Thu, 28 Aug 2025 20:46:38 GMT

In this case, the failure happens after I select all the filters and run, mostly I noticed the failure happens in the first run.

For example, if country and date are the filters, if I select country Mexico , Date 8/28/25 and run the error message gets, but again i refresh it runs successful.

Re: Dynamic view Refresh Error Issue

jjustingkm — Fri, 29 Aug 2025 17:06:48 GMT

And also get this message after the failure and if try to refresh again immediately after that.