Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Slater last won the day on July 14 2014

Slater had the most liked content!

Community Reputation

1 Neutral

About Slater

  • Rank

Profile Information

  • Gender
    Not Telling
  • Location
    London UK
  1. Of course! Neat work around! Thanks so much, it's much appreciated
  2. 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
  3. 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
  4. 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,
  5. Worked a treat - many thanks for your imagination and help!
  6. What a great suggestion - thank you so much. I'll be able to try it tomorrow. Best wishes
  7. Hi All, I've got two records. The parent record has a 1 to many relationship with the child. The parent is for clients The child is for people I want to only allow someone access to the parent records, when there is at least one child records which has Are_They_Green = "Yes" So if any of the client's people are green, then access will be allowed to the parent. I'm using a calculation within the privilege set, view limited: Are_They_Green = "Yes" The problem that i've got, it seems to me, is that i'm only getting one or a couple of layers down in the portal. How can i calculate it to show that there is at least one occurrence of Are_They_Green = "Yes" (assuming this is the best way to go). Thanks for any help - been searching but to no avail!
  8. The question that i'd like answered is why do they care so little
  9. Hi Guys, Just an update - i've been corresponding with a different man from filemaker, and though it seemed to me that this issue took them by surprise, their final thought is: "the software is designed to hold individual files [and] its not a bug that it cannot, so we cant raise this internally as an issue to be addressed" Personally, i strikes me as crazy. But that's not going to change anything! In the end i didn't delete iWork14 as a work around, but i have taken to saving all my files as Word and Excel documents instead! Crazy! Thanks for your help though, much appreciated
  10. Hi Guys, Thanks for taking the time to reply. I think i'm right in saying that Filemaker is owned by Apple? (Their website says that they're an Apple subsidiary.) It seems odd, if that's the case, that you can't put Apple's iWork files into Filemaker's container fields. After all, container fields are there to hold files, plus i would expect that the child company's product to work with the parent company's products. As Comment said, the current iWork files are packages dressed up as files, whilst the previous version's (iWork 09) files are multiple files zipped into one, and therefore acceptable within the container. So while i agree with you Lee, that the problem comes from the iWorks' file formats, i would want Filemaker to somehow produce a solution so that things can carry on as per usual. But apologies for not being clearer Lee, i wasn't trying to import or export the files, but just to have an easy way of keeping tabs on external files' locations, and then being able to open them easily with a double click from within Filemaker. I should have phoned back, but i was so dispirited by the person's approach. They wouldn't help me, but merely kept saying that it wasnt their job to show me how to develop a solution, whilst i kept saying that i wasn't after a solution, but after knowing whether it was possible or not. (If it was, i'd try to figure out how on my own, and if it wasn't, i'd give up trying.) The guy from Apple was great though, and whilst he couldn't help me on the Filemaker side of things (which i wasn't asking him about) we were able to together figure out a few work arounds. Sadly, none of them really worked (sorry to digress) mainly because it was impossible for me to assign .pages or .numbers files to be automatically opened in iWork 09, either by file>info>openwith, or file>info>openwith>change all - they were always opened by iWork14. On opening in iWork14, the files would automatically be converted to '14 files, it was impossible to work with them as '09 files from within iWork14, and next the export of files as iWork09 was convoluted! (it just works, i don't think so!) So it seemed that the easiest thing was just to delete iWork14, leaving only iWork09, and have everything work easily and painlessly. I've done a wee bit of Apple scripting in the past, and had thought about it for this purpose, but the 2 seconds it took to delete iWork14 won out, over what would have been much longer with tonnes of head scratching. Phew, this is turning into a confessional - apologies for its length and tedium!! Thanks for the suggestion. I went to their site and read "The BaseElements plugin has functions for file manipulation, dialogs, XSLT operations, clipboard manipulation, performing shell scripts and FileMaker scripts, internal SQL operations, MD5 and SHA hashing and more." and that kinda scared me! So for now, i'll stick to the deletion of iWork14, after all i can get it easily again from the App store. I'm just hoping that when the new computer that i ordered today shows up, i can somehow get iWork09 onto it! Cheers, thanks again guys, it's much appreciated, Slater
  11. Thanks Comment, kind of you to write - and very helpful to me!! I've spoken to Filemaker (really unhelpful and grumpy) and Apple (kind and helpful) and it appears that there's no sensible work around - which strikes me as strange because they're part of the same company, and you would have thought that someone would expect you to use iWork and Filemaker at the same time! The iWork 14 files are packages as you say, and iWork 09 files are zips. The only way i can sort this out for me, is to delete iWork14 from my mac!! Crazy but true! Thanks again
  12. Hi Everyone, When trying to insert the new Pages 5.2 or Numbers 3.2 files into FMP 13, i get the error "This file cannon be inserted because it contains other files inside it". I'm guessing no one else has this problem because i can't find any topics on it, so it seems like i'm the only one! The container that it i'm trying to put these files into is a regular container field ... Ican't figure out what i'm doing wrong! Does anyone have any suggestions Cheers!
  13. Hi, no, 10.9.3 doesn't fix it. Though i've got FMP 12 and 13 running on 10.9.3, and webdings works on 12 but no 13, so i'd say it's a FMP thing. They have a 'workaround' for it, but it seems pretty lame to me if you're using webdings in layouts for arrows etc ... http://help.filemaker.com/app/answers/detail/a_id/13130
  14. Hi Comment, Many thanks for that - i had been trying earlier this morning with your file, to get the open folder button to work, but it doesn't work on my system for some reason, which was partly why i've gone this route because i couldn't figure out why! To get it to work automatically, i added a part to the substitution line of the script ["Users:***:"; ""] which took out the problem text, and made it work! Yay!!
  15. Actually, this is not the case, as i've found a file with a space in it, that does work. The error when it doesn't work is Finder got an error: Can’t make "***:Users:***:Documents:Admin:***:*** ***.pages" into type item. And it's the Users:***: part that messes things up - when i relink the file, this part isn't included anymore, and the script then works! So ... now do i do all 400 of these files by hand, hmm!
  • Create New...

Important Information

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