Dera All,

I have created an web database using filemaker and Claris HomePage for the user interface. I have loads of fields in each record, but 6 fields are setup as repeating fields (max 10 times).

Is there a way I can have the fields on my web interface to do the same?

Thanks

BW

This is copied from the CDML Reference Guide:

[FMP-Repeating]

Repeats the HTML between [FMP-Repeating] and [/FMP-Repeating] for all the repetitions of the specified field. The tag [FMP-RepeatingItem] is replaced with the contents of a specific repetition.

Repeating fields within portals are not supported. The number of repetitions displayed in a repeating field is controlled by the layout specified in the -Lay tag.

Syntax

[FMP-Repeating: Field Name ]

Parameter(s)

First parameter: Name of the repeating field.

Syntax example(s)

Display a repeating field using an HTML file

[FMP-Repeating: Extensions]

Alternate phone extensions: [FMP-RepeatingItem]<br>

[/FMP-Repeating]

Hi, repeating fields can be difficult to use with a web interface, especially when you need to edit them as check boxes etc. Inputting to them and displaying as read-only or text fields is OK, but you might save a lot of grief later on if you use portals for this info.

regards, jeff

Thanks People,

I've tried it and it works. But I would like the data to be listed vertical, at the moment the data is displayed horizontaly. Any ideas?

What are portals Jeff?

Thanks

Hi, if your repeating field is in one line, then I think all you need to do is put in a line break after the repeatingitem' tag, like:

<P>[FMP-REPEATING: fieldname]

[FMP-REPEATINGITEM: HTML]<BR>

[/FMP-REPEATING]</P>

...or maybe put the item into a table, like with a search return:

<P>[FMP-REPEATING: fieldname]

<TABLE BORDER=0 CELLSPACING=0 WIDTH=200>

<TR>

<TD>

<P>[FMP-REPEATINGITEM: HTML]</P>

</TD>

</TR>

</TABLE>

[/FMP-REPEATING]</P>

The problem with web repeating fields comes when you want to edit them.

Portals? Use them n the web, just like you would use them in the database client to make a list of related records, so you'd have the repeating data in a separate database with a relationship link and display it like:

<P>[FMP-PORTAL: relationshipname]

<TABLE BORDER=0 CELLSPACING=0 WIDTH=347 HEIGHT=72>

<TR>

<TD>

<P><A HREF="directorypath/FMPro?-db=thedatabase&-format=record_detail.htm&-error=search_error.htm&-lay=web&-op=eq&recordkey=[FMP-field:relationshipname::recordkey]&-find">[FMP-FIELD: relationshipname::title]</A><BR>

[FMP-FIELD: therelationship::description]</P>

</TD>

</TR>

</TABLE>

[/FMP-PORTAL]</P>

This is a really useful tool for web publishing!

regards, jeff

Cheers Jeff,

The break one works ok but it displays all the string (<P>, <BR> etc.) as well as the data. Do you know how to stop these being displayed?

Thanks

BW

Hi, if there's a tag showing as text I find that it's usually because there's an extra one in the html somewhere. Could this be?

regards, jeff

Re: displays all the string (<P>, <BR> etc.)

Maybe it is enclosed within <p> tags; e.g.:

<P>[FMP-PORTAL: relationshipname]

<TABLE BORDER=0 CELLSPACING=0 WIDTH=347 HEIGHT=72>

Good Luck.

Garry

Hi Chaps,

I've edited the HTML code and removed the blue <p> tages. But no joy the tags are still showing

Thanks

BW

Hi, dunno what's happening. I copied and pasted my whole mail from above straight into a blank html page and no tags showed. Could you maybe post your code here?

regards, jeff