Brien, Thank you for your reply and for taking the time to test this. Can you explain the 'get relationship'? I cannot find a reference to this in either the Form/Apps manual or the Workflow manual.
I'm doing another log, including a SQL log. I use SQL Navigator to look at the table more directly. If you know of a better tool I'm open to suggestions. Thanks, Christine On Oct 7, 6:18 pm, Brien Dieterle <[email protected]> wrote: > I don't think that is it. In fact I just made a test form exactly as > you described and it works fine. I am betting you have some other > workflow manipulating that field. Can you do a "get relationships" on > those fields and check for any set fields and push fields operations > from other workflow, particularly on the TempReqSummary field? You > could also just try adding the "`!" to the end of the filter name just > for giggles to see if that works, and/or cranking up the execution order. > > Brien > > On 10/7/2010 4:12 PM, Christine wrote: > > > > > > > Brien, > > > The default value of the field TempReqSummary is #First Name# as > > defined on the form, in the Field Attributes Default Value. > > > When entering the information on the form, I enter the name Denise in > > the field First Name. Upon submission the Replace function is changing > > the TempReqSummary value to the value in the First Name field (in this > > case, Denise). This is as I want it. I see this happen in the log. > > > When the record is saved, the saved value is back to #First Name#. Is > > the Default Value overwriting the Set Fields Replace() function? > > > Thank you for your help, > > Christine > > > On Oct 7, 3:23 pm, Brien Dieterle > > <[email protected]> wrote: > >> Is there a Set Fields operation that is setting $TempReqSummary$ to > >> "#First Name#", or is "#First Name#" the default value or the value you > >> are entering into the field manually? > > >> Brien > > >> On 10/7/2010 1:25 PM, Christine wrote: > > >>> I’m using the Replace() function in a filter Set Fields action. I can > >>> see in the logs where the Replace() is successful during filter phase > >>> I processing. However, when the record is saved the original value of > >>> the field (not the Set Fields value) is still present. > >>> Original Field Value: #First Name#; > >>> Filter Set Fields action: REPLACE($TempReqSummary$, "#First Name#", > >>> $First Name$) > >>> The result in the log is the first name in the field TempReqSummary. > >>> Entry from the log is: “TempReqSummary (536871236) = Denise;” > >>> When the record is finally written to the db the TempReqSummary has > >>> the value of #First Name#, not ‘Denise’ as I am trying to achieve. I > >>> see nothing else in the log where this value is getting overwritten. > >>> I’m logging both ACTL and Filters. In the log when this filter is > >>> complete there is the message “End of filter processing (phase 1) – > >>> Operation Create on (form name) -<NULL> “ > >>> I’ve been looking at the filter processing for the email message > >>> creation which uses this type of Replace() action. I’ve logged that > >>> process but I can’t see what actually ‘seeds’ the value in the target > >>> field. There is no ‘commit changes’ in filter processing as in ACTL. > >>> I’ve read and re-read the Workflow manual about filter phasing but I > >>> am obviously missing the fix for this. > >>> Can anyone direct me to what I should read/understand next in order to > >>> get this working? > >>> This may be a very simple replace function, but it is a test of > >>> something larger that will aggregate values of multiple fields into > >>> one text field with other wording and formatting. > >>> Thanks, > >>> Christine > >>> _______________________________________________________________________________ > >>> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > >>> attend wwrug10www.wwrug.comARSlist:"Where the Answers Are" > >> _______________________________________________________________________________ > >> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > >> attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"- Hide quoted > >> text - > > >> - Show quoted text - > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text > - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
