4 Replies Latest reply on May 27, 2017 8:08 AM by martinc

    Name a script to run in a field?

    martinc

      We have lots of automated FM reports that go out via email.  I have scripts with nested scripts.

      Example:

      Monday am script is just a bunch of perform script commands.  Each script sends out the monday reports to various people.

       

      Since we have a lot of them, it's a pain to manage

       

      I started building a Reports table.  Each record would correspond to a report that is generated by a script.  Each report would have a check box list of recipients by job title.

      I put a field in the Reports table that references the corresponding script...Question: Is there a way to fire a specific script based on the text in a field?

      If I put a trigger on a field, that would not be record specific.

       

      Example

      Record one references a payroll report

      Record two references a sales report

      I loop through the records and send the respective report to the associated job titles

       

      This would make it much easier to turn on/off various report, determine who gets them, how often and so on.