Jump to content

Sort Criteria on Web


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

Recommended Posts

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???

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 8680 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.