Jump to content

Emma in England

  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
  • Location
    Leeds, England

Emma in England's Achievements


Enthusiast (6/14)

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

Recent Badges



  1. Oh, a complete change! Thanks so much. My Mac also has Windows, so in fact I'd only be installing it on the one machine... in a way! The client was perfectly happy to buy FMP, even telling me I wasn't charging enough for my work. I'm sure that isn't typical! Hoping to get some more similar work once I've gone to the expense of FMPA, although it's not my day job. Problem solved, thanks!
  2. OK, I'm googling away and gather this feature has gone. So if I simply uninstall the client's copy from my Mac, will it run happily when installed on her PC or will she get licensing problems? Just want to avoid any potential embarrassment, not to mention a wasted journey.
  3. Until recently, stuck on FMP 9, I could de-activate a computer by going to the Help menu. I bought FMP 12 for a client, and used a copy of it to do development work for her. Now I can afford (just!) to buy my own FMP 12 Advanced, I want to release the copy so that my client can use it. Does 'deactivate' still exist in FMP 12? Thanks Emma
  4. I would import the Excel into a new table, and show it in a portal on the equipment's record. Do you have a record for each piece of equipment? And does that record have a unique ID? If so, does that ID also appear in the Excel spreadsheet? Or is each spreadsheet related to one piece of equipment? Since this is only once a year, would importing the spreadsheets manually be a problem? It could be automated if they have sensible names...
  5. Sorted! I just needed to see where I was going, I think asking the question helped. Although the way I worded it didn't! I just added a calculation field to the related field so each word was a single value, with a return at the beginning and at the end, and in the home field put a return above and below the Postcode field, that way I could look for whole words. Sorry to be wasting your bandwidth.
  6. REWORDED QUESTION I want to see in a portal records where ANY VALUE in a field in the home table = ANY VALUE in a field in the related table. So if the home table has 'LS WF BD' and the related table has 'Hillsborough' there will be no match (in spite of 'ls' occurring) but if home has 'LS Leeds WF BD' and the related table has 'Leeds Bradford Halifax' there will be a match I can manipulate either field to be return-separated values or something, if that helps. I just can't see my way ahead right now. Thanks, Emma
  7. 5 years on... and thanks from me! For years I've been writing import scripts with extra steps to find and delete the empty rows. Do I feel stupid. Funny how you ignore parts of Filemaker that you don't realise you need! THANK YOU!
  8. Fenton, your ugly hack is the best option I've seen (apart from a long article about 'Field Aliases' which turned out to be an April Fool...). There is a truly terrifying option here http://www.filemakerhacks.com/?p=3520 but I think that is way beyond me! Ugly hack, here I come (hey if it all happens in the script and gets deleted after, who's to know?)
  9. I'd love to be able to do this too.... The field names are not what I actually want to appear, plus there is a list of codes for the recipient of the spreadsheet to refer to which I'd like to keep.
  10. Thanks Brian - I was just researching this sort of thing... but 'comment' has solved the problem for me! I have now got as far as changing: 25 32 40 41 42 50 61 62 into 25 32 40-42 50 61/62 Now somehow I need to work on that until it's: 25, 32, 40-2, 50, 61/2 Not to mention pulling the most heavily populated page to the front of the list and making it bold (in InDesign)! This is going to be a long struggle but I WILL get there!
  11. Yes! You were right. Thanks so much. I'm wading about in stuff I barely understand, and missed that. I know it's a common mistake.... I wish I could describe this more clearly - I'm sure I'll have more questions! It's actually an existing system written in a very old version of Access....
  12. Yes, I've done that. But the List function uses the unsorted values. I tried defining the values as a Value List, which sorts perfectly, but I can't see how to get that into a manipulatable field! I'm happy to try another approach. I've got my head buried in a text book and hoping for inspiration...
  13. I am writing a database to create a complex and sophisticated index to a large catalogue. I have a table of Categories - these are the actual text that appears in the printed index. These are related to a table Page Entry which has a page number and a ProductName. The ProductName is related to one or more Categories. So, the Category 'Barbecue' appears on pages 25, 32, 40, 41, 42 and 50. I have to manipulate these numbers and eventually output 'Barbecue [tab] 25, 32, 40-42, 50' I have got the numbers into my 'Category' field by 'List ( Page Instances::Page No )'. However, if the entry on page 42 is added later than the one on page 50, I end up with: 25, 32, 40, 41, 50, 42 How can I force that list to sort numerically? Must I script a bubble sort? Sorry if I've got terms wrong, or if my whole approach is wrong - I'm self-taught and pretty much alone, so be kind and I'll try to learn!
  14. I'm doing something very similar. I use a separate table for Products and Images. The images are not always named consistently, but usually start with the product code. I have a calculation field in the Images table which takes the first 'word' of the image and derives a product code from it. That field becomes the match for the relationship between product and image. This is also useful as there can be many images for one product. I've also added a script that placed the image straight into Quark when clicked, but that's another story (but a great time-saver).
  • Create New...

Important Information

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