Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

FestiveEmbalmer's Achievements


Enthusiast (6/14)

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

Recent Badges



  1. weak sauce people, weak sauce... I have 20-25 machines that due to the constraints of a legacy system must share their own databases at any given time. I have had no problem connecting between them up until now and hardware/software-wise there are three groups of identical systems. I have one and only one system that cannot see any other local hosts on the FM network, neither does it appear as a local host to other users. Filemaker sharing is enabled and the databases themselves are set to be visible. The firewall is set to allow FM sharing and in fact, I have simply turned off the firewall with the same result. All of these systems are able to access each other through normal OS file sharing for non-fm purposes and the machines all respond to ping. I have changed the machine to a static IP with no change. Adding other computers manually to "Favorite Hosts" worked ONCE. After that, files shared by those systems did not appear. Also, ONCE, a dialogue popped up asking for a password to access files on the selected system. The files are not passworded and the dialogue appeared to be FM not XP. Any ideas?? much thanks, matt
  2. Is there a way to get around filemaker's "specify field" method of selecting a field in scripts? Are there any techniques for calculating field names to be acted on?? I am trying to make my scripts more abstract and multifunctional, but am being thwarted far too easily! thank you for your help, matt
  3. I see the wheels turning! The globals don't need their own TO but they are in a relationship. See my attached example. There are two creation buttons to illustrate the basic idea and the implementation through a relationship. Notice that there is a relationship for the portal and a different one for record creation. Records created via the relationship meet the criteria for the portal and are displayed on record commit. Also worth mentioning is the RELATOR function provided by Alexander Zueiv. I use it to simplify things a bit, but I recommend you make sure you understand how Filemaker's native record creation can be used before using a custom solution. Script Killing Techniques createfromglobal.zip
  4. John is right; you really want your primary key to be meaningless. Like a soul! But seriously, think of it like a soul. The number is meant to individually identify that specific instance of the table entity in the database in a way that the system can quickly and easily relate other specific entities to. If it has a meaning to you, that almost always means that you will want to change it at some point to reflect a change in the meaning. The fact that the number is sequential doesn't actually help its function unless you need to know the creation order of your records, in which case you should have a "creation timestamp" field for that purpose anyway. From the information you provided, I would either: 1.) change the field options for your serial number to "On Commit" and then set your script to take the user to the editable layout before creating your record so that if they do not finish it doesn't use up a soul...er serial number. 2.)Make copies of all the fields you want to allow them to edit that are GLOBAL versions. Then write a script that creates a new record, transfers all of the data from the global copies to the desired fields and then clears the globals. No wasted serial numbers. hope that helps, matt
  5. a couple of ideas: 1.) You already have a button outside of the portal for creating a new record, so you might consider putting global fields for the new contact information outside of the portal and changing the button script to create the new record with that information and clear the globals and commit the record. Then the user never has to spend time editing the records in the portal in the first place and it updates instantly. (Imagine that would help with record lock too.) 2.) Same as above, but put the globals into a popup window that displays during the "create new" script. Same result, but different aesthetics. (Looks awful in Windows.) 3.)Use a script trigger plugin, like Zippscript. matt
  6. It looks like you have your solution pretty well done apart from actually making layouts. The short answer to your original question is as Søren said, Portals. Portals are filemaker's method for displaying related records on a layout. I did notice that all your relationships are single criteria equijoins. There is no problem with that, but understanding filemaker's different joins will allow you to leverage a lot of your experience in terms of functionality. In addition to building your db structure, you can also create relationships that are like permanent queries. For example, you can create a display of all the other customers in the DB on a customer layout by creating a nonequijoin relationship between the customerIDs (a self-join actually). They can all be displayed and accessed from a portal. Using global fields you can extend this to filter by Start & end dates, ranged values or even complex multicriteria relationships. I highly recommend the book "Special Edition Using Filemaker 9". If you're bread and butter is IT, than I even highlier recommend a subscription to the O'Reilly Safari library since it has that book as well as many others and some FM video instruction as well. peace, matthew
  7. It would seem I might have confused the two issues. I do not know if merely having filesharing turned on can corrupt FM files being shared via FMServer - all I know is that my org has both issues, and files shared in either method have been corrupted. I would love to have all those legacy files shared via FMServer but unfortunately, there are 1500 of them. Woe is I. A-developing-I-do-go-go. may your files stay nubile and pristine, matthew
  8. I'm sure there is a fancy answer for the sort, but I would just create a calculation field that takes the first letter of the field you want to sort thusly: Left ( LastName ; 1) Then I would make a print script which would perform a find for A in that field then go to the desired layout and print and then perform a find for B in that field and go the the desired...etc... I'm afraid i'm pretty terrible with layouts, I would just have to keep positioning and resizing till you get it. I know that Envelopes of type 7 are that size, but I doubt FM has a print set up for that. good luck, matthew
  9. Had me puzzled, but I got it. Your calculation for Full Name has the result as Number. Change it to text and it will work. peace, matt
  10. There are two solutions as I see it: 1.) Assimilate & Adapt http://hardcoremac.stores.yahoo.net/fipro60forma.html http://nostarch.com/frameset.php?startat=filemaker 2.) Cajole & Conquer http://www.filemaker.com/downloads/pdf/filemaker_versions.pdf http://www.filemaker.com/purchase/store/corporate.html Key words like "security", "email integration" combined with features like PDF reporting can make that upgrade an attractive sale, even if they aren't savvy enough to recognize the benefits of multitable dbs. Besides, they are going to have to pay SOMEONE to help them with upgrading and development. Might as well be you, right? matt
  11. I can back up those best practices with personal experience. I inherited a setup with filesharing and filemaker on the same server. Seriously: Filemaker + filesharing = critical data corruption. Until I get our new server up and running, resurrecting files is routine maintenance. here thar be dragons, matt
  12. I am not sure exactly what you mean, more context would help. If you are comparing two groups of people, for example, then you might want to have one table not two. Are the tables related already or do they just share attributes? For example, People and Equipment can both belong to the circus but they may not be related for your purposes, so "circus" is just a value in a category field that they happen to share. Are you wanting to be able to enter a value on a layout to determine what records share that value in multiple tables or do you need to find all other records that share the values in the record you are looking at? I'm pretty sure what you are trying to do can be accomplished pretty easily with the right relationships but it would help if you could describe your specific situation. matt
  13. Go to the unzipped Zippscript folder. There should be a fm db entitled "zippScript Example". On the main layout under "Examples" are the techniques you would use to trigger scripts under certain circumstances. For example, to trigger a script when committing a record, you place the script in a field validation calc. for the appropriate field formatted per the instructions in the example.
  • Create New...

Important Information

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