Mirror formcalc result to another page and cell

[brainstewn]

I want to take the results of Page8.Table6.Row25.GrandTotal and display the result as read only in Page2.Table2.Row12.GrandTotal.

How do I do this?

Thank you in advance for your time and expertise.

Darrell

[Former Community Member]

You can add the following script after calculating the Grand Total on Page 8:

Page2.Table2.Row12.GrandTotal.rawValue = Page8.Table6.Row25.GrandTotal.rawValue

Also, make the field GrandTotal on Page 2 as Read Only.

Thanks,

VJ

[brainstewn]

Thank you VJ! 

1) I tried adding the = line you mentioned in this cell Page8.Table6.Row25.GrandTotal

          Sum(Table6.Row24.SubTotal1+Table6.Row24.SubTotal2)

          Page2.Table2.Row12.GrandTotal.rawValue = Page8.Table6.Row25.GrandTotal.rawValue

          This disabled the sum script so I

2) I tried adding the = line you mentioned in this cell Page2.Table2.Row12.GrandTotal and selecting "initialize" in the show dropdown and used Javascript as the language.

But neither worked.  What am I missing?

[Former Community Member]

Hi brainstewn,

I would like to take a look at the form.

Is it possible to share the form @ kvdvijaykumar@gmail.com  ?

Thanks,

VJ

[Former Community Member]

Hi Brainstewn,

I think the mistake you  have done is : you  haven't included the "TopmostSubform" name in the path.

However, you can add the following code on the layout:ready event of the "Grand Total" field on Page8.

TopmostSubform.Page2.Table2.Row12.GrandTotal.rawValue = this.rawValue;

Thanks,

VJ

[brainstewn]

Hi VJ

I'm not sure where to place "TopmostSubform.Page2.Table2.Row12.GrandTotal.rawValue = this.rawValue;"  Do I place it in the cell on page 8 or page 2?  The cell in Page 8 is the one that calculates.  The cell on page 2 is what I want to mirror the cell calcuated using formcalc.

[Former Community Member · Accepted solution]

If you see my prev msg, i clearly stated that the piece of code should be placed on the layout:ready event of  Grand Total field on Page 8

I think the mistake you  have done is : you  haven't included the "TopmostSubform" name in the path.

However, you can add the following code on the layout:ready event of the "Grand Total" field on Page8.

TopmostSubform.Page2.Table2.Row12.GrandTotal.rawValue = this.rawValue;

Thanks,

VJ

[brainstewn]

Thanks again VJ!

I learned that when I changed the Show dropdown to ' ALL EVENTS ' I could have code in both layout ready section and calculate, this worked, thank you for your patience!