All, Thanks for the suggestions, great as always, however for completeness I managed to resolve our issue using one of the new run process actions Application-Copy-Field-Value which lives in a guide as follows:
AL 1: Set Fields: set temp display-only field with value of fieldid from form2 AL 2: Set Fields: set value field using the run process AL 3: Set Fields: evaluate if field is null or not Set Fields: if null set field name to display-only char field Set Fields: if null set field label red AL 4: Set Fields: set display-only fieldid to null, set value field to null set this guide to loop across the table rows, adding field names and label colours for each 'null' field Once complete open a dialog stating the error and giving a list of fields that have been left as 'null' which now also have the labels in red to prompt the user :-) Again thanks for the suggestions.... Also I couldn't do this with filters as we are evaluating on client before passing values back to the db. Thanks again Stephen On 22/08/06, Scott Parrish <[EMAIL PROTECTED]> wrote:
** 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:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, August 22, 2006 9:54 AM To: [email protected] 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: [email protected] 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___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
