Jump to content

Gilbert Osmond

  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Gilbert Osmond

  • Rank

Profile Information

  • Gender
  1. As it turns out, to save time and cost I am just going to update the value list and append a bullet • (option-8) character to the problem words. Then do a 1-time search & replace to update the stored values in each record. That neatly skirts around the problem completely. Updated value list will look like: Dog• Dog house Dog owner Cat• Cat owner Automobile
  2. Witnessing Filemaker Inc's user-opaque development process over the past decade does not incline me towards making any suggestions about adding an operator. But your suggestion to simply loop through the found set and Omit records meeting my criteria works. Noting particularly the addition of a carriage return (option-7) character in the FilterValues. (With apologies for formatting, I don't see how to do clean formatting of code in this forum?) # Go to Record/Request/Page [First] Loop If [FilterValues (Contacts::Category; "Dog¶" ) = "Dog¶" Omit Record End If Go to Record/Request/Page [Next; Exit after last] End Loop
  3. OK, I see your point about my "AND" condition being redundant. That seems incredible to me, that with all of FM's find options, operators, built-in and possibly custom functions, scripts & variables, etc. -- that it is not possible to construct some method of searching a single value-list text field with the criteria: ("Dog House" OR "Dog Owner" ) but NOT ("Dog"). -- and without resorting to hocus-pocus terminating or invisible /special characters. I'll experiment with your suggestions #1 and #2. #3 is not an option, this is a legacy solution.
  4. Let me see if I can clarify: ( "Dog house" OR "Dog owner" ) OR ("Dog house" AND "Dog owner") but NOT "Dog" Means, at the end of my single Find ( or chain of multiple Find requests, or scripted solution, whatever is necessary), My found set of records should include: - Reords that have "Dog House" OR "Dog Owner" checked off in this text field. - Records that have both "Dog House" AND "Dog Owner" checked off in this text field. The same found set shoud NOT include: - Records that have "Dog" checked off, regardless of other checkboxes that may be checked.
  5. This seems like a basic problem but after several hours of googling & reading these forums I can't figure it out. I have a regular text field (indexing turned on) set to display as Checkboxes. The value list for these checkboxes is: Dog Dog house Dog owner Cat Cat owner Automobile As you can see, some words repeat in multiple values, e.g. "Dog" and "Cat". How do I do a Find that will show me: ( "Dog house" OR "Dog owner" ) OR ("Dog house" AND "Dog owner") but NOT "Dog" ? Due to the way Filemaker searches value lists, no matter what I try (different combinations of =, ==, ="" operators, using multi-line find criteria in single find request, different permutations of multiple Find requests), I cannot seem to get the simple result I specify above. I always get records with "Dog" included in the search results, and I can't Omit them using a ==Dog operator because that only applies to records that have ONLY "Dog" in the text field. Using ="Dog", ="Dog " (with a space), etc. etc. also does not work.
  6. This is an FYI / answered-question posted as a service to future searchers who may encounter this issue: I had a problem where FM Pro 13 ( though this would apply to any version of Filemaker on the Mac) would not recognize keyboard modifier keys (option, Shift, command, control) when a Get (ActiveKeyboardModifierKeys) script step was called. I was quite puzzled until I happened across this StackExchange thread on Mac OS X Secure Keyboard Entry. This is an OS-level feature that can prevent any app from receiving the full range of keyboard input from the OS. In my case, 1Password's Safari extension had enabled OS X Secure Keyboard Entry, thus preventing Filemaker Pro from receiving the modifier keys when they were pressed during script activation. To fix the problem I simply quit out of Safari. Note that in your case, the culprit app may be different; any app can invoke Secure Keyboard Entry; typically it's a password-management app but YMMV.
  7. Excuse me, I'm not a math or stats whiz, but these calculations don't ring true for me -- Isn't a the number of possible permutations of a 6-character string (with an alphabet of 30 characters) 30^6 = 729,000,000 -- not 6^30. This makes more sense to me. For example if it was a 2-character string, the number of possible combinations would be 30^2 = 900 --- not 2^30. If my revised math is correct, 729 million is a small subset of the possible MD5 hash space, so I would be smart to check for duplicates before accepting the value. (I currently have ~25,000 photos, but I could see having 1,000,000 photos some day, resulting in the chance of a collision gradually increasing towards more than 1 in 1000. ---Edit-- I tested this with a string output length of 5 characters, and in a set of 4,300 records I got 1 duplicate / collision, a roughly 1 in 10,000 probability. (4300 / 30^5)= .00018. So, I will definitely be using 6 characters starting now, with dupe checking, & structuring for the possibility that the length may need to go to 7+ characters if my library gets very large.
  8. Better safe than sorry. What if the codes are being used in some context outside of Filemaker where there is no automatic checking or substitution. For example, if they are being copied to paper by hand, or searched for in an Excel spreadsheet.
  9. Thank you for your prompt, clear, thorough response. Exactly what I asked for. Reconverting to expand the ASCII set and avoid homoglyphs is a nice touch, too. If you have a bitcoin address I'd be happy to tip you a few dollars for your time!
  10. I have a library of ~25,000 photographs, each in a (linked) container, 1 photo per record. The photos have standardized ID tags of "Site Abbreviation" + "Timestamp". These text tags are unique because photos are never taken less than 1 second apart: 215MAIN-2014-05-02_13-24-52 152JBAR-2013-01-02_02-21-13 152JBAR-2013-01-02_02-21-12 I would like to generate the shortest-possible alphanumeric unique reference code for these photos using a custom function. I plan to embed (watermark) the code into each photo so that someone can easily locate any particular photo in the database by doing a Find on the unique ref. code. My ideal output would look something like a TinyURL, but with fixed length (these are made-up random examples): 215MAIN-2014-05-02_13-24-52 --> F59PL2 215MAIN-2014-05-02_13-21-13 --> RK51JF 152JBAR-2013-01-02_02-21-13 --> S21CW9 Can anyone point me to existing functions that do this, or perhaps give some examples of something that would work? I have investigated available hash functions (SHA / MD5,) these are too long. Adler 16 or 32 CRC is closer to what I want but still too long because it produces only digits. I want to incorporate alphabetics for compactness. Thanks for your help.
  11. 2014-06-19 UPDATE --  I made a new blank file in FMP 13, created a sample radio-button field at 9 point and it works fine / normally. I then copy-pasted the field to my current solution in FMP13 & used the style-clone tool. Despite not seeing any differences in attributes in the Inspector pallette, it fixed the problem.  ---Original post & question ---- I need to use radio button and check box value lists at small font sizes -- 9 points, in some cases even 8 points. At these sizes, FMP 13 Advanced is using a *single pixel* in the center of the selected target to indicate that it is "checked". This is crazy & unusable, yet I need to keep these buttons & checkboxes at a small font size.  Is this a known bug in FMP 13? (Yes, I'm using the latest service release, 13.0v3) Any solutions or work-arounds? I was hoping for maybe a per-field conditional TextStyleAdd which would BOLD *just* the selected item(s) but I don't think this is going to work.  Screenshot from FMP 13 Advanced - 9-point font, Line weight set to 1 point, black:  Compare to:  Screenshot from FMP 11 - 8-point font, Line weight set to 1 point, black:
  12. When I attach a script (i.e. via a Button definition) to a Container field marked non-enterable in Browse/Find mode, the hover style definition now animates & appears as expected. I think I was trying to do something non-sensical, which is ask Filemaker to "hover highlight" an object that doesn't *do* anything. (I.e. to highlight an object that is non-enterable and that has no triggers, buttons, etc. associated with it.) This topic can be moved or deleted as far as I'm concerned. Thanks for your reply.
  13. Request clarification: In FMP Advanced 13, when I set a different style for an object when it is in "hover" state, the style is only applied if the object is *enterable in browse mode.* (To be clear, I am not referring to OnHover script trigger or any other sort of script triggering, just FMP's native "hover" style state.) If "Field Entry" -- Browse Mode check box is not checked (i.e. the field is not enterable,) when I mouse-hover over the object nothing happens. Maybe this is how it's always been and I just didn't know it. It's problematic for me because I want to use a container field (with custom icon stored in it) as a button, and I want the button to "highlight" on hover, but I can only do this if the field is enterable in browse mode, which risks the user accidentally overwriting the icon with randomly-dragged information from elsewhere.
  14. I've had good success with the Seedcode Calendar Pro product from www.seedcode.com. ( There's also a free, completely unlocked version with fewer features that may meet your needs.)
  15. I see your point, yes, he's got some syntax errors & omissions going on there. The key useful part for me was the escaped quotation marks, """, I'd forgotten to add those in my Set Field By Name [ Evaluate ( ) ] script step.
  • Create New...

Important Information

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