FMP-If

[Justin Grewe]

[FMP-If: Field: EvalrespondQuestionID::AnswerStatus.[FMP-Field: NumPortalEntries] .eq. 0]

I have tried this and I think my syntax is wrong. Does CDML allow a [FMP-Field] inside a if statement after the field name?

Thanks,

Justin Grewe

[Garry Claridge]

Try:

[FMP-If: Field: EvalrespondQuestionID::AnswerStatus.{Field: NumPortalEntries} .eq. 0]

Good Luck

Garry

[Jeff Spall]

Hi, I think the extra "." might confuse this.

I think FileMaker treats the first full point as the end of the left-side value, then wants an operator, then treats everything between the second full point and the bracket as the second value.

I'm not quite sure what this function asks - should EvalrespondQuestionID::AnswerStatus

and

NumPortalEntries

equal 0 for it to be true??

regards, jeff

[Justin Grewe]

No, I am using a portal and so the NumPortalEntries is the amount of portal entries. I want the webpage to edit the last portal row with the AnswerStatus field. So if that equals 0 then I want it to do something.

Thanks,

Justin

[Justin Grewe]

Nope, the [FMP-If: Field: EvalrespondQuestionID::AnswerStatus.{Field: NumPortalEntries} .eq. 0] that you said Garry does not work. I have also tried

[FMP-If: Field: EvalrespondQuestionID::AnswerStatus.{FMP-Field: NumPortalEntries} .eq. 0]

and

[FMP-If: {Field: EvalrespondQuestionID::AnswerStatus.[FMP-Field: NumPortalEntries]} .eq. 0]

and many other variations. It seems that maybe what Jeff said was right or that CDML does not allow [FMP-anything [FMP-anything] ] so does anyone know how I would get around this?

Thanks.

Justin Grewe

[Jeff Spall]

Hi, dunno if this is any help, it changes a value in the last portal row:

[FMP-PORTAL: relationship]

<TABLE BORDER=1>

<TR>

<TD>

<P>[FMP-FIELD: relationship::theName]</P>

</TD>

<TD>

<P>[FMP-IF: CurrentPortalRowNumber.eq.field:counter]

--do somthing to the last row--[FMP-ELSE]

[FMP-FIELD: relationship::aField]

[/FMP-IF]</P>

</TD>

</TR>

</TABLE>

[/FMP-PORTAL]

-------------------------------------------------------------

the field "counter" is a count of a field in the portal so that we can get a value for the last row.

regards, jeff