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 I
  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 combinatio
  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 S
  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
  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
  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 th
  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 cont
  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.