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
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.