Jump to content


  • Posts

  • Joined

  • Last visited

mga's Achievements


Apprentice (3/14)

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

Recent Badges



  1. I can't get that to work. The calculation result (which is set to container) gives a text string with the path, rather than displaying the picture.
  2. Hi, I've got a database containing about 400 staff in my organisation. I'd like to have the facility to select a name from a pull-down menu, and have a picture of the person appear (I expect in a container field) on the layout. The solution must work on Mac and Windows. An obvious answer is to store the images within the database. But with 400 images of about 10KB each, this makes the db 4MB bigger than it needs to be. I'd like to avoid this if possible. Storing the images as a reference seems to be the answer, then. But this has the problem that Mac paths won't work on Windows, and vice versa. To get around this, I thought of creating separate Mac and Windows global paths, then combining that with filenames via a calculation to create valid filepaths for each platform. But I then get myself in a bind in that I want the photo to appear automatically, and not via a script. I'm not sure how this would work. Is there any way to do what I want? I'd rather not use plugins, but I have the Troi file plugin if that helps. If it can't be done, is the extra 4MB overhead, due to storing JPEGs in FileMaker, likely to cause me a problem?
  3. In the end, I fixed the layout on Windows. It still looks OK on the Mac. This is weird. FM do mention it in their help (do a search for "platform") but totally understate the case ... they say "there can be subtle differences" but in my opinion the differences are pronounced. My recommendation: if you're building on a Mac, allow lots of overflow room in all text boxes and factor in time to check/amend the layouts on Windows.
  4. Actually, it turns out the path isn't always the same; just getting the filename wouldn't be enough. I need the entire string after the word XSERVE. Any ideas? What I think I'm going to do is write a script to copy across the picture, but this time store it within the database (ie. not as a reference). This should work on Windows. Will the accordingly larger file be a problem, given that the database will be running from the server? I mean, the image has to be copied over the network, so it doesn't make much difference if it's from within filemaker or from the Mac filesystem. The bigger database isn't as elegant, but I can't see it being a problem?
  5. Thanks. I did what you suggested, and got the result: size:70,95 image:../../../../../ General graphics files/photos/GONW staff 72 dpi for Intranet/staffPhoto/041126 Anderson_Judith.jpg imagemac:/XSERVE/ General graphics files/photos/GONW staff 72 dpi for Intranet/staffPhoto/041126 Anderson_Judith.jpg I can see the information I want in there, but there's a load of other stuff in the way. Are you suggesting I parse it for the filename (everything except "041126 Anderson_Judith.jpg" in the above example is common to all records) or is there an easier way?
  6. I've set up a global container field on the Mac, into which I've imported a JPEG. I did this by clicking into the field in Browse mode and choosing Insert/Picture... then navigating to the file. I made sure that "Store only a reference" was turned off. This works fine on Macs on the network, but on Windows machines the global field contains the error "The file cannot be found: ", instead of rendering the JPEG as I expected. What's happening? It looks as if it's a problem due to the path changing on Windows. But since I inserted the photo directly into FileMaker (rather than storing as a reference) it should already be stored in the database itself, and therefore equally available to both platforms?
  7. Thanks, that works. I used a solution similar to the first one, with these adaptations: Set Field [YourField; ¶ & ¶ & ¶ & YourField] Set Selection [YourField; Start Position 1; End Position 1] Insert Calculated Result [ ... & ¶] with a calculated result giving the string ">mm/dd/yy username". This adds in the information I want, and puts the cursor in the right position for user entry.
  8. I've got a comments text field in my database. I'd like to have a button which adds a user's name and the date to the top of the text field, and then positions the cursor beneath it so they can add text. The aim is that users can keep adding comments, with the newest always at the top and the facility to scroll down to see older comments. How can I pull this off? It occured to me that I can cut the entire contents of the field, insert the username and date, and then paste back the field contents. This would be fine, except that it requires the user to position the cursor before typing. I'd rather have the cursor automatically in the right place. I'm on MacOS, so could probably pull it off with an AppleScript, expect that I need this solution to work under Windows as well.
  9. I've got a database of about 400 staff in my organisation. This runs on an Xserve/FM8 server. The database is very simple, with just contact names and a photos. I wrote the database on a Mac, and asked one of our admin staff to add the staff photos. They're stored in container fields as a reference, not added to the database. Although this works fine on the Mac, all the references are broken on Windows. I suspect that this is because the path is different. My question is: 1) Is there an easy way to fix the existing file to work on Windows? 2) If not, can I at least get the path out of the container fields somehow, so I can create a calculation field from it with different Mac/Windows paths. 3) Failing all the above, how should I recreate the photo field to work on both platforms? Note: I have the Troi File plugin if that helps.
  10. I've written a database in FM8/Mac, and am testing it on Windows. Fonts look terrible. I've used Tahoma (one of the MS core fonts for web) throughout, and hadn't anticipated any difficulty. But the fonts are much too large when I open the database in Windows, and it makes my layout look very poor. In a search, I found out that other people had encountered this. But I didn't find any solutions. What are people doing to work around the problem? Should I make all the fonts smaller on the Mac (ie. basically compromise the Mac layout) so it displays correctly on Windows?
  11. Thanks, that works great! This is the first time I've used FM since v5, very impressed with the new features.
  12. Update: I got the Troi file plugin. I recommend that anyone else who needs to do similar things does the same, it's very good and not expensive (can even use the £300 developer licence to deploy it for as many users as you like). There's a free trial if you're not sure.
  13. My database is a job log of graphics work. I want to display an overview via a self-join relationship in a portal. The match field is complex, a calculation field with the form: abc where a is an autoentered value which the user can update (it flags up when a job is completed and can be archived) b is a calculation based on whether the start date is < get (CurrentDate). c is a required entry from the user when they create the record (it puts jobs into a category 1-4 dependent on type, eg. flyer, leaflet etc) I have the relationship set up such that the self join is between the dynamic abc value, and a global abc (eg. abc=global_123). My problem is that, whilst the abc values are correct, they don't appear in the right portal. I can verify this by adding the abc fields to the portal layout. For example, I've got a portal set up to contain only abc=234 values. It does contain all of these, but also a 224 value. And that 224 value doesn't appear in my portal set up to contain 224 values (but other 224 values are there). What could be happening?
  14. I'm writing a job catalogue for a graphics workgroup. It's going to run on an Xserve and be accessed by three Macs. For each of the job records, I'd like to create a folder link which will work by: 1. Click button 2. Switches to Finder, opens the relevant folder I'm happy for users to link manually to the folder when they create the record (but it's an advantage for them to do this via the GUI rather than typing, or cutting and pasting, the path). What's the best way to do what I want? Are container fields the best approach, or is there another way? Can I do it with built in FM functions, or do I need a plugin (such as the Troi file plugin)? Please note, this solution can be Mac-only. But there will be Windows users accessing the database; it would be an advantage if the folder link worked for them but it's not essential. Also note: I'm building this in FM7, but by the time it's running my workplace will have upgraded to FM8.
  • Create New...

Important Information

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