Hello all,
I have been wrestling with this scripting challenge for awhile and could use help. At a high level I am looking for a way to specify on a record in one table what fields I want to go capture on another table to write into a single field on the record in the original table. 3 tables are involved(but only 2 matter for the scripting):
1)Task template
2) Tasks
3) Services
Tasks are created based on tagging a service(services have their own tasks defined on the task template. Those tasks are generated and have a field called "additional fields needed". This field will have the names of fields on the services table. I want the script to look at the field names in "additional fields needed", go to the services table, find the correct record based on the service name, find the fields, grab the values, write the values into the tasks table in a field called "additional information"
Any help or advice would be greatly appreciated