How can I hard code in the sort fields in CDML page?

[mcarey]

I have a CDML page where I would like to hard code the values in a sort list on web page. Right now the cdml code is pulling all the fields in the database.

Does anyone now how to limit the dynamic value list that will let the user pick a field to sort on in the database....I want to limit the field names in the drop down menu sort list.

THis is what I currently have.

<select name=&quot;-SortField&quot;>
<option value=&quot;&quot;>-None-
[FMP-LayoutFields]
<option>[FMP-FieldName: Raw]
[/FMP-LayoutFields]
I have tried limiting the fields avialable on the current layout but I still get all the fields in the database.

Thanks!

 

[billholmes]

Make a layout with only the fields you want displayed and reference it in your FileMaker CDML form header: <INPUT TYPE=&quot;hidden&quot; NAME=&quot;-Lay&quot; VALUE=&quot;List&quot;>

I'm having the opposite problem since migrating from FMP4 to 5 and 5.5:

bholmes@omnigon.com
Sharing/Web Companion: List and Form layouts properly identified. Sort &quot;User specifies sorting by specfied fields on browser.&quot;

HTML file includes FMP4 CDML popup to list all fields in layout for sort selection, but entire list is not displayed. In one case only the first field is displayed. In another only the last eight fields are displayed by FMP5 or 5.5:

<select name=&quot;-SortField&quot;>
<option value=&quot;&quot;>-None-
[FMP-LayoutFields]
<option>[FMP-FieldName: Raw]
[/FMP-LayoutFields]
</select>