Re: Active link Else Action not working
Angus, Do you want to check for 'digits' equal to null or 'digits' equal to . They are not the same thing.. Null is when there is no value (absence of value) in the character field and is a value - its just empty. Most databases recognize the difference.. You would need to check with your database what is applicable.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Angus Comber Sent: Saturday, June 05, 2010 4:40 PM To: arslist@ARSLIST.ORG Subject: Re: Active link Else Action not working ** Hi Chintan Same effect even if I remove the Run If. I think that it means that it will only run the active link if there is text in the digits field. Then applies the if test and I assumed if the If test fails it would execvute tyhe else - but for some reason it does not :( I can't understand why it won't execute the Else. Is there another way to do this? Angus - Original Message - From: Chintan Shah Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Saturday, June 05, 2010 8:46 PM Subject: Re: Active link Else Action not working ** Hi Angus, if the qualification does not find any match --Where are you checking this part? in Run If? If I understand your question correctly, then this 'digits' != is not equal to Employee not found. If if I input a number which does not exist in database digits field is still not empty and hence 'digits' != will not fail, in which case If action is executed and If No Requests Match: Do Not Show Any Message and suppress empty list. happens. In other words, the only time I see your Else action getting executed is when there is no data entered in digits field (as per Run If that you have provided here). Correct me if I am wrong in understanding your question. Thanks, Chintan --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote: From: Angus Comber arsl...@iteloffice.com Subject: Active link Else Action not working To: arslist@ARSLIST.ORG Date: Saturday, June 5, 2010, 8:58 AM ** Hello I have a button on a form which fires an active link which is configured like this: 1. active link named processdigits. Run if 'digits' != and execute on button (on my form). 2. If action tab, action=Open Window, window type=Modify, Display Type=Detail Only, Form name=employees Qualification 'employeeid' = $digits$ If No Requests Match: Do Not Show Any Message and suppress empty list. The If Action part works fine. In the Else Action Tab I have: Current Action=Open window Window Type=Submit Form name=employees Field mapping employeeid mapped to $digits$ My problem is that the Else Action never gets called. So, if the qualification in the If Action finds a match then this executes ok and I see the found employee ok. But if the qualification does not find any match then the Else Action is not executed. What am I doing wrong? Angus _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Active link Else Action not working
Wonderful. This is exactly what I was going to suggest..just to add up..you can make the 'temp field' as display-only character field since it will not occupy DB space and still its value can be used in transaction. Thnx Chintan. --- On Sat, 6/5/10, JD Hood hood...@gmail.com wrote: From: JD Hood hood...@gmail.com Subject: Re: Active link Else Action not working To: arslist@ARSLIST.ORG Date: Saturday, June 5, 2010, 5:07 PM If I'm reading you correctly, it seems like you expect the else action to fire based on the results of the if-action qualification of 'employeeid' = $digits$. That's not how it works. The Else action only fires if the main run-if ('digits' != ) evaluates to false. What you might need to do is add another active link that fires just before this one. You will use it to see if the employee exists. Run if: 'digits' != $NULL$ If Action: set fields from employees; set 'temp-field' to $digits$ where 'employeeid' = $digits$. If no match found: set fields to null. If multi-match: Use first matching request. Now, back to your original active link... New run-if: 'temp-field' != $NULL$ (means we *did* find an employee in the previous active link) If action: Do your modify window open Else action: Do your submit window open -JDHood- On Sat, 5 Jun 2010 21:40:02 +0100, Angus Comber arsl...@iteloffice.com wrote: Hi Chintan Same effect even if I remove the Run If. I think that it means that it will only run the active link if there is text in the digits field. Then applies the if test and I assumed if the If test fails it would execvute tyhe else - but for some reason it does not :( I can't understand why it won't execute the Else. Is there another way to do this? Angus - Original Message - From: Chintan Shah Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Saturday, June 05, 2010 8:46 PM Subject: Re: Active link Else Action not working ** Hi Angus, if the qualification does not find any match --Where are you checking this part? in Run If? If I understand your question correctly, then this 'digits' != is not equal to Employee not found. If if I input a number which does not exist in database digits field is still not empty and hence 'digits' != will not fail, in which case If action is executed and If No Requests Match: Do Not Show Any Message and suppress empty list. happens. In other words, the only time I see your Else action getting executed is when there is no data entered in digits field (as per Run If that you have provided here). Correct me if I am wrong in understanding your question. Thanks, Chintan --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote: From: Angus Comber arsl...@iteloffice.com Subject: Active link Else Action not working To: arslist@ARSLIST.ORG Date: Saturday, June 5, 2010, 8:58 AM ** Hello I have a button on a form which fires an active link which is configured like this: 1. active link named processdigits. Run if 'digits' != and execute on button (on my form). 2. If action tab, action=Open Window, window type=Modify, Display Type=Detail Only, Form name=employees Qualification 'employeeid' = $digits$ If No Requests Match: Do Not Show Any Message and suppress empty list. The If Action part works fine. In the Else Action Tab I have: Current Action=Open window Window Type=Submit Form name=employees Field mapping employeeid mapped to $digits$ My problem is that the Else Action never gets called. So, if the qualification in the If Action finds a match then this executes ok and I see the found employee ok. But if the qualification does not find any match then the Else Action is not executed. What am I doing wrong? Angus _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Active link Else Action not working
Hello I have a button on a form which fires an active link which is configured like this: 1. active link named processdigits. Run if 'digits' != and execute on button (on my form). 2. If action tab, action=Open Window, window type=Modify, Display Type=Detail Only, Form name=employees Qualification 'employeeid' = $digits$ If No Requests Match: Do Not Show Any Message and suppress empty list. The If Action part works fine. In the Else Action Tab I have: Current Action=Open window Window Type=Submit Form name=employees Field mapping employeeid mapped to $digits$ My problem is that the Else Action never gets called. So, if the qualification in the If Action finds a match then this executes ok and I see the found employee ok. But if the qualification does not find any match then the Else Action is not executed. What am I doing wrong? Angus ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Active link Else Action not working
Hi Angus, if the qualification does not find any match --Where are you checking this part? in Run If? If I understand your question correctly, then this 'digits' != is not equal to Employee not found. If if I input a number which does not exist in database digits field is still not empty and hence 'digits' != will not fail, in which case If action is executed and If No Requests Match: Do Not Show Any Message and suppress empty list. happens. In other words, the only time I see your Else action getting executed is when there is no data entered in digits field (as per Run If that you have provided here). Correct me if I am wrong in understanding your question. Thanks, Chintan --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote: From: Angus Comber arsl...@iteloffice.com Subject: Active link Else Action not working To: arslist@ARSLIST.ORG Date: Saturday, June 5, 2010, 8:58 AM ** Hello I have a button on a form which fires an active link which is configured like this: 1. active link named processdigits. Run if 'digits' != and execute on button (on my form). 2. If action tab, action=Open Window, window type=Modify, Display Type=Detail Only, Form name=employees Qualification 'employeeid' = $digits$ If No Requests Match: Do Not Show Any Message and suppress empty list. The If Action part works fine. In the Else Action Tab I have: Current Action=Open window Window Type=Submit Form name=employees Field mapping employeeid mapped to $digits$ My problem is that the Else Action never gets called. So, if the qualification in the If Action finds a match then this executes ok and I see the found employee ok. But if the qualification does not find any match then the Else Action is not executed. What am I doing wrong? Angus _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Active link Else Action not working
Hi Chintan Same effect even if I remove the Run If. I think that it means that it will only run the active link if there is text in the digits field. Then applies the if test and I assumed if the If test fails it would execvute tyhe else - but for some reason it does not :( I can't understand why it won't execute the Else. Is there another way to do this? Angus - Original Message - From: Chintan Shah Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Saturday, June 05, 2010 8:46 PM Subject: Re: Active link Else Action not working ** Hi Angus, if the qualification does not find any match --Where are you checking this part? in Run If? If I understand your question correctly, then this 'digits' != is not equal to Employee not found. If if I input a number which does not exist in database digits field is still not empty and hence 'digits' != will not fail, in which case If action is executed and If No Requests Match: Do Not Show Any Message and suppress empty list. happens. In other words, the only time I see your Else action getting executed is when there is no data entered in digits field (as per Run If that you have provided here). Correct me if I am wrong in understanding your question. Thanks, Chintan --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote: From: Angus Comber arsl...@iteloffice.com Subject: Active link Else Action not working To: arslist@ARSLIST.ORG Date: Saturday, June 5, 2010, 8:58 AM ** Hello I have a button on a form which fires an active link which is configured like this: 1. active link named processdigits. Run if 'digits' != and execute on button (on my form). 2. If action tab, action=Open Window, window type=Modify, Display Type=Detail Only, Form name=employees Qualification 'employeeid' = $digits$ If No Requests Match: Do Not Show Any Message and suppress empty list. The If Action part works fine. In the Else Action Tab I have: Current Action=Open window Window Type=Submit Form name=employees Field mapping employeeid mapped to $digits$ My problem is that the Else Action never gets called. So, if the qualification in the If Action finds a match then this executes ok and I see the found employee ok. But if the qualification does not find any match then the Else Action is not executed. What am I doing wrong? Angus _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Active link Else Action not working
If I'm reading you correctly, it seems like you expect the else action to fire based on the results of the if-action qualification of 'employeeid' = $digits$. That's not how it works. The Else action only fires if the main run-if ('digits' != ) evaluates to false. What you might need to do is add another active link that fires just before this one. You will use it to see if the employee exists. Run if: 'digits' != $NULL$ If Action: set fields from employees; set 'temp-field' to $digits$ where 'employeeid' = $digits$. If no match found: set fields to null. If multi-match: Use first matching request. Now, back to your original active link... New run-if: 'temp-field' != $NULL$ (means we *did* find an employee in the previous active link) If action: Do your modify window open Else action: Do your submit window open -JDHood- On Sat, 5 Jun 2010 21:40:02 +0100, Angus Comber arsl...@iteloffice.com wrote: Hi Chintan Same effect even if I remove the Run If. I think that it means that it will only run the active link if there is text in the digits field. Then applies the if test and I assumed if the If test fails it would execvute tyhe else - but for some reason it does not :( I can't understand why it won't execute the Else. Is there another way to do this? Angus - Original Message - From: Chintan Shah Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Saturday, June 05, 2010 8:46 PM Subject: Re: Active link Else Action not working ** Hi Angus, if the qualification does not find any match --Where are you checking this part? in Run If? If I understand your question correctly, then this 'digits' != is not equal to Employee not found. If if I input a number which does not exist in database digits field is still not empty and hence 'digits' != will not fail, in which case If action is executed and If No Requests Match: Do Not Show Any Message and suppress empty list. happens. In other words, the only time I see your Else action getting executed is when there is no data entered in digits field (as per Run If that you have provided here). Correct me if I am wrong in understanding your question. Thanks, Chintan --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote: From: Angus Comber arsl...@iteloffice.com Subject: Active link Else Action not working To: arslist@ARSLIST.ORG Date: Saturday, June 5, 2010, 8:58 AM ** Hello I have a button on a form which fires an active link which is configured like this: 1. active link named processdigits. Run if 'digits' != and execute on button (on my form). 2. If action tab, action=Open Window, window type=Modify, Display Type=Detail Only, Form name=employees Qualification 'employeeid' = $digits$ If No Requests Match: Do Not Show Any Message and suppress empty list. The If Action part works fine. In the Else Action Tab I have: Current Action=Open window Window Type=Submit Form name=employees Field mapping employeeid mapped to $digits$ My problem is that the Else Action never gets called. So, if the qualification in the If Action finds a match then this executes ok and I see the found employee ok. But if the qualification does not find any match then the Else Action is not executed. What am I doing wrong? Angus _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Active link Else Action not working
Could I move the qualification to the Run If field? If so I need to specify that the active link should run if the digits field on the current form finds a match in the employeeid field in the Employees form/table? Is this possible? - Original Message - From: Chintan Shah Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Saturday, June 05, 2010 8:46 PM Subject: Re: Active link Else Action not working ** Hi Angus, if the qualification does not find any match --Where are you checking this part? in Run If? If I understand your question correctly, then this 'digits' != is not equal to Employee not found. If if I input a number which does not exist in database digits field is still not empty and hence 'digits' != will not fail, in which case If action is executed and If No Requests Match: Do Not Show Any Message and suppress empty list. happens. In other words, the only time I see your Else action getting executed is when there is no data entered in digits field (as per Run If that you have provided here). Correct me if I am wrong in understanding your question. Thanks, Chintan --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote: From: Angus Comber arsl...@iteloffice.com Subject: Active link Else Action not working To: arslist@ARSLIST.ORG Date: Saturday, June 5, 2010, 8:58 AM ** Hello I have a button on a form which fires an active link which is configured like this: 1. active link named processdigits. Run if 'digits' != and execute on button (on my form). 2. If action tab, action=Open Window, window type=Modify, Display Type=Detail Only, Form name=employees Qualification 'employeeid' = $digits$ If No Requests Match: Do Not Show Any Message and suppress empty list. The If Action part works fine. In the Else Action Tab I have: Current Action=Open window Window Type=Submit Form name=employees Field mapping employeeid mapped to $digits$ My problem is that the Else Action never gets called. So, if the qualification in the If Action finds a match then this executes ok and I see the found employee ok. But if the qualification does not find any match then the Else Action is not executed. What am I doing wrong? Angus _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Active link Else Action not working
Brilliant, thanks a lot. I have used Remedy for a while, but only very simple tasks. So I can see I have a lot to learn. Really helpful, thank you. Angus - Original Message - From: JD Hood hood...@gmail.com Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Sunday, June 06, 2010 1:07 AM Subject: Re: Active link Else Action not working If I'm reading you correctly, it seems like you expect the else action to fire based on the results of the if-action qualification of 'employeeid' = $digits$. That's not how it works. The Else action only fires if the main run-if ('digits' != ) evaluates to false. What you might need to do is add another active link that fires just before this one. You will use it to see if the employee exists. Run if: 'digits' != $NULL$ If Action: set fields from employees; set 'temp-field' to $digits$ where 'employeeid' = $digits$. If no match found: set fields to null. If multi-match: Use first matching request. Now, back to your original active link... New run-if: 'temp-field' != $NULL$ (means we *did* find an employee in the previous active link) If action: Do your modify window open Else action: Do your submit window open -JDHood- On Sat, 5 Jun 2010 21:40:02 +0100, Angus Comber arsl...@iteloffice.com wrote: Hi Chintan Same effect even if I remove the Run If. I think that it means that it will only run the active link if there is text in the digits field. Then applies the if test and I assumed if the If test fails it would execvute tyhe else - but for some reason it does not :( I can't understand why it won't execute the Else. Is there another way to do this? Angus - Original Message - From: Chintan Shah Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Saturday, June 05, 2010 8:46 PM Subject: Re: Active link Else Action not working ** Hi Angus, if the qualification does not find any match --Where are you checking this part? in Run If? If I understand your question correctly, then this 'digits' != is not equal to Employee not found. If if I input a number which does not exist in database digits field is still not empty and hence 'digits' != will not fail, in which case If action is executed and If No Requests Match: Do Not Show Any Message and suppress empty list. happens. In other words, the only time I see your Else action getting executed is when there is no data entered in digits field (as per Run If that you have provided here). Correct me if I am wrong in understanding your question. Thanks, Chintan --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote: From: Angus Comber arsl...@iteloffice.com Subject: Active link Else Action not working To: arslist@ARSLIST.ORG Date: Saturday, June 5, 2010, 8:58 AM ** Hello I have a button on a form which fires an active link which is configured like this: 1. active link named processdigits. Run if 'digits' != and execute on button (on my form). 2. If action tab, action=Open Window, window type=Modify, Display Type=Detail Only, Form name=employees Qualification 'employeeid' = $digits$ If No Requests Match: Do Not Show Any Message and suppress empty list. The If Action part works fine. In the Else Action Tab I have: Current Action=Open window Window Type=Submit Form name=employees Field mapping employeeid mapped to $digits$ My problem is that the Else Action never gets called. So, if the qualification in the If Action finds a match then this executes ok and I see the found employee ok. But if the qualification does not find any match then the Else Action is not executed. What am I doing wrong? Angus _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are