Table of Contents

How To Modify Spreadsheets With Custom JS

Under this link you will find a video that shows how to Modify Spreadsheets With Custom JS. Here you will find Documentation.

Step by step

  1. Right-click the selected folder in the Solution Explorer to add a new item, choose JavaScript:

pic

  1. Write your script or use a template:

pic

  1. Go to Calculations in the Schema section:

pic

  1. Write your calculation or use snippets:

pic

  1. Set the Events:

pic