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.

multipule finds

rivet
in Other Internet Technologies

Featured Replies

I can do a search on a user id, but can I do a search on multiplule id's at once?

Same with dates.

hi there!

depends on you what kind of a serach u need...I saw a post here by mr. Knight (fmwebschools guy-sorry if I misspelled the name) who posted "submit mupltuple foms"

:: _old post_ ::

all the best!

You can use "-lop=or", then:

&myfield="value1 value2 value3 etc"&-find

OR

&myfield="value1"&myfield="value2"&myfield="value3"&-find

Hope this helps.

Garry

  • Author

wow that is nice... can it be pushed further?

I would like both id's with the same date

...&-lop=or&_id=40&_id=80&datestart=06/05/2003&-find

The major drawback is that you only have one "-lop" frown.gif

So it is either "OR" or "AND" for all fields. This is a real problem with CDML.

I have had to use [FMP-IF] statements to perform combined "OR" and "AND" searches.

Somebody may have a better method.

Good Luck.

Garry

  • Author

how about this,

The is an actual field that has the two merged.

id&date

so is there away to get the submitted fields to string together and then do a request the on the merge field?

maybe if I set them to tokens and then request [token1][token2]

what do you think?

Theoretically, you could build a "concatenated" field, of ID & " " DateToText(Date), result text, in FileMaker.

Then, on your web page(s), put your 3 input fields together with JavaScript, write to the <input> tag for the concatenated field, then submit. It would only be 2 requests, with an "or" operator.

Actually the above would have to happen on a meta-refresh page. The regular page would do a -Find for the IDs & the Dates (or operator). The Find would be sure to succeed, if any of them matched. But you'd only be using the Find to get the Find criteria, by setting into Tokens (with JavaScript) or by retrieving on the meta page with Find criteria tags, then submit the 2nd Find with the concatenated criteria.

You can go to your FileMaker database and run Modify Last Find to see what ended up as the Find.

I would have to experiment to get even close however. As I said, theoretical. I did something like this once and it worked, but it had fewer criteria. Anyone get any closer?

This is how you could setup the Form:

<form name="findfm" action="FMPro" method="POST" onsubmit="Javascript:setfields();return false;">

Enter Date: <input type="text" name="" value="">

Enter ID: <input type="text" name="" value="">

Enter ID: <input type="text" name="" value="">

.

.

<input type="hidden" name="combofield" value="">

<input type="hidden" name="-lop" value="or">

<input type="hidden" name="-db" .......

.

<input type="button" value="Find Records" onclick="Javascript:setfields();">

</form>

This is how the Javascript could look in the <head> tags:

<script>

function setfields()

{

with (document.findfm)

{

combofield.value = elements[1].value + elements[0].value ;

if (elements[2].value != "")

{

combofield.value += " " + elements[2].value + elements[0].value ;

}

submit() ;

}

}

</script>

Hope this is of help. All the best.

Garry

  • Author

looks interesting (scarry crazy.gif) I will try it - much thanks everyone

just a side note on merged fields:

look at this

405077

now can u tell what two IDs I have typed? smile.gif

was it 405 and 77?

was it 4050 77?

u get the idea...joined them with a "," or something that seprates them

consider this when searching through the filed.

I would go with Gary's idea of JavaScripts and passing variables...perhaps build the URL as u wrote it...

anyhow,

all the best!

Create an account or sign in to comment

https://fmforums.com/topic/16578-multipule-finds/
Go to topic listing

Important Information

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

I accept

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.