Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

life036's Achievements


Enthusiast (6/14)

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

Recent Badges



  1. Ah, beautiful! I didn't realize you could embed a function into another function where it asks for a field. Coolbeans Thanks for the help.
  2. Hi All, I have this fairly simple field, it's a calculation that returns a list, and it works well: If ( IsEmpty ( IP Addresses::IPv4 Address ); "No Static IP"; List ( IP Addresses::IPv4 Address ) ) However, in the resulting list that displays, I'd like to substitute the carriage returns with commas, and I've come up with this bit of code to make the substitution: Substitute ( IP Address Display; "¶" ; ", " ) Is this correct? If so, where do I place the substitute statement? Will it go into the same calculation I use to define the field, or do I have to put this into a brand new field of its own? Thanks in advance, C
  3. Ah, nevermind, figured out how it all goes. I named the variable "$$ExportPath", changed "$$FileName" to "import.mer" and just formatted the filepath as $$ExportPath. Works a treat! Much thanks!
  4. Thanks. So, I name the variable anything I want, while leaving your "$$FileName" in there? Or am I supposed to rename that to something else? Also, how do I format the export filepath once the variable is defined correctly? Should it look like this?: $VariableName/export.mer
  5. Hi All, Basically, I'd like to define my export script to just dump a pre-named file onto the user's desktop, regardless of their username. The best way I know of to get directly to a user's desktop would be to use the Windows Environment Variable %USERPROFILE%Desktop . However, FMP doesn't like when I use the Windows environment variable in the file path. I noticed that they have an example for "$Variable", but it looks like that's for Filemaker variables and not Windows environment variables. Is this possible and I'm just getting the syntax wrong? Or is there a different way to do this? Thanks
  6. Thanks for the info. The thing with variables, though, is that they tend to disappear just like global fields. I'd like to define this title field about once per month, from my admin layout, and not have the users bother with title entry.
  7. Hello All, Hoping one of you fine folks can help me with a strange little problem I've got. I'm trying to create a field that you can type a value into once, and have it show up as that same value on every single record in the table. I tried just doing a global field at first, but I quickly found out that doesn't work with shared files. Silly me for actually expecting a global field to work "globally". Next I tried making a value list based on the index of said field, and then displaying it with an unstored calculation defined as the contents of that value list. I thought this was a pretty good workaround, but it turns out that it affects the performance of the database horribly when viewed on FM Go, as it is recalculating the unstored calc everytime someone does a find, resulting in 45-plus-second searches. So for my next attempt, I'm thinking about maybe putting the title in a single record in a separate table and relating it to the original table somehow. I can't figure out how to relate the table in a one-to-many relationship, though. Does anyone have any better, simpler ideas? Or any suggestions on how to relate the one-record table? Thanks in advance.
  8. I'm already doing it quite simply: Each of those fields you see circled in red is just a simple calculation field, defined in the main volunteer table. For instance, the 2007 field is just a calculation defined as: Sum(Volunteer_Hours_2007::Hours) I'd like to combine all of the yearly hours tables into one table, and redefine these calculation fields to only display a sum of hours for each specific year.
  9. Hi Vaughan, Thanks. I understand that it is a completely stupid design, which is why I started this thread to just have two separate tables. I simply haven't had the time, energy or know-how to redesign it correctly yet. What do you mean by the "selected" year? I'd like to display a sum for each and every year at the same time, without the need for the user to "select" anything (just like how it currently displays in the picture above). Is this possible with the solution that you mentioned? Thanks
  10. Just tried that; can't seem to get it to work. I must be doing it wrong. The calculation needs to be based on the year as well as a matching volunteer ID. The method you suggested is only producing one month's hours... Here's how the current database works: I have a separate table for each year's hours, and then I am able to get a sum for each volunteer for that year. The trouble is, I have to go back in every year and create another separate table for that year's hours so that they sum up correctly. It's completely stupid, and I know there's got to be a better way. Here is how it looks now so you can see exactly what I'm trying to do. The yearly hour totals are circled in red: Will a sub-summary even be able to show up directly on that layout in browse mode, or will I have to send the user to a separate layout in preview mode to correctly display the sub-summary that you are recommending? Thanks
  11. Hello, I am trying to figure out how to display what seems to be something simple. I have a database that tracks the hours that volunteers work for our organization, and I'm trying to make a calculation field that displays the total amount of hours that a volunteer has worked in that particular year. I can get it to sum up the hours for each individual volunteer easily enough, but I have no idea how to only sum up the hours for one particular year. Can someone kindly help point me in the right direction? Thanks
  12. Hello, I'm wondering if there is some kind of calculation or summary that will allow me to view a count of how many times each word or phrase shows up in a field. To put things simply, when I hit Ctrl-I to index a field as shown in the image, I'd also like to see how many times each indexed word appears in that field: What is the best way to accomplish this? It doesn't matter where the number shows up, I just want to get a quick count of everything in the index. Thanks
  13. Not so far as I can tell, it's a .fp5 file... Ive tried the shift trick on OS X, OS 9, and WinXP - No deals.
  14. Nah, shift doesn't work... Just tried it. Neither does Esc, Option, Ctrl, or Apple... Could it be that I did something weird to it in Developer that is causing this problem? Chris
  15. Hello, I created a database a few years back (with version 6 pro or version 6 developer, I can't remember), and it always opens with the layout mode unavailable. It never asks for a password. I seem to remember a keyboard button that you hold down while opening a file to force it to ask you for a password, but I can't figure it out. Anyone have any idea how I can re-gain access to administer this darn database!? I'm sure I have the password, I just can't get it to ask me for it... Sorry if this is in the wrong forum, but it seemed like the best choice. Thanks! Chris
  • Create New...

Important Information

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