I missed something. What's wrong with 'Table Field' = $NULL$? I'm not sure how you're using it, though. I just added a table field and button to a test form, and a new AL, triggered by the button, with a Run If 'Table Field' = $NULL$. If action displays a message
It's null and Else action displays a message It's not null, instead it's value is $Table Field$ I tested both scenarios and it worked fine. I'm running ARS 6.0.1, patch 1497. The "value" of 'Table Field" (the name of your table field) is the current row number. It's null if there are no rows in the table field. It's 0 if there are rows, but none has been selected. It's > 0 if a row is selected. You'll want to make sure that you refreshed the table field before testing it, and that no other workflow or user action cleared the table field. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] "Kemes, Lisa" <[EMAIL PROTECTED] To: arslist@ARSLIST.ORG RONICS.COM> cc: Sent by: "Action Subject: Re: Table Fields Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 12/19/2006 15:19 Please respond to arslist ** Can you use $LASTCOUNT$ on a table field? Or is it just to see how many rows were returned when doing a search on a form. I have ARS 6.3 and Remedy user 6.3. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Keller Sent: Tuesday, December 19, 2006 3:05 PM To: arslist@ARSLIST.ORG Subject: Re: Table Fields ** first refresh the table, and then look to see if $LASTCOUNT$ = 0 -Aaron * Email: [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, December 19, 2006 2:59 PM To: arslist@ARSLIST.ORG Subject: Table Fields Hello Listers! How can you test to see if there is nothing in a Table Field? I tried 'Table Field' = $NULL$, but nothing happens. I want to create workflow if a Table Field is NULL (no rows) Let me know if anyone has the answer! Thanks! Lisa SunCom is the wireless company that's committed to doing things differently. Things we want you to know. This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by the attorney-client privilege. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"