executeapplescriptformula

executeapplescriptformula

SCRIPTTEMPLATE

The** executeapplescriptformula **statement executes an AppleScript, with embedded Panorama formulas.

**Parameters**

This statement has one parameter:

** scripttemplate** – Text of script template.
Within the template you can place Panorama formulas that have a text result using this syntax:

```
"«formula»"
```

You can place formulas that have a numeric result using this syntax:

```
#«formula»#
```

**Description**

This statement executes an AppleScript. Using special tags, the script can access formulas that use Panorama fields and variables. (The formulas are actually calculated in advance, then substituted into the AppleScript code as constants.)

This example sets two AppleScript variables. *var1* is set to `She said "hello"`

. *var2* is set to `12`

. (Of course this script is not very useful since it doesn’t do anything with these variables.)

```
local x,y
x={She said "hello"}
y=2+2
executeapplescriptformula {set var1 to "«x»"}+cr()+
{set var2 to #«y»*3#}
```

Note: This statement is included for compatibility with older databases, but for new applications we recommend using the applescript statement or applescript( function.

**History**

Version | Status | Notes |

10.0 | No Change | Carried over from Panorama 6.0. |