Hui-Qing Bao,
There currently is not an "Eval" type function in ARS. (Although it has been asked for for years and by multiple customers.) I think your only option is to do the substitutions yourself. Here is what I would suggest. When the users are building the Policy records you need to keep a bit more data. (maybe restructure your data would be easier.. maybe not. You need to get the Field ID values in to discrete records for "Nth" order flexibility.) Then you can use the "Application-Copy-Field-Value <target_field_ID> <source_field_ID>" special command to get the value from the user specified <source_field_ID> into a temp field. Then you can either use a REPLACE() function to sub in the value to the string that the user sees when they are setting up the Policy (example; "$Sale Representative Email$; $Finance group email$") or you can just concatenate all of the configured values. (with ";" or hard returns dependent on your ARS server OS/Email configuration) Note: "Application-Map-Names-To-Ids-L" might also be a help if you want to go that route. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 11/7/06, Bao, Hui-Qing <[EMAIL PROTECTED]> wrote:
** Hi, I have a contract form, I got requirement to send email notification to different people when contract is approach/pass expiration date. In this form, I have contract information plus 'Sale Representative Email', 'Regional VP Email", 'Finance group email' and 'Customer email'. The requirement is: 90 prior contract expiration date, an email will send out to 'Finance group' and Sale Representative. 60 prior to contract expiration, another email will send out to Finance group, Sale Representative, plus Regional VP……..the email offset day is 30, until 60 days pass contract expiration date, some email will go to our customer plus the list above. In another word, every 30 day an email will go out to different people with different message. Instead of create 6 different escalations, I want just use one escalation. So I created a Contract Email Policy form with total of 6 records/policy. In this form I have a field called 'Send Email To' with a data dictionary menu attached to it. The menu will pull all filed name from Contract form. Since each email is sent to different set of people, the value for this filed will be the combination of different person: $Sale Representative Email$; $Finance group email$ or $Sale Representative Email$; $Finance group email$; $Customer email$ When a contract is created, system should first pull 90 day policy from Contract Email Policy form to Contract form. I was hoping the value of 'Send Email To' filed will be resolved to something like: [EMAIL PROTECTED]; [EMAIL PROTECTED] ; but instead, I got literal string: 'Sale Representative Email$; $Finance group email$' So my question is if it's possible to achieve what I was trying to do: get value resolved during a set field action. If not, what is the best way to do it?? Thanks a lot, Hui-Qing Bao Remedy Administrator/Developer iDirect Technologies 13865 Sunrise Valley Drive Herndon, VA 20171 703-648-8104 __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
