Script / calculate subtotal of Amount during process (item line in desing view) and display it at the bottom of masterpage before continue to the others pages

Avatar

Avatar

Profene_FR

Avatar

Profene_FR

Profene_FR

08-03-2021

Dear All ,

 

I'm facing an issue and I dont know how to do without use Script .
Unfortunatly, I don't know how to build a SCRIPT into the form .
Here the purpose of my request :

I have to display an invoice.
at the bottom of each Master Page

If invoice has only one page , I need to display a subform (S1) with several data as total amount, VAt .... etc !!!!
in case of several page, the previous subform ( S1 ) is replaced by S2 to display only one information.
this information is corresponding to the subtotal of Amount red into the Design View (Table-DATA -KWERT ) into the main area. .

One page or last page : display S1

Subform S1 bottom MP.png

Intermediate pages : Display Subtotal calculated: ( Sum of each Amount read in the current page) :

   Subform S2 bottom MP.png

I think I have to do at least , 2 things:
First : create a var ( SubT_Calculate) , calculating the Sum of amount during reading of data of each row .
Second : check if I'm in last page or not.

 

in this case ( not in last page)  :

-  have to hide S1 using a script  ,

-  get Var'value calculated and Display it in S2   .

 

If this possible ?

If possible ,  could you help to find solution to fix this issue, please ?

thank you so much for all help you could provide me.

best regards,

Take Care of you and your Familly .

Best regards,

Sebastien

 

 

Accepted Solutions (0)

Answers (0)