The Execute Script Action does something similar to {CALL:X}, but it does not return values per-say. If you need a value returned, use {CALL:X}.
Here are 2 examples that show how powerful the scripting engine is…
Use Execute Script Action to invoke JScript, which runs SQL script…
Use Execute Script Action to invoke JScript, which runs a query to pull the value out of a Program Setting stored in [ProgramSettingValues] (the value of which happens to be a SQL query), then use JScript to execute that SQL Script, which has the effect of updating a row in the DB [EntityStateLogs] table … for editing Timeclock Punch Data…
