Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Slater last won the day on July 14 2014

Slater had the most liked content!

Profile Information

  • Gender
    Not Telling
  • Location
    London UK

Slater's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Thanks Comment, much obliged for your response. Yeah, for the life of me I was trying to make the layout be 'based' in the Pictures Table, but I could only base the layout in a relationship (ie Show Records From: in the layout set up) but I just couldn't get that to work, it was always via a relationship. I realised the GTRR had a direction, and that my script was going in the wrong direction. Because of the wording in the GTRR script saying "Go To Related Record From" I never played with that as it seemed sensible that this was listing the Table that I was going from. Turns out that if I set "Go To Related Record From" to the Table that I would like to go TO, then it works. That was what was throwing me, if it had said "Go To Related Record TO" I would have figured it out immediately!
  2. Solved! Can't see how to delete this post so ... I had thought that "Go To Related Record From" mean the records that you were going From ... turns out it's the records that you're going To! 😳 ✌️ 🥳 Hi Everyone, Hope you can help as I've been banging my head against this one for over an hour, and I just can't figure it out! (I'm on FMP 16) I have two tables: People & Pictures They're related by a relationship called People_Pics_Relationship, and in that People::ID_Person = Pictures::ID_Person I have a layout called "Pics" based on this relationship People_Pics_Relationship, filled with fields the Pictures Table, and a script that says: Go To Related Records: related record from: Pics, show only related records, match all in current found set. So when I run that script in a layout based on the People Table, it takes me to all the related records from Pictures Table, but when I run that script in a layout based on the Pictures Table, nothing happens. It's like it will go in the direction that I don't want, but won't go in the direction that I do want! Can someone help point out what I'm doing wrong, as I guess it's something really simple, but I just can't figure it out! I'm guessing that the layout is based in the People Table somehow, rather than the Pictures Table, but I can't figure out how to switch things around. Many thanks
  3. Hi Guys, thanks so much for getting back to me and apologies for my delay. So, the problem is not so much that it runs slowly on her machine, but that after a time it kinda grinds to a halt. That could be after as little as 5 mins, or as long as an hour or two. But before that happens, it's all going along nicely enough. And that delay in it slowing down to a halt, leads me to think that the load on the host machine (my Mac) isn't the culprit, because the system can be scooting along nicely for a couple of hours. Typically, if she's going from one record to another in a found set, then her computer can hang for even a couple of minutes, while most of the time to do so would normally take a second. One strange thing that is visible when this happens is that there are a succession of pop up dialog boxes, but off the top of my head I can't remember what they say. I'll take some screen grabs next time (though I'll not be at my desk computer for the rest of the week, but I'll post a grab once it happens again). Undoubtably, the DB could have been written better - it's grown over many years and has quite a few oddities in its methods, but I don't think that that is the culprit because otherwise it should be a constant problem. When the slow down occurs, sometimes just restarting her FM can solve the problem, though sometimes it takes me to restart my FM, but even sometimes we both need to restart the computers. Is FM Server a separate app? As a solution, I could perhaps host the DB when she's with me using FMP, and then if I'm away I could host the DB with FM Server? If FMS didn't solve the problem, would that point to a network issue? Both of my Macs are up to date and attached to a switch (un-managed) and then the switch is attached to an Netgear Orbi router. The router is new as I thought that my old Apple airports could be to blame, so I changed them out for the Netgear system. Though I am running FMP16, which could be the problem. As I need to buy the app for 3 seats, as a sole trader the cost is very high, and so I'd like to wait for the release of FMP19 to upgrade my FM copies. Thanks for any of your thoughts!
  4. Hi Everyone, Looking for a bit of advice - I'm using FMP16 on two computers here at my place. I host the DB and then a person who comes in to work for me uses Open Remote to access the DB on the computer that she's working on (my second computer, both Macs). I've had no end of problems with this - the DB is very slow on her computer. I've worked around that a number of ways, but each one falls down sooner or later. Anyway - the issue is that she needs to be in here this week, while I'm not able to be here. The last time this happened, the DB ground to a complete halt, everything was so incredibly slow, that I paid her for a half day of doing nothing, essentially. (She couldn't get into my computer to restart and then host the DB on FMP.) In terms of what I could do while she's here and I'm not, * I could just put a copy of the DB on her computer, but then she'd be able to copy it, say to a USB. I don't think she would, but as it has very important personal info on it, I'd like that not to be a possibility. Also, her user is locked out of those parts of the DB, but none the less, that's something that I'd like to not be possible. * If it were windows, I believe it's possible to set a folder so that it can't be copied. And so I'm out of ideas! Is there any advice anyone can give me on 1. allowing her to access the DB, while 2. her not being in a position to copy the DB, and 3. me not hosting the files on my computer? Many thanks for any help! Cheers
  5. Hi Everyone, So here's one that's either really easy and I've missed it, or it can't be done! I'm printing address labels, and the 7 rows that I'd like to print take up the whole label layout, and so the first one is located at the top of the label in the layout, and the bottom one is at the bottom of the layout. If the label only has 4 rows, then those 4 rows are printed at the very top of the label. To make things pretty, I'd like to have them centered within the label. Is it possible to have the block of text center itself, so that there is the same amount of blank space both above and below it, rather than having all of the space below it? Many thanks in advance!
  6. Thanks Comment, as ever! Apologies for my late reply, I've been tied up with something. That's such a cool way to go about it. I think I could create three outputs, 3x2, 2x3 and 1x1, and then just standardise all containers so that they're one of those three. Thanks for helping me figure this, cheers
  7. Also, just FYI there are some problems with this if the images are different sizes. GetThumbnail only returns a consistently sized thumbnail when the originals are the same size. So if your library of images are different sizes, then you will need to plug in different values to the GetThumbnail function. The toss up being that this will only work seamlessly if all of you images are exactly the same size. (It's better than the default situation though, so I'm not complaining!)
  8. Thanks Comment and thanks Fitch. Great idea to check out plug ins. I've had a quick look. Also, really cool of you to have got back to me Fitch. I've had a play with this, and this won't work if the original picture is smaller than the container. In that case, it seems to me, GetThumbnail won't work, which is why it didn't seem to be working for me, when I checked it out. The particular layout that I was using meant that it didn't appear to be working. But if the original is larger, then it does!! Yay, thanks Fitch, that seems to do the job ... now to resize all the originals that are too small 😳🤓
  9. Thanks Comment. It's a portal where each person has a portal row, so I have to keep it in FM. And in some layouts the best shape for the container is tall, and in some other layouts it's wide ... and I guess I can't have Fill as things stand. I've been researching it a bit, and here's an old post that sums it up very well. It can be done for a graphic fill, but not a container https://community.filemaker.com/en/s/idea/0870H000000fyddQAA It's from 3 years ago, and so whilst I think it's the most sensible thing in the world, and something that it's crazy not to have, I guess Filemaker don't think the same way! It's one of those ones where I think everyone must have the same issue, but I guess not. I'll try to let it go 🤯 Here's another one post where someone from FM seems to be saying that it can't happen: https://community.filemaker.com/en/s/question/0D50H00006ti3ctSAA/how-do-i-change-how-an-image-displays-in-a-container-field I wish I could think of a workaround, but because I have the need for a taller container sometimes, and a wider container other times, I guess not 😱
  10. Thanks but sadly that doesn't work. The function just resizes the image with the same proportions, so it effectively changes the pixel count but no the aspect ratio. And so because of this, when I show that thumb in the layout, I have the same problems as before
  11. Hi All, Apologies for perhaps being in the wrong part fo the forums for this query! I'm on FMP16 right now, and I've a container field that I use to display square pictures of people. Due to different layouts, the container is landscape on one, and portrait on another (ie wider on one, and taller on another). Because the only option in FMP 16 is to FIT the image, when the container is wider than tall, either the image is distorted or there are gaps on the sides, depending on whether I've got the 'maintain proportions' box checked or not. And similarly, when the container is taller, then the image is either distorted or there are gaps on the top and bottom. What I'm after is being able to FILL the container, so that whilst I loose a bit of the image on the sides or tops, the container is filled without distortion. Is this possible with FMP 18? (If there's a work around for FMP 16 I'd love to know it, but I don't think there is!!) Many thanks in advance
  12. Of course! Neat work around! Thanks so much, it's much appreciated
  13. Hi All, I'm guessing it's not possible, but I'm hoping it is none the less! I would like to conditionally format the colour of an entire portal row on a value from within that row. For example, I'd like all records with Field = "Yes" to be pink, instead of the default grey background for the portal. Is that something that can be done in FMP 16? Many thanks
  14. Thanks Comment, much appreciated that you responded! What I might do instead is take your advice, but do that in a dummy DB, export the total data to a csv and then import that into my real DB. Cheers
  15. Hi Everyone, I'd greatly appreciate your help - I've got 2 excel files that I want to import into my DB. When I import the data into FM, I would like FM to add the figures together rather than overwrite them. For example: on file1.xlsx Dave = 6 on file2.xlsx Dave = 4 I would like to import both files, and to end up with Dave = 10, but all i can do is get FM to overwrite the data, so that I get either 6 or 4. Is this possible? Many thanks,
  • Create New...

Important Information

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