Just my 2 cents..
Requirements like these ultimately converge down to a training issue where you explain to the users how important it is to have good data in that field. You might disallow spaces or multiple spaces or carriage returns - what are you going to do about users that do something like type a random string in that field? By doing the workflow you requested help on where Fred's idea is a great way to implement it, you are stopping the users from doing just 2 out of at least 10 other possible invalid type of entries and it is almost impossible to stop a user from doing any of that. Something as simple as your work log gets a periodic review from management, could probably add a better layer of protection against what goes in that field. Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Monday, October 07, 2013 1:18 PM To: [email protected] Subject: Re: Trying to validate work log not to allow Blanks Try using 2 ActiveLink/Filters First Set Worklog = LTRIM(RTRIM($Worklog$)) Second Run-If: (NOT ( 'Worklog' LIKE "___%" ) ) OR ( 'Worklog' = $NULL$ ) Error This way if the worklog entry is not at least 4 characters the user will get an error Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of sriram pm Sent: Monday, October 07, 2013 8:25 AM To: [email protected] Subject: Trying to validate work log not to allow Blanks ** Hi List, We are trying to update the work log when the ticket status is In Progress. We are able to achieve this with a Display Only Form but it allows space and enter which it should not. $Worklog$ != $NULL$ AND $Worklog$ != " "AND $Worklog$ != " " Kindly let us know whether there is any work around for this issue. Thank you, Sriram _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
