Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

as I can use the function " RANGE" (. . . ) in the

Featured Replies

  • Newbies

as I can use the function " RANGE" (. . . ) in the web?

Excuse for the grammar, I am translating that message with electronic translator

[email protected]

I am using that without problem.

To check what was passed to FileMaker use Ctrl-R for last Find Request.

Let's say you have a field "cost" in which you want to find a range. This example provides part of the Form Action code which uses two valuelists to allow the client to determine the range to be used with a -find action.

Low&nbsp;&nbsp;<select name="cost">

<option value="5"> $5.00

<option value="10"> $10.00

<option value="15"> $15.00

<option value="20"> $20.00

<option value="25"> $25.00

<option value="30"> $30.00

</select>&nbsp;&nbsp;

<input type="hidden" name="cost" value="...">

High&nbsp;&nbsp;<select name="cost">

<option value="5"> $5.00

<option value="10"> $10.00

<option value="15"> $15.00

<option value="20"> $20.00

<option value="25"> $25.00

<option value="30"> $30.00

</select>

To expand on what Unable has given:


<input type="hidden" name="-op" value="gt">

<select name="cost">

<option value="5"> $5.00

<option value="10"> $10.00

<option value="15"> $15.00

<option value="20"> $20.00

<option value="25"> $25.00

<option value="30"> $30.00

</select>

<input type="hidden" name="-op" value="lt">

<select name="cost">

<option value="5"> $5.00

<option value="10"> $10.00

<option value="15"> $15.00

<option value="20"> $20.00

<option value="25"> $25.00

<option value="30"> $30.00

</select>

Hope this helps.

Garry

  • Author
  • Newbies

I am trying to use the examples but it is not working, it doesn't locate registration none among dates, for instance 2001/02/01... 2001/05/25.

Some idea?

See the code below:

<INPUT TYPE="hidden" NAME="-db" VALUE="euroscut.fp5">

<INPUT TYPE="hidden" NAME="-Lay" VALUE="web">

<INPUT TYPE="hidden" NAME="-format" VALUE="Resposta_de_Pesquisa.html">

<INPUT TYPE="hidden" NAME="-error" VALUE="Resposta_de_Pesquisa.html">

<input type="hidden" name="data" value="[fmp-field:data1]

<input type="hidden" name="data" value="...">

<input type="hidden" name="data" value="[fmp-field:data2]

Translated with electronic translator

Osmair

It may be the way the date is formatted. What you can do is perform the find from the browser and then go to the db and manually perform a "Modify Last Find". Doing this will reveal to you what has been entered into the field ("data") upon which the search is being performed. You may find that the format of the date has been changed. If so, you may need to create a calculation field which will format the date in a manner acceptable to the web/Filemaker and perform the find upon that field. If you need to use a calc field, be sure to set it to "unstored" for web use.

Try this:

 <INPUT TYPE="hidden" NAME="-db" VALUE="euroscut.fp5">

<INPUT TYPE="hidden" NAME="-Lay" VALUE="web">

<INPUT TYPE="hidden" NAME="-format" VALUE="Resposta_de_Pesquisa.html">

<INPUT TYPE="hidden" NAME="-error" VALUE="Resposta_de_Pesquisa.html">

<input type="hidden" name="-op" value="gt">

Start Date:<input type="text" name="data" value="">

<input type="hidden" name="-op" value="lt">

End Date:<input type="text" name="data" value="">

Try formating the date various ways; e.g. "02/01/2002", "01/02/2002" etc.

Good Luck.

Garry

  • Author
  • Newbies

Thank you, it was that that wanted. he/she/you was trying with just a field with the value 01/01/2001 ...01/03/2001, where he/she was giving mistake but the code above worked.

Thank you

Translated with electronic translator.

Osmair

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.