Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About abailey3

  • Rank

Recent Profile Visitors

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

  1. I need to be able to uppercase all cardinal directions (NW, SE, etc) in an address field. I have this resolved using a Perform Find/Replace step for when these occur in the middle of a field ("[space]NW[space]"). However, often these occur to the far right of a field. Is there an easy way to simply uppercase the last two characters in a field without changing anything else that's been entered?
  2. Is there a way to easily capture the name of a file being imported into Filemaker during the import process? For instance, if I have a CSV file called "FileName.csv," is there a way to set the value of a global field to "FileName.csv." This would be used to ensure that files aren't being imported multiple times. FM does display a dialog box during the import that says "Importing from FileName.csv," so I'm wondering if there isn't a function already in place that I'm just not privy to. Thanks!
  3. So in that example, "Black & Blue" would be the correct answer. There are a different number of line items per value list. There's a couple with only 4-5 which I've done manually (using the Find/Replace), but there are other lists with as many as 75-80 options in the value list.
  4. I have a large database with a multitude of fields where a value list via drop down is associated. However, when we set out to develop this, we didn't know what many of the values in these lists would be comprised of, so we didn't have any strict validation in place. Users were allowed to edit the very basic lists we came up with and we didn't have validation on any of the fields. So now what we have is a ton of fields and records with data that doesn't match the associated value list, meaning there's lots of redundancy (some records will have "Black & Blue" in a field while others will ha
  5. Yeah, an e-mail would work just as well. Oddly enough, I've had experiences where the opposite was true regarding the Halt Script step. I've seen scripts that end with just Exit Script not work at all and leave users in the middle of scripts when they shouldn't be, which ends up causing a problem when they go on to run another script somewhere else. (Granted, these issues were in scripts I'd inherited from a previous developer, so I'm sure the problem could have been something else and I just never discovered it.) At any rate, I've never seen the Halt Script step cause any problems firstha
  6. I have set up a database that allows employees to log in and out of tasks throughout the day so that we can track productivity and use the data to better bill. One of the features of the database is an "In Progress" button that allows department managers to, with a single click, see what employees are actively working on. It all works well except for end of day tasks. Every couple of days, an employee will leave without first logging out of their task. So the next morning, the supervisor will have to manually adjust their time. In an ideal world, each department manager would check the "In Pro
  7. Every now and then, for seemingly no rhyme or reason, a script that relies on searching the contents of a field will start to fail with the message "No records match this find criteria." The hang up is, it will not find records even if there are records that match the search criteria. You can look at a table full of fields filled with 1's, but if you search for 1, it will say it cannot find records. Currently, I have this happening on a field based on a self-relationship calculation. The field in question is defined as Count ( selfTable::ID Field ) and the ID Field it relates back to is a
  8. I forgot to post an update, but we were able to find a solution: a bigger, badder server. We found that a Filemaker server really relies on three things: RAM, hard disk speed, and memory. We installed a new server with 15000 RPM hard drives (four mirrored drives with the OS and databases running on C: and backing up to E:, with mirrors of each) and 24 GB memory. Almost instantly, our problems were solved. I regularly add convoluted fields and it processes quickly without anyone noticing. Additional observations: running a back-up software other than the one built in to Filemaker can
  9. Because of the nature of our business (and the relentless urgency of management), I develop almost exclusively on our live system. [more about that here] I rarely have issues with users stumbling upon in-development layouts or performing scripts that I'm working on -- actually, I don't think I've ever had that happen. As @BrentHedden mentioned above, if you save navigation for last (really, you can do navigation whenever, just so long as you don't give 'starting line' access up front) there shouldn't be any trouble. The big issue that I run into consistently, as described in that lin
  10. I'm developing for a Filemaker intensive environment -- we have roughly 80 GB worth of data, 30-35 simultaneous users, and a number of related databases -- and the obstacle I'm running into is being unable to make modifications to even the smallest of tables without locking everyone up. Something as simple as adding a single text field to a table with just one record can take 20-30 minutes, if not more, and while that addition is being processed, every user in any of the databases will lock. Best practices suggests working on back-ups to know exactly what needs to be done and applying cha
  11. I'm working on building a new invoicing system. One of our billable items is an update that runs every Thursday. We bill on a monthly basis. What's the best way of calculating the number of Thursdays in a specified month? As a part of some other calculations used in this model, I do have specific month (i.e. "August", "September") and year (i.e. "2010", "2011") fields. Piggybacking those would be great.
  12. That's one of the ones I've tried, actually. It works just fine on either OS, it just doesn't work within Filemaker on a Mac. I attempted to use the IDAutomation plug-in, but it doesn't seem compatible -- my guess is it only works with their specific fonts.
  13. Maybe I spoke too soon. While the 3 of 9 font works great on PCs, it doesn't seem to work on Macs. Interestingly, if I open up a document on a Mac I am able to create a barcode fine, but not so much within Filemaker. It just reverts to normal text. Any ideas?
  14. I've been trying to figure out a free solution to this problem for a couple weeks now (okay, so maybe I'm exaggerating slightly) and haven't been able to find anything this simple anywhere. Thank you. Adding that calc field, installing the font, and having a printable barcode takes literally two minutes or less. I knew there had to be an easier way.
  • Create New...

Important Information

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