Use VB-Script to do calculations

Hi Idan,

1. Below is a sample script for calculating VAT. It should help you get started.
2. In that situation you would first have to get the propertyvalues from the client and then get property A from those propertyvalues.
3. Se sample below
4. The type needs to be able to hold the output data. If the result has decimal values you cannot use an integer type property. But you can use Number (Real) or Text

'Script for calculating invoice amount + VAT, automatic value
Option Explicit
Dim iPDAmount : iPDAmount = Vault.PropertyDefOperations.GetPropertyDefIDByAlias("PD.Amount")
Dim iVAT : iVAT = 25 'percentage of VAT
Dim szAmount : szAmount = PropertyValues.SearchForProperty(iPDAmount).TypedValue.DisplayValue
'err.raise mfscriptcancel, szAmount & "  " & szAmount * ("1," & iVAT)
if not szAmount = "" then
	Output = szAmount * ("1," & iVAT)
end if

Hi Idan,

1. Below is a sample script for calculating VAT. It should help you get started.
2. In that situation you would first have to get the propertyvalues from the client and then get property A from those propertyvalues.
3. Se sample below
4. The type needs to be able to hold the output data. If the result has decimal values you cannot use an integer type property. But you can use Number (Real) or Text

'Script for calculating invoice amount + VAT, automatic value
Option Explicit
Dim iPDAmount : iPDAmount = Vault.PropertyDefOperations.GetPropertyDefIDByAlias("PD.Amount")
Dim iVAT : iVAT = 25 'percentage of VAT
Dim szAmount : szAmount = PropertyValues.SearchForProperty(iPDAmount).TypedValue.DisplayValue
'err.raise mfscriptcancel, szAmount & "  " & szAmount * ("1," & iVAT)
if not szAmount = "" then
	Output = szAmount * ("1," & iVAT)
end if

I would like to add some websites that should help you with M-Files scripting.

User guide: https://userguide.m-files.com/user-guide/latest/eng/faq_how_do_i_write_a_visual_basic_script.html#faq_how_do_i_write_vbscript
Official documentation: https://www.m-files.com/api/documentation/#introduction.html

User guide is for complete beginners, so I would read through it a bit.
Documentation consists of all methods, properties, objects, etc.,, so for example, you can search "GetPropertyDefIDByAlias" in the left side search box and see what the method does.

Also, quick notes:
Output only works if you use scripts on a property (in property definition) - so output is that said property's value.
If you use scripts in workflows, the system doesn't know by itself where you want the output to go, so you will need to use PropertyValues and the SetProperty (SetProperties) method. See https://developer.m-files.com/APIs/COM-API/Reference/#MFilesAPI~VaultObjectPropertyOperations~SetProperty.html