How do I add 2 columns and set value in line UDF for each line when i click a button
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.
Comentarios
2 comentarios
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
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.
Iniciar sesión para dejar un comentario.