This topic is 1820 days old. Please don't post here. Open a new topic instead.
Basic question.... Where do I find help on partial word searches? I've been ...searching.... for a good writeup on FMP search operators that cover this to little avail.
I need a expression that will search, get to a character, and then ignore/wildcard from there.
So a search on "Chicago" will return:
Chicago Chicago-IL Chicago-001 and so forth.....
I have a form in which users make measurements of multiple parts, then input the max and min measurements. I then have conditional formatting that compares these maxes and mins to the hard mins and maxes for that part. If the inputted max is larger than the hard max, or the inputted min is smaller than the hard min; the conditional formatting is supposed to highlight that measurement in red. This has worked in almost every case I have tested so far, except for one strange case. I have a hard min of 9.8, and my user is attempting to input 10 as the min. FileMaker is highlighting this in red, even though 10 is larger than 9.8. When we change it 9.9 it isn't red, but 10.1 makes it red as well. I have no idea why this is happening, so any assistance in this matter will be greatly appreciated!
Who Viewed the Topic