Re: Why oh why oh why won't this work.....

[Scott Parrish]

** Stephen, Create a display only field on your form: ztmpQualification. Depending on your workflow, you may want to add another: ztmpErrors Create the following:   Active Link 0 Run If: None If Action: Set Field Form Name: Current Transaction Set Field: ztmpErrors Value: $NULL$ If Action 2: Call Guide Guide Name: Guide #1 Table Loop through your table If Action 3: Call Guide Guide Name: Guide #2 (No table loop)   Active Link Guide Name: Guide #1 (In the guide, place the following active links)   Active Link 1: Run If: None If Action: Set Field Form Name: Current Transacation Set Field: ztmpQualification Value: “’Column1’ = $NULL$” (Something along those lines. Basically, we’re creating an external qualification. So that if  the value in Column1 were say Case ID+ your ztmpQualification field would be set to ‘Case ID+’ = $NULL$. Also, you are, of course, going to need to watch out for placing the quotes around the set field string.)   Active Link 2 Run If: EXTERNAL(ztmpQualification) IF Action: (I’m not sure what you are attempting to accomplish at this point, but you could copy the value in column1, which should be your field name, to the ztmpErrors field so that you could collect a list of fields with NULL values and present an error at the end of your active link guide such as this: If Action: Set Field Form Name: Current Transaction Set Field: ztmpErrors Value: $Column1$ + <return>   Active Link Guide Name: Guide #2 (In the guide, place the following active link)   Active Link 3 Run If: ztmpErrors != $NULL$ If Action: Message Error Message: “The following fields must be populated before saving your ticket:”<return>$ztmpErrors$   Hope this helps. Of course, this assumes I know what you were trying to accomplish. There may be some minor missteps in here, but I think you get the idea of how it works.   Scott Parrish IT Prophets, LLC (770) 653-5203 http://www.itprophets.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Tuesday, August 22, 2006 9:54 AM To: arslist@ARSLIST.ORG Subject: Re: Why oh why oh why won't this work.....     Stephen,   I did something very similar.. in fact mine might be even more complicated since I had to build a External filter qualification to check for database values of fields against transactional...   My requirement instead of making the field required was to audit fields that were contained on form 2.. Whenever there was a change on form 1, on any of the fields contained on form 2, to audit those fields by pushing the changes into form 3...   I even did this without the use of a table field :-) to run the loop over by running a filter loop since I HATE server side Table fields because of possibile performance concerns...   So where is it failing for you?? What I have done here works perfect for me.. maybe I might be able to throw in a clue as to where you might be going wrong...   Cheers   Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia.   ----- Original Message ---- From: Stephen Earl <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tuesday, August 22, 2006 10:25:08 AM Subject: Why oh why oh why won't this work..... I have 2 forms.... data form and form containing a list of required fields for the data form, lets call the form 1 (data) and form 2 (required fields) Form 2 contains 2 fields 'form name' and 'field name' on form 1 we have a table field containing 2 columns from form 2 showing records where form name equals the form name of form 1 What I want to achieve is an AL guide that runs across the table and checks the field name listed in the table and tests for it being NULL however it appears there isn't a way with remedy workflow to achieve this 'simple' operation. so basically what I have is a field name in another field and I want to test if that field's content is null or not, should be simple appears it isn't unless I'm missing something REALLY obvious.... All help and suggestions welcomed :-) Stephen __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___