User-executed Data Processing Scripts
    • Dark
      Light
    • PDF

    User-executed Data Processing Scripts

    • Dark
      Light
    • PDF

    Article summary

    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.


    Was this article helpful?