How do I add 2 columns and set value in line UDF for each line when i click a button

Tichaona Gaza

• October 22, 2023 15:53

Good day

I create a button on a sales quote. I need to calculate the sum from 2 columns and set the value in anther UDF in the same line. This will be done for all items added on the the sales quote.

Vote

0

• 

  Geoff Booth

  • October 22, 2023 16:41

  You need to create a Validation (trigger) to execute a Universal function (UF) to set the value.

  Instead of a button you want the Validation to trigger on the Field1 & Field2 validate event so that if either field changes the UF is fired.

  UF type Macro would be something like this: (Change the field values as required)

  @STORE1 = SQL(Select SUM($[$38.11.NUMBER]+$[$38.14.NUMBER])); // Sum the two fields Set($[$BOYX_1.0.0]@STORE1); // Set the "UDF" to the @STORE  ... use the .0 syntax instead of .NUMBER to set from @STORE
• 

  Tichaona Gaza

  • October 22, 2023 17:34

  Hi Geoff,

  Thank you so much for your response.

  I need a button as they are going to be several calculations I would need to setup and are done at certain stages. Some may be skipped and so on. So user needs to ability to manually run these on their own.

   

   

Please sign in to leave a comment.