Solved

Dynamical total price field on Nintex Form

  • 16 October 2019
  • 2 replies
  • 44 views
W

Hi,

I am creating a Nintex form in Office 365 that has 3 currency input fields:

4989iC312E48A64FDB4A9.png

The field Total A needs to update and show the sum of these three fields when one of these fields is filled in:

  • Investments
  • Labour Force
  • Others

I tried to do this using a formula, but this does not work, the "Total A" field does not change when entering values:

sum([SharePoint Columns].[InvestmentsA], [SharePoint Columns].[MiscLabourA],[SharePoint Columns].[MiscOthersA])

I also tried it with a "Form rule" but also no luck with this.

I am doing something wrong?

Thanks in advance.

Wouter

icon

Best answer by v-tmasenko 16 October 2019, 19:41

View original

2 replies

V
Userlevel 3
Badge +9
You're close with the form rule but you need to select the [Form] context.
Plus formulas can only be used to define variables. You can't set the value in the rule directly. (only constants can are allowed to do that)

1) create a variable called say, LandsSum of Type Decimal with the Value of the following:
sum([Form].[InvestmentsA],[Form].[MiscLabourA],[Form].[MiscOthersA])

2) create a rule:
if InvestmentsA Is filled OR MiscLabourA Is filled OR MiscOthersA is filled
then TotalA Value LandsSum
else TotalA 0.00
W
Thanks! It worked!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings