This is a useful script function when working with a "grid" where you can calc values and/or get and set values in several types of applications using a "grid." This code works in a Notes client but it is very easy to use the same scheme in JavaScript.

Download this free guide

Download: IT certifications that stand out

Are you looking to advance your career? Expand your knowledge? Boost your credibility? Our editors put together this complimentary 19-page guide on everything you need to know about obtaining an IT certification—with special attention given to cloud and desktop certifications.

1. Create a table with four columns and four rows. Put a field in each cell and name the fields A,B,C,D.

2. Create a table with four columns and one row. Copy and paste the fields in the top table into the table. The first row starts with A_1 and the last row with A_4. The next column is B_1...etc. This one only works when you make a copy of the row in the top table. Otherwise, the names of the fields are A_1_1, B_2_2 and that will not work.

2a. Now you can hide the top table. However, do not remove the table. It is very useful if you want to change the properties for a field. You can do it in one place then copy and paste again.

3. Create an agent and paste the code into it. Then save the agent manually from the action menu and run once.

4. Create an action. Name it and from simple action, choose run agent.

You can not calc values in a very simple way in a grid. Write the values in the first three columns and run the agent by pressing the action button.

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy