topic Syntax for No Operation in Calculated Value Formula in Nintex for Office 365 Forum
https://community.nintex.com/t5/Nintex-for-Office-365-Forum/Syntax-for-No-Operation-in-Calculated-Value-Formula/m-p/210713#M15087
<P>I need to write a formula which updates a calculated value if there is a value in a form field, but doesn't update the calculated value if the form field is empty.</P>
<P>I've been trying to use the “If” Runtime Function, and in the formula builder the syntax is reported as:</P>
<P>If(logical_test, value_if_true, value_if false)</P>
<P> </P>
<P>How do I say, for value_if_false, do nothing? If I use quotes for value_if_false, this overwrites the value in the calculated value with a null value.</P>
<P>Or is there another way to say, for a calculated value formula, if there's a value in the form field, write that value to the calculated value, else do nothing?</P>Thu, 14 Oct 2021 01:46:20 GMTrthomson2021-10-14T01:46:20ZSyntax for No Operation in Calculated Value Formula
https://community.nintex.com/t5/Nintex-for-Office-365-Forum/Syntax-for-No-Operation-in-Calculated-Value-Formula/m-p/210713#M15087
<P>I need to write a formula which updates a calculated value if there is a value in a form field, but doesn't update the calculated value if the form field is empty.</P>
<P>I've been trying to use the “If” Runtime Function, and in the formula builder the syntax is reported as:</P>
<P>If(logical_test, value_if_true, value_if false)</P>
<P> </P>
<P>How do I say, for value_if_false, do nothing? If I use quotes for value_if_false, this overwrites the value in the calculated value with a null value.</P>
<P>Or is there another way to say, for a calculated value formula, if there's a value in the form field, write that value to the calculated value, else do nothing?</P>Thu, 14 Oct 2021 01:46:20 GMThttps://community.nintex.com/t5/Nintex-for-Office-365-Forum/Syntax-for-No-Operation-in-Calculated-Value-Formula/m-p/210713#M15087rthomson2021-10-14T01:46:20ZRe: Syntax for No Operation in Calculated Value Formula
https://community.nintex.com/t5/Nintex-for-Office-365-Forum/Syntax-for-No-Operation-in-Calculated-Value-Formula/m-p/211195#M15114
<P>The calculated value will always return a value, so you need to find a logic that return your new value and your "old" value.</P>
<P> </P>
<P>So, you can do : </P>
<P>1) Connect your calculated value to a sharepoint field (so you can "save" the value of you calculated).</P>
<P>2) In you "value_if_yes" return your new value</P>
<P>2) In your "v<SPAN>alue_if_false" return the SharePoint field value</SPAN></P>
<P> </P>
<P> </P>
<P> </P>Tue, 26 Oct 2021 17:45:08 GMThttps://community.nintex.com/t5/Nintex-for-Office-365-Forum/Syntax-for-No-Operation-in-Calculated-Value-Formula/m-p/211195#M15114nico2021-10-26T17:45:08ZRe: Syntax for No Operation in Calculated Value Formula
https://community.nintex.com/t5/Nintex-for-Office-365-Forum/Syntax-for-No-Operation-in-Calculated-Value-Formula/m-p/211594#M15119
<P>You should be able to achieve that with a <A href="https://help.nintex.com/en-US/Office365/Designer/FormsRules.htm" target="_self">rule</A> in your form.</P>Thu, 28 Oct 2021 19:52:34 GMThttps://community.nintex.com/t5/Nintex-for-Office-365-Forum/Syntax-for-No-Operation-in-Calculated-Value-Formula/m-p/211594#M15119David-2021-10-28T19:52:34Z