Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Rich

  • Rank

Profile Information

  • Title
  • Industry
  • Gender
  • Location
    Lewis-Clark State College
  • Interests
    Ultralight flying and amateur radio.

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

Recent Profile Visitors

383 profile views
  1. Thanks! That solved the first part. I used this calculation: Substitute ( GetValue ( Syllabus__lxr ; 2 ) ; "FILE:" ; "" ) ...to remove the "FILE:" text leading the filename.
  2. I've been told by The Powers That Be that we don't have the money to purchase a plug-in to view .pdfs in externally-stored containers, so I need a native solution to accomplish that with solutions stored in FileMaker Server (Windows). Mind you, users won't be editing .pdfs, just looking at them. I perused this forum and found the suggestion in a post to open the .pdf using Open URL so it can be viewed in a Web browser but try as I might, I just can't nail down two tasks: (1) What script/calculation do I use to grab the .pdf's filename, and (2) Setting the path to the file in the Open URL script step. I included a screenshot of the paths. TIA for your help!
  3. I've read that container data shouldn't be embedded in a FileMaker Pro (FMP) solution because it can slow performance so external storage is a better way to go. I get that. However, I'm a little confused as to how to go about it even after reading the online FileMaker Help/Info pages. Here's what we have: a portal, accessible by IWP, where users will upload their .pdf's to our (virtualized) Windows/FileMaker Pro server by clicking the button, UPLOAD. Currently, .pdf's are embedded in the field, Container__lxr; the plan is to use SuperContainer--or some other means--to allow users to view the stored (or referenced) .pdf's instead of having to download them to be viewed later. In File > Manage Containers--and in the container field's Option tab--you can see what it looks like in the attached. Where to I go from here so an uploaded .pdf is stored as a reference (outside the solution) and it can be found by SuperContainer. (On that note, do I even need SuperContainer or is there a native way--say, using the web viewer, to view .pdf's?) I know any response will be lengthy so thanks in advance for your time and reply/replies. Cheers, Rich
  4. Ah! Brilliant! Thank you!! I'd like to send you a coffee card as a thanks for all your help--can I send it via your website link in your signature line? (Hopefully, I can snag a Timmys for you.)
  5. Looks great but we're not quite there, yet. I don't know how the dates I entered disappeared but they did somehow. Anyway, if a student takes the same test (code) more than once, the first time (date) the student takes it should have a First Attempt of 1/Yes; thereafter, 0/No. So, say for Record 1 (_p_ParentID) a student took test 5001 on 05-15-1999 and again on 01-20-2000, in First Attempt the 05-15-1999 date should be 1/Yes and the 01-20-2000 should be 0/No.
  6. It was easier to make a quick-'n'-dirty one so I've attached it. First Attempt.fmp12
  7. They are. It's a messy file so I'll create a clone and will tidy things up a little make it easier for you before I upload them. Thanks for the fast reply!
  8. Thanks, Siroos--I did what you suggested but ran into a snag--my fault for not adding this earlier. Because these calcs are done in the child table, the count for the number of times a code is used includes all the records with that Code instead of a specific student so I'm getting a count of 285 instead of say, 2, for Code 5005. To try to filter the count, I added the StudentID, in addition to the Code in the new TO (with an = sign, like Code), but that results in no records being seen, so that wasn't it. I'll keep trying with different permutations unless you, or someone else, chimes in with a suggestion; if I figure it out, first, I'll post the info here.
  9. G'morning, all: Please refer to the attachment. What I'd like to do is have the 1st Attempt (text) field auto-calculate whether a record's (Test) Code has been recorded with an earlier date; "No" if it has (e.g., there's an existing record for Code 5004 taken on Test Date 01-20-2017 so the record with it being taken on 01-08-2018 will have its 1st Attempt field set to "No"); "Yes" if it's the first time it's taken (e.g., Code 5002...and subsequent dates with Code 5002 would be set as "No".) I know I could script this by sorting by Test Date then Code, then comparing the existing record with a previous one...which would then set the 1st Attempt to the appropriate Yes or No, but I'm curious whether I could set this up as a calculation within the child table...just that I don't know how to go about doing that. Thanks in advance for your help!
  10. Thanks! (For anybody copying and pasting Ocean West's formula and finding that it doesn't work, it's because the third k_StudentID fieldname is missing its leading underscore character; _k_StudentID works.)
  11. I read the FM v16 SQL Reference (Page 9) but I don't think it gave me the whole skinny on using non-alphanumeric field names so I'm stuck. Using this formula works: ExecuteSQL ( "SELECT COUNT ( k_StudentID ) FROM EXPERIENCE WHERE k_StudentID = ? " ; "" ; "" ; k_StudentID ) ...but the real name of the field is _k_StudentID, so the leading underscore character is the troublemaker. In the Guide it says to use double-quote marks but FileMaker Pro squawks with an error message when I use them so I'm missing something. What's the correct syntax to make this formula work? Thanks in advance for your help.
  12. (I'm sure this has been covered before but nothing came up in my search criteria) I have a Year (number) field in a portal where I want to force the entry/recording of four-digit years but no matter what validation criteria I set for in the field definition, it won't fault to produce a validation error message if a non-four-digit number is entered, even with a script trigger using a Commit Record script step. What am I missing to get the validation to work? Thanks in advance for your help.
  13. I feel a little foolish asking for help for this simple operation but for the life of me I can't figure out why I can't get a file/script to "hand-off" to another file on the server in WebDirect; internally, the hand-off is smooth and works so there's some thing I'm missing in the scripting or settings. Order of operations: User logs into the "switchboard" file online. (Works fine) User clicks button to leave switchboard file for Assessment file using the Open File script command. (Nothing happens) Like I said, "inside" FileMakerPro when I click the button I'm handed off to Assessment, no problem. I have the checkbox ticked in the Privilege set ("Access via FileMaker WebDirect") in the Switboard and Assessment files, so any ideas where to poke around to see what I'm missing, or what script steps should I use to go to the Assessment file (and closing the Switchboard file)? Open File doesn't work in WebDirect, so....? TIA for your help!
  14. Greets, all: I want to script the creation of a folder--named Job Chop-Chop! Export--on the desktop (PC) and found this Web page with instructions ( https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ) but being a Apple person I'm admittedly hazy on Window filepaths and can't get the script command to work (see attached). "cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Export" ) I guarantee it's something as simple, I'm just not seeing it. Thanks in advance for your help! Strangely enough, re-entering the command caused the Send Event command to re-define itself so now it works: Send Event ["aevt"; "odoc"; ... I'm curious how the event changed--any explanation(s)?

Important Information

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