Forms Designer Forum

Hi,

Though sure it's a common request, I have not been able to find a solution in the forum...

The isue is:

Main list: Order (oredrNum, Customer, TotalAmount)

Related list: (ordernum, rownum, article,units,price, amount )

In the Order form, I have the realted items and works ok

I want to show in a "plain text" control above the related list, a total (=sum(amount)) dynamicaly computed if rows are modified /added /deleted

Once form is submited, I want to save the total in a column "TotalAmount" of the main form.

Can you help me?

Thank you

Hi,

You can configure calculating totals in the view settings. Next, pick the view with totals in the Data Source dialog of the Related Items control. As for coping the value to a field, use JavaScript. Our support team can assist you with the code, just send the detailed description of the form with screenshots to support@spform.com and we will estimate the task.