Repeated fields in a web database

[bwill2000]

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

[Pupiweb]

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]

[Jeff Spall]

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

[bwill2000]

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

[Jeff Spall]

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

[bwill2000]

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

[Jeff Spall]

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

[Garry Claridge]

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

[bwill2000]

Hi Chaps,

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

Thanks

BW

[Jeff Spall]

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