We updated the server the past two days, you should see some speed performance of our site.

Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


MikeKD last won the day on January 11 2015

MikeKD had the most liked content!

Community Reputation

7 Neutral

About MikeKD

  • Rank
  • Birthday 10/08/1967

Profile Information

  • Gender
  • Location
    Kent, UK

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

6,878 profile views
  1. Find multiple words in Value List

    Thanks guys! I'll try to have a go at it today and see how it works - I think it's the New Record / Request step I've not used in that way before that I'll have to research a bit first.. Best wishes, Mike
  2. Find multiple words in Value List

    I've now split the one variable into three; one for each word using the middle words function. Is there are way to Find OR in Specify Find Requests - there seems to be no option other than AND; and no way of bracketing Find Requests. Apologies for the questions; I've always had to use trial and error with Edit Find Requests before, and at the moment, it's mainly error despite going through the books & searching the forum.. Cheers! Mike
  3. Find multiple words in Value List

    Thanks for the quick replies. I've attached the script below. Each record has a Term field which is set to either Autumn, Spring or Summer. I've set a global checklist to select any one, two or three of them. It looks like it's searching for a field with both / all three words when more than one is selected in the global. Hope that helps clarify a little! ScriptImage.bmp
  4. Hi Folks, I hope you're all well. I'm trying to use a Find step in a script, to find multiple words from a Global field checkbox in a field in the same table. It works fine when just one word is selected, but fails when two or more are. I've tried different operators, but = and == don't work either. Is it possible to get this kind of thing to work, or is it only do-able in related tables? ------------------------- hmmm, having asked the question, I suppose I could separate the list into it's different words, give each a variable and Find for each variable. There are only three possible words so a max of three variables to set. Can't remember the text function off the top of my head, but pretty sure it's possible. Is there a sleeker way? Best wishes! Mike
  5. Looking closer now! In a bit of a rush now - try putting the time taken box below a blank box with both set to slide up & select the "objects above" option. Unless, there's another object out of sight that's not set to slide up" Sorry - I'm not an expert at this - tends to be a bit trial & error for me too! (I take it the last screen shot is from a preview btw?) Good luck!
  6. In your screenshot - there is no up arrow to indicate that you've set the fields to slide up. That option is in the inspector under Sliding and Invisibility. - Did you try it and find it didn't work? Also, they are all currently aligned top rather than bottom. To get the format you want, my first call would be to: 1. Set Activity, time_taken and Charge text boxes to all slide up. (probably also ticking the options for all items above and also resize part.) 2. Bottom align time_taken. Good luck!
  7. I don't do these often, so you'll hopefully get better ideas, but I'd make the Units and Unit boxes the same height as the activity box, align bottom and set them both to slide up (which looks to be the trick you've missed out). But - it would look messy if the units boxes stayed blue... Cheers, Mike
  8. Adding info after Importing New Records

    That's ace - so I don't have to bother working out how to find the recently imported records - for once things are easier than I expected! Thanks guys
  9. HI folks, I've got an import new records script I'm working on. After I've created new records (based on Excel rows) are they always left in the found set? As far as I can tell that's the case, but don't want to rely on it! After the import I'd like to then set a couple of fields based on variables, and can't see another way to find the records that have just been imported to do that. Cheers, Mike
  10. Filtered Portal

    Well this works, pretty much I think.. If anyone can see some improvements, I'd be glad to hear them! Case ( not IsEmpty (Resources::PickWork) ; Resources::PickWork = Piece_forResourcesMenu::WorkID ; IsEmpty (Resources::PickWork) ; ( (IsEmpty ( Resources::gSearchPieceTitle ) or PatternCount ( Piece_forResourcesMenu::Piece Title ; Resources::gSearchPieceTitle )) and (IsEmpty ( Resources::gSearchPieceComposer ) or PatternCount ( Piece_forResourcesMenu::cComposers ; Piece_forResourcesMenu::gComposerSelect )) ) )
  11. Filtered Portal

    Ah, I think I've got it - I'll use Case, testing for PickWork being empty or not. Will have a go when I get the chance... Cheers! Mike
  12. Filtered Portal

    Hi Folks, I can't quite get my head around this one.. I have a portal that contains basic info about pieces of music. Each piece is either a work or a movement. (pieces are either self contained or consist of movements). I'm using 2 globals and 1 local field to filter down the list of pieces: 1. Composer 2. Title 3. Work ID This works almost as I'd like: ( ( IsEmpty ( Resources::gSearchPieceTitle ) or PatternCount ( Piece_forResourcesMenu::Piece Title ; Resources::gSearchPieceTitle ) ) and ( IsEmpty ( Resources::gSearchPieceComposer ) or PatternCount ( Piece_forResourcesMenu::cComposers ; Piece_forResourcesMenu::gComposerSelect ) ) ) OR Resources::PickWork = Piece_forResourcesMenu::pkPieceID The issue is that, if the last field (Resources::PickWork) finds matches, I don't want to see any of the others. I suspect that it's possible, but can't work out how to do it... Best wishes, Mike
  13. I've just had a quick google of it. I think it needs rather more than a quick google! I think I probably need to learn how to use one tool at a time at the moment!!
  14. mmm, *******, good point! I'm showing my incompetence again.. My guess is that I should be looking at a calculation (or summary?) field listing either found or related records? Once we've got the files text content correct, are there different methods for windows and Mac to set the filetype to .doc? Or is that part of the text content? As always - huge thanks for the help you give to those of us learning the ropes comment :-)

Important Information

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