Page 1 of 1

Active Form Auto-Rebuild

Posted: Thu Aug 15, 2019 3:18 pm
by tomok
I know I should know the answer to this but is there a setting somewhere that will cause an Active Form to rebuild automatically whenever a new value is selected from a SUBNM formula in TM1web?

Re: Active Form Auto-Rebuild

Posted: Fri Aug 16, 2019 1:04 am
by Alan Kirk
tomok wrote:
Thu Aug 15, 2019 3:18 pm
I know I should know the answer to this but is there a setting somewhere that will cause an Active Form to rebuild automatically whenever a new value is selected from a SUBNM formula in TM1web?
Interestingly I can't find a way to make that NOT happen in PA2. I know that in older versions I did sometimes have issues when the active form was constructed while manual calculation was on in Excel (which is understandable since Old Skook Web launched its own Excel sessions for rendering), but in 2.0.6 that doesn't seem to make a difference in Web. Regardless of the calculation state of the source web sheet at the time of upload, the Active Form cheerfully refreshes itself as soon as a title SubNm is changed. I even tried setting the second argument of the TM1RptView function to 0 instead of 1 and reuploading. That made a difference in Excel (where you need to rebuild manually), but not in Web (where you didn't, regardless of that value).

Most of the time when I have update issues in Web (since going to 2.0.6) it's some obscure problem with either the arguments to the Tm1RptView or TM1RptRow functions. (Or, in a multi-form report, the DBRW formulas are pointing to the wrong TM1RptView function. For some reason that still works in Excel but chokes in Web.)