Clearing a formula control field

フォローする

Michael Buckingham

• 2019年06月26日 21:01

I have a Formula control field that adds values from several other drop down list controls. works great

I have a clear values button with rules to clear selections from these drop down lists if selections were made. also works great

However i can not use a rule to clear the calculated value held in the Formula control.

Is there a way to clear this value in the Formula field when the clear value button is clicked?

 

Thanks

0

• 

  AgilePoint NX Support

  • 2019年06月29日 23:10
  • 編集済み

  Hello Michael,

  You can write a small piece of java script code to clear formula control value and you can execute that method in rule.

  for e.g.

  function ClearFolmulaField(){$('#FIELD_INTERNAL_NAME').val("");}

  Please replace 'FIELD_INTERNAL_NAME' as the internal name of your formula field.

  

   

  Thanks.

  0

  コメントアクション パーマリンク
• 

  Michael Buckingham

  • 2019年07月01日 12:45

  This worked perfectly, thanks!

  0

  コメントアクション パーマリンク

サインインしてコメントを残してください。