Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Repeated fields in a web database


bwill2000

This topic is 7858 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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]

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7858 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.