Re: Easy Question - Trying to write two filters to determine if a field value already exists on submit on COM:COMPANY.

[Brien Dieterle]

** Or, yeah just listen to Rune.  You had it exactly right just using the wrong action.  I was doing the same thing but I was trying to use a static value in the set fields operation instead of a variable pulled from the matching (duplicate) record.  Can't use a static value.  Nevermind, I've just made things needlessly complicated. Brien On 11/9/2011 4:28 PM, Rune Kristian Sørlid wrote: ** Hi. Try using a set field instead of a push field.  /Rune Sorlid Den 9. nov. 2011 kl. 23:58 skrev Jase Brandon <jasebran...@gmail.com>: ** Hello All, Windows 2008 7.6.04 SP1 I have a field named 'Prefix' on COM:COMPANY. I need to make sure that on submit that the value for 'Prefix' does not already exist. I have two filters - Filter #1 Fires on submit, exec order 0,  the Run IF = 'Prefix' != $NULL$ One If Action - Push Field to COM:COMPANY (same form) IF = $Prefix$ = 'Prefix' Push field action ="" 'zTmpPrefix' = $Prefix$. (I added a char field 'zTmpPrefix') I see this working perfectly in the logs as shown below. I see it find the value "ALT" and do the push fields action without any problem. Filter #2 Fires on Submit, exec order 999. The Run IF = 'ZTmpPrefix' != $NULL$. I also tried 'zTmpPrefix' = $Prefix$ to no avail. This fails and doesn't fire my error message. I know I am missing something horribly simple, but I've spent two hours on this and wanted to reach out to the gang. :-) Please see log below. This is where I got frustrated with the filters and tried with AL's - same result. I've tried using `! on the filters, every trick I know. Any ideas? I'm admittedly tired and wanted to see if someone could help a brother out. :-) Thanks, Jase Brandon <ACTL> Checking ++QTS:COM:COMPANY Customer Prefix is Unique (0) <ACTL>     -> Passed qualification -- perform if actions <ACTL>          0: Push Fields <ACTL>             To Schema COM:Company on Server @ <ACTL>             (536870917) = ALT <ACTL> Checking +QTS:Com:Company Require Customer Type (0) <ACTL>     -> Failed qualification <ACTL> Checking COM:CPY:Company_010_CompanyIndexChk (10) <ACTL>     -> Passed qualification -- perform if actions <ACTL>          0: Set Fields <ACTL>             z1D Char01 (1000000058) = "" <ACTL> Checking COM:CPY:Company_011_CompanyIndexChkMsg (11) <ACTL>     -> Failed qualification <ACTL> Checking ++QTS:COM:COMPANY Customer Prefix is Unique Error (999) <ACTL>     -> Failed qualification _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_