User-executed Data Processing Scripts

Prev Next

This script allows you to create a button in the SQL Spreads Excel interface that an end user can click on to trigger a customized SQL query.

image.png

How to add a user-executed script

  1. Click the Data Processing button in the SQL Spreads tab.
    Data Processing button in the SQL Spreads ribbon

  2. Enter a name for your new script. The button text will match the name of the
    script.
    New Script name field for Data Processing

  3. In the execution timing options, select "When a user clicks a button."
    image.png

  4. To add a confirmation dialog before the script is executed, enter the desired
    text in the "Confirmation text" field.
    Confirmation text field in Data Processing feature

  5. Enter your SQL query.
    Enter SQL query dialog

  6. Click OK.