Eli, I dismissed your idea out of hand. I apologize. I'm going to use a combination of your idea and Fred's.
The staging form will, on merge, check to see if a user exists in CTM:People and will pull the person ID into a field. The next two filters will fill in selected fields on the staging form from CTM:People and then check the support staff value and set the staging form to match prior to pushing to CTM:People. Thanks all! J.T. Shyman Column Technologies -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling Sent: Monday, December 10, 2007 1:11 PM To: arslist@ARSLIST.ORG Subject: Re: Push fields only if not $NULL$ J.T. Why would you only push to fields that are NULL? What if your source has updated since the record was created in the staging form...wouldn't you want the updated value? Would it be easier to define certain fields that you did NOT want to update if there was a pre-existing value. You'd still need to have a filter (or action) for each field...but this would trim the number down from 82. If you wanted to do something for all 82 fields you might be able to get creative with a SQL set fields statement. I couldn't come up with it off the top of my head but you might be able to identify the empty columns that way... Just a few ideas.... Cheers! Eli ________________________________ From: Action Request System discussion list(ARSList) on behalf of J.T. Shyman Sent: Mon 12/10/2007 10:01 AM To: arslist@ARSLIST.ORG Subject: Push fields only if not $NULL$ ARS 7.0.1 We have a staging form with People information. We are performing a check to see if a user matching the staged data already exists. If so, we want to push only the fields on the staging form that are not $NULL$. My thought is to do this with a filter guide and a separate filter for each field...but there are 82 of them. That's a lot of workflow. Is there another way to do this? J.T. Shyman Remedy Consultant Column Technologies [EMAIL PROTECTED] AIM: JToddShyman Y!IM: MCIQuincy ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
