Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About gephry

  • Rank
    Why use anything else?
  1. Update: the Applescript I posted works fine for locally hosted files, but it doesn't work for ones hosted on a server. That makes sense. So instead, here's a better solution that is cross-platform. What I'm doing now is passing the "max" character value to the script via the ScriptTrigger's ScriptParameter. I also have the option of passing a "nextObj" value to the script. If nextObj has a value it will go to that object on validation; if nextObj is null (i.e. it wasn't included in the ScriptParameter), the script will go to the next field. This allows a considerable amount of flexibility (function can be used on any layout or in any table) with the least amount of modifications. See attached example (yes, I've scripted it a little more complicated then necessary, but this allows for future expansion/flexibility of the script if you wanted to send other variables in the ScriptParameter to do other things). Thanks again for your input! ScriptTrigger_NextObject.fp7.zip
  2. raybaudi -- NICE! That would definitely work, too...and be compatible for both Macs and PCs. Right now I'm only dealing with a database for a Mac so I might cop out with the quicker fix and stick with the Applescript ---> which does work! I read somewhere that you might need to "Enable access for assistive devices" in System Prefs > Universal Access, but in a few tests I haven't encountered a computer that you had to in order for this to work: Perform Applescript( tell application "System Events" to keystroke tab ) Thanks for all your help!
  3. Vaughn states the million dollar question well. dayzrespite, while I can pass the current object to the script via a calculation, I don't know a dynamic/calculatory way to get the name of the next object. I could going through the painstaking process of hard-programming the next-object-names in to the previous objects scripts themselves, but that kind of defeats the flexibility and simplicity of the function itself. normanicus: I'm not entirely sure what you mean. It's fixed in the way that I've set up a specific tabbing sequence but jumps around the layout in a non-static fashion... There are two script parameters that would be useful in a situation like this: Go To Next Object (similar to Go To Next Field; I've submitted it to Filemaker as a feature request) PerformKeystroke ....wait a tic. What if I were to use PerformApplescript and have it execute a text character of Enter, Tab, or Return? That would take me to the next field. Can you do that with Applescript? Have it "type" or perform characters for you? Hmm! I gotta check this out.
  4. I have a bit of a head-scratcher. Any ideas are helpful! I am using a KeystrokeScriptTrigger on certain fields and am passing a "MaxCharacter" value to the script. The script checks to see if the Length( FieldContents ) = MaxCharacterValue, then the script performs a "Go to Next Field" script step. Basically, I'm only allowing X number of characters in the field (example: 5 characters in a zip code). However, I don't always want to go to my Next Field....often, my next item in the tab order is an object...of which I don't know/can't calculate the name, so I can't use "Go To Object[ NAME ]". Any ideas on 1) If there's a way to "Go to Next Object" 2) Perform Keystroke["TAB"] etc... THANKS everyone!
  5. Ogh, silly me. I swore I didn't have an ApplicationVersion check OnFileOpen because it's been so long since I wrote the file not to mention it didn't sound like my wording....but guess who included that in his code? Sheesh. Thanks for your quick reply, Lee.
  6. I've been searching the forums for a while now but I haven't seen any posts regarding a similar situation. (Forgive me if I overlooked something...) I've begun using FMPA11 in place of FMPA10 for my FMP10 solutions and I'm getting an error upon opening the files. It says that my FMP10 solution requires FMP10 and won't operate without it. Which is strange because I thought everything was "upwards" compatible. I haven't found any problems in my scripts and it seems to operate okay thus far. Even if it does operate correctly I don't want my clients getting this error. Attached is a screenshot of the error (for the record it is NOT one of my errors scripted in...) What gives?
  7. Thanks, Tominator. I had been working with method A for a while but was hitting a snag. It was giving me only a partial list of the titles; I think it was because I was just using Title & "¶" & Parent::cSelfAndParentTitles. List() did the trick. And I am keeping the infinite loop at bay by using: If( KEY_Parent =""; Title; List( Title; Parent::cSelfAndParentTitles ) ) Simple enough! I agree, Method B would be safer, but I'm not 100% sure how many levels deep this data goes. So I'd rather cover my bases with an "infinite" calculation. Thanks again!
  8. Alright, this is a little odd. Someone set this database up to be dictionary-like or even choose-your-own-adventure-like ("For more, please see record..."). So each record can refer to another record within the current table. That being said, you can have a string of child > child > child > parent. Basically some records are a "continuation" or "more info" about the parent record. So what I'm trying to figure out is, how can I collect or snowball data together from the parents and grandparents....on each of the Children records. Preferably without a script! (I'm trying to stick to calculations.) The data structure is set up like this: KEY KEY_Parent Title Description (etc.....) Table::KEY_Parent == Table::KEY Does anyone know of a way to access the data on the other parent/grandparent records when on the furthest Child? There is only one self relationship referring to the parent of the current record. But that parent could be the child of another record. In this instance: KEY = 10 KEY_Parent = 9 Title = "Smallest Child" KEY = 9 KEY_Parent = 8 Title = "Middle Child" KEY = 8 KEY_PARENT = 7 Title = "Older Brother" KEY = 7 KEY_Parent = "" Title = "Absolute Parent" For each record, I would like to be able to get a list of all the titles "above" that child. For example: KEY = 10 KEY_Parent = 9 Title = "Smallest Child" calcAllParents = "Smallest Child¶Middle Child¶Older Brother¶Absolute Parent" KEY = 9 KEY_Parent = 8 Title = "Middle Child" calcAllParents = "Middle Child¶Older Brother¶Absolute Parent" etc. Any idea on how to get the all of the titles of each of these records in a list? This is a little wonky, so I really appreciate the help!
  9. I haven't established any custom menus in my file yet...however not all access levels are able to access the same commands! All access levels are currently using the same menu, but some commands are greyed out. I can't figure out why this is... The most important missing commands right now are Control+ArrowKeys (on Mac) to navigate to previous or next records. I can do that no problem with [Full Access] account; but the moment I log into the accounts with restricted access privilege sets these menu commands get greyed out. All privilege sets have "Available Menu Commands" set to All. What am I missing? Thanks!
  10. Yep! It happens the same way for me. Going into FM is funky, but going back out it's fine. Sweet, I'm glad to hear I'm not the only one having this issue. And it makes sense about the masking. One of my clients is just now telling me that they had a similar issue with PDFs in FM8.5 back in the spring. So I wonder if this is not only a PDF vs FM10 thing? I haven't had the chance to test it on older versions of FM. Wonder if it's another one of Apple's quirks, or if it's on Filemaker's end? The test would be to try copying portions of PDFs into Filemaker on a PC. (I have no PC. Bueller?) Good call on the screen shot. Oh and it's actually easier than that; you don't need to press Control. It's just Command+Shift+4.
  11. No, the container field is set to "Reduce or Enlarge" to fit the field. I've run a few tests and am having the same problem. I created a new database with one table with only a container field. On the layout, I put the container with rotation at 0degrees, and also at 90degrees. But I'm still having issues...this time with both orientations. I did discover something, however. To preface this discovery, I should have mentioned -- people are copying PDFs and then pasting them into this field as a graphic, not as a file. I did the test with PNG, JPEG, and TIFF images---they work totally fine! No issues with cropping at all! PDFs are the only container graphic formats that don't display correctly. Strange. I've attached a file with a PDF and a JPEG of the exact same image. I wonder how or why this is happening? Field setting or Filemaker bug? Any ideas? ContainerFieldTEST.fp7.zip
  12. I am perplexed! I have a few layouts to print CD Jewel labels from a container field. These layouts differ in the rotation of the container field (which holds main content of the case label). I.e. the field is not rotated on one layout, and in another the field is rotated 90degrees depending on how the graphic was scanned. The problem is that on the 90degree rotation it is drastically cropping the edges of the graphic! (See attached screen shots.) Both are exactly the same record, exactly the same field, exactly the same data. I even copied the container field from 0degree layout over to the 90degree layout, rotated it and tried it again --- to preserve settings, graphic or other. It is still cropping! Any suggestions? Is this container rotation a known issue in FM10? I used these same layouts in a FM8 database and it worked 100% fine. Thanks!
  13. Disclaimer: I only posted because after searching long and hard, I couldn't find an answer already posted in the forums. BUT! I continued my search and finally found what I was looking for. (Administrators if you feel like deleting this post, great; if not, here's the solution for anyone else that's having the same problem.) I found it in this post: http://www.fmforums.com/forum/showtopic.php?tid/190005/ It is simple simple oversight on my behalf and of course: it's a single checkbox. When making new Access Privilege Sets for users make sure you check the "Access via Filemaker Nework (fmapp)" checkbox in Extended Privileges in the Accounts > Privilege settings. Otherwise Filemaker won't allow that Privilegeset to access the Filemaker database(s) through the server. This is why it wasn't auto-logging in, and why it was giving me an error when I was trying to do it through a script. Just goes to show: if you need an answer, search harder.
  14. I'm not sure how else to describe it other than, "it's REALLY strange!" I am running our former FM8.5 and FM7 databases just fine on our new FMServer10 software. I just completed a new Filemaker 10 database and am now sharing it through the server---but I'm having a lot of issues with this file and this file only. The FM10 file is designed that it opens under a default limited user account (specified in File > File Options)...but it won't open under that account. It prompts for a username and password! So I added an "On Open" script that does an automatic Re-Login without dialog...and it won't do that either! It still prompts for a username/password and then tells me that I don't have enough access privileges to perform that action. Strange! I have the file permissions set to "Read & Write" for every and all users. I've done file recovery and no issues were found. So I'm stumped! The thing is when running this on Filemaker 10 or Filemaker 10 Advanced it works perfectly fine! Any suggestions? Thanks!
  15. Hm, you know what?...I wonder. I am assigning a fields to a variable and then plugging the variable in the Applescript. I wonder if something is happening in the translation between variables and the Applescript.
  • Create New...

Important Information

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