1 Reply Latest reply on Apr 22, 2015 7:15 AM by philmodjunk

    Script in calc field



      Script in calc field


      Looking for a way to hard code a script to have 2  portions of a text string run 2 scripts.

      Example I have 3 calc field, 2 that count records from a related tables and a 3rd that calls the Category field, ProductName field and the 2 count fields. Resulting in 

      Category: Electrical  1900 Box  Number of Files: 3   Pictures: 2

      I would like the 3 and the 2 to be scripts that would take you to that related table.

      I have done this with empty text box via button setup/preform script and it works however if my Category or Product name results in a shorter values it moves the results of the 3 and 2 further to the left and my empty layover text boxes stay put. So I thought there may be a way to hard code the GoToRelated Script in a cal field for a portion of the text and or slide the layover boxes as needed. 
      I know I could place a 4 fields on the form but would not look as comprehensive and leave gaps. 

      hope this make sense

        • 1. Re: Script in calc field

          Why can't you set up  the Number of Files and Pictures fields as buttons or with the OnObjectEnter trigger to perform scripts?

          You can't define a calculation field to perform a script and I can't quite picture from your description how that would work.

          You can format a field as a button by selecting it in Layout mode and using button set up from the layout menu.