Sort Criteria on Web

[tgomez]

I want my users to be able to sort specific fields on the web of my database. I am using FMPro 4.1. When I converted my db to the web w/Claris HomePage and said yes I want the user to determine the sort order it gives all of the fields in the database to sort with. But I only want them to be able to sort w/3 out of the 5 fields. I can I specify only those fields?

ANY HELP???

[jwtidwell]

Okay here's the problem...and I think your solution. Here is the CDML that Home Page should be creating now:

<select name="-SortField">

<option value="">-None- [FMP-LayoutFields]

<option>[FMP-FieldName: Raw] [/FMP-LayoutFields]

</select>

You need to change the CDML to read something like this:

<select name="-SortField">

<option value="">-None-

<option>Field 1

<option>Field 2

<option>Field 3

</select>

The CDML that HomePage is creating is taking all the Field names on the layout ([FMP-LayoutFields] substitutes with the field names on the layout) and then creates a Value List . You need to substitute just the field names you want into the CDML whether that is one or all of the fields. Basically you are just doing manually, what FileMaker does automatically. Hope that this helps.

Jeff