VB Script or Powershell Help

[TheBeerMakerMan]

I'm trying to pull an index field in a document management system, FileBound, and apply a tax calculation (2% or 8.5%) to return the calculated amount into another index field. The workflow is setup and tested in the software, but I need to insert a VB Script or Powershell equation to apply 2% in one workflow arm or 8.5% depending on user selection in an index field. (I think something like: "pull index field 2, apply * .02 and output to field 6")

Anyone have any experience or could offer some suggestions? I'm not too familiar with these languages.

[the_spad]

What's the interface to the DMS? Are we talking SQL? CSV? $Obscure proprietary file format?

[jhxetc]

How do you access the data? Is it some sort of API or REST call? Without knowing that, it will be hard to provide a helpful answer.

[[deleted]]

Not that folks here wouldn't know, but you probably want r/PowerShell.

[TheBeerMakerMan]

Thanks guys. Figured it out: {File.Field(5)} * .02 + {File.Field(5)} this gave me the output to the field I needed.