I've got a situation in a results page where I need to say, "If THIS *or* THAT, then do THE OTHER."

I tried putting a Boolean operator into the FMP-IF statement, but it didn't work. Specifically:

[FMP-If:FMP-Field: PHONE.cn.NOT or LISTDATA.cn.N]

Hmmm . . . maybe it should be:

[FMP-If:FMP-Field: PHONE.cn.NOT or FMP-Field: LISTDATA.cn.N]

??

Or maybe I could NEST the IF statements?

Thanks.

--Jeremy

I think you just can make it without Fmp-field:

[FMP-If:PHONE.cn.NOT or LISTDATA.cn.N]

Try

quote:

---

Originally posted by hel_sam:

I think you just can make it without Fmp-field:

[FMP-If:PHONE.cn.NOT or LISTDATA.cn.N]

Try

---

Well, sir, that didn't work, BUT I found that I could NEST IF statements (see below), which accomplished the task!

Thanks for the suggestion.

[FMP-record] [FMP-If: LISTDATA.cn.N] (Your search found an SCS member who has elected not to be listed in the directory.) [FMP-Else] [FMP-If: PHONE.cn.NOT] (Your search found an SCS member who has elected not to be listed in the directory.) [FMP-Else] [FMP-field: FIRSTNAM] [FMP-field: LASTNAM]

[FMP-If:FMP-Field: NAMEB.ncn.*] [FMP-Field: NAMEB]

[/FMP-If] [FMP-If: ADDRA.ncn.*] [FMP-Field: ADDRA] [/FMP-If]

[FMP-If:FMP-Field: ADDRB.ncn.*] [FMP-Field: ADDRB]

[/FMP-If] [FMP-Field: CITZIP] [FMP-Field: COUNTRY]

[FMP-If:FMP-Field: PHONE.ncn.*] Phone: [FMP-Field: PHONE]

[/FMP-If] [FMP-If:FMP-Field: FAX.ncn.*] Fax: [FMP-Field: FAX]

[/FMP-If] [FMP-If:FMP-Field: EMAIL.ncn.*] E-Mail: [FMP-Field: EMAIL]

[/FMP-If] [/FMP-If] [/FMP-If]

[/FMP-record]

I took this tag from the CDML tool. maybe it can help with the nesting and improve speed of the script.

[FMP-If: ClientAddress .eq. *.filemaker.com, *.newton.com, *.next.com, *.apple.com]

Ask about Apple employee discounts.

[/FMP-If]