Reply to FileMaker Search

Creating an Online Form
Creating a Search Form

Creating the Search Response
Return to Manual Table of Contents

Here is the HTML (and CDML) for a simple reply page for a search for "First
Name" and "Last Name". Anything in [square brackets] is CDML.
This is a simple form of programming the form to do what you want it to.

      <HTML>
<HEAD>
  <TITLE>Search Results</TITLE>
</HEAD>

<BODY bgcolor="#FFFFFF">

<CENTER>
<!--Filemaker lets you "include" a file in place of this text
  --For example, in bar.txt there could be a list of links and logo
  --You can read the documentation to find out more-->
 <P>[FMP-include: bar.txt] 
 <H1>Results</H1></P>

<!--If nothing was found, we print everything between--> 
<!--FMP-ifcurrentfoundcount and /FMP-if-->
[FMP-if:currentfoundcount.eq.0] 
  <P><B>No records found.</B> 
  Please change your search criteria and try again. </p>
[/FMP-if] 

<!--This table will hold some important information-->
<P><TABLE width="100%" border="0" align="center">
 <!--This is the first row-->
 <TR>
  <!--Each TD is a column-->
  <TD valign="bottom" width="70%"> 
    <!--FileMaker will insert numbers in place of these CDML tags-->
    <!--Example output: -->
    <!-- "Displaying records 11 thru 20 of 60 records found" -->
    <!-- "(10 records displayed)" -->
    <P>Displaying records [FMP-rangestart]thru [FMP-rangeend] 
    of [FMP-currentfoundcount] records found. 
    ([FMP-rangesize] records displayed).</P>
  </TD>
  <TD valign="bottom" width="30%">
    <!--Filemaker will also automatically link to the next or-->
    <!--previous page if there is more than one page of results!-->
    <P align="right">
      [FMP-linkprevious](Previous)[/FMP-linkprevious] 
      [FMP-linknext](Next)[/FMP-linknext]</div>
  </TD>
 </TR>
</TABLE>

<!--This table will hold the Results-->
<TABLE BORDER="1" CELLSPACING="0" WIDTH="100%">
 <TR> 
  <!--These are the column headers-->
  <TD ALIGN=LEFT VALIGN=BOTTOM width="50%">
    <B><FONT SIZE="-1">Last Name</FONT></B> 
  </TD>
  <TD ALIGN=LEFT VALIGN=BOTTOM width="50%">
    <B><FONT SIZE="-1">First Name</FONT></B>
  </TD>
 </TR>

<!--IMPORTANT!!  What FMP-record does is cause FileMaker to -->
<!--repeat anything between the FMP-record and /FMP-record -->
<!--This lets FileMaker turn this one row into many results -->
[FMP-record] 
 <TR> 
  <TD ALIGN=LEFT VALIGN=TOP width="50%"> 
    [FMP-field: Last Name]
  </TD>
  <TD ALIGN=LEFT VALIGN=TOP width="50%">
    [FMP-field:First Name]
  </TD>
 </TR>
[/FMP-record] 

</TABLE>

<!--now we will create a bottome table to show how the -->
<!--results were sorted and provide the Next/Previous link-->
<TABLE width="100%" border="0">
 <TR> 
  <TD valign="top" width="50%"> 
    [FMP-CurrentSort] Sorted by [FMP-SortFieldItem] 
    [/FMP-CurrentSort] [/FMP-if] 
  </TD>
  <TD valign="top" width="50%"> 
    <P align="right">
    [FMP-linkprevious](Previous)[/FMP-linkprevious] 
    [FMP-linknext](Next)[/FMP-linknext]
  </TD>
 </TR>
</TABLE>

</CENTER>
</BODY>
</HTML>

Filemaker has many powerful features, and this guide has just barely begun to explain them. You can find many more tutorials and sample HTML/CDML in the FileMaker Pro folder on your computer. Specifically, you will want to look into the "Web Tools" and "Web" directories. Good luck!

University of Rochester

Need Help

University IT » Web Services » Help » File Maker » Search Reply

Reply to FileMaker Search