Jump to content

Rich

Members
  • Content Count

    65
  • Joined

  • Last visited

Community Reputation

2 Neutral

About Rich

  • Rank
    member

Profile Information

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

Contact Methods

  • Website URL
    http://www.lcsc.edu/education

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    17

Platform Environment

  • OS Platform
    Mac
  • OS Version
    High Sierra

Recent Profile Visitors

638 profile views
  1. Greets, all: I can't seem to find a definitive answer as to how to view .pdfs stored in container fields (on our PC server, stored externally, open storage) and via WebDirect. I have the Data Formatting command set to Interactive Content and have Adobe Acrobat Pro (and Reader) on my client machine (Mac), but that's as far as I've gotten; database is stored on our FMPS v17.x server (Windows). TIA for your help!
  2. *blush* I had already defined the new Summary field but forgot to connect to it. Works like a charm--MANY thanks!
  3. Rats, still getting a "1" for a count. I included a screenshot for your review of Count__lcn and Name_LF__lxs. Here's the calc, as entered, in the Count__lcn field: ValueCount ( UniqueValues ( GetSummary ( Name_LF__lxs ; TestCode__lxn ) ) )
  4. (I know this has been covered multiple times here but after after performing multiple searches I can't find the answer, so my apologies for subject repetition.) Happy holiday season, all. This is pretty basic but I'm blowing it calculation-wise: I have a report that has two, summarized sections, the first by Test Code (TestCode__lxn, a number field) and the second by name (Name_LF__lct, a calculated concatenation of the Name_First__lxt and Name_Last__lxt text fields.) What I want is a (distinct) count of students per test code (FieldName: Count) in the summarized Test Code section. I first tried Name_LF__lxs--a summary field set to count Name_LF__lct--but with it parked in the Test Code summary section I get a count, but not a distinct one, i.e., it shows 40 instead of 37 because it's counting multiple, same-named Name__LF__lct records (3 of them). Next, I tried GetSummary ( Name_LF__lxs ; Name_LF__lct ), but it shows only a count of 1. ...then I tried making a value list out of Name_LF__lct and used the calculation, ValueCount ( UniqueValues ( Name_LF__lct ) ) ...with indexing turned on since it's a calculated field. No good--still shows a count of 1. I'm sure I could whip up an E-SQL calc but I'd prefer to keep to native FMP commands. I'm sure the answer's simple...too simple for this overcomplicated brain to handle. TIA for your help!
  5. * heavy sigh * This is one of those instances where you chase your tail and end up with a major "D'oh!" I've attached the script steps that I've been using and it suddenly dawned on me that even with the PC version of FMP running in the PC environment of the emulator, the Get (SystemPlatform) command still pulls the "root" operating system of the computer--which in my case is OS-X (Mojave)--so with the script steps, as coded, the first part of the IF statement will drive the result of it; when I nulled all but the PC's Send Event command, it worked. Thank you all for your patience and help, and my apologies for taking up your time from my ignorance.
  6. It's pretty straightforward: /C:/Users/WF7A/Desktop/
  7. Hi, Siroos: I tried that (enabling Create Directories) but ran into the problem of setting the path, even with the basic Get (DesktopPath)--I get an error message (See attached.) Even if I can get it to work, I don't see how it will create a folder on the desktop but that could be because I'm being extraordrinarily dense...which is more dense than usual. : )
  8. Greets, and a happy, holiday season to all. This is one of those "Well, I could swear it _used_ to work..." FMP (PC) problems: I want a script to create a custom-named folder on the desktop (PC) [for exporting data purposes] so I used the following (see attached) Send Event command: "cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Backup" ) ...in earlier versions of FMP--and if memory serves--it used to work. (See https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ). However, when I try to run the script in FMP v17.x the script fails with the following error message in the Script Debugger, "[3] Command is unavailable (for example, wrong operating system or mode)". So, I'm trying to figure out why the command's failing--could it possibly be it's because I'm using FMP (PC) in VMWare's Fusion PC emulator (v10.1.4, running in OS Mojave) instead of on a "real" PC? Any ideas for a tweak/fix? Cheers, Rich
  9. Thanks, as always, for your reply. I apologize for my poor explanation skills. To put it succinctly, I want to avoid using dozens of test-for-IsEmpty-and summary fields (per table, and there are fourteen tables), just to give a go-/no-go flags for reports to print. You're right in that e-SQL's out since it would be problemetic dealing with found sets. I just finished making a looping script but there's a big performance hit when it comes to thousands of records to plow through. However, it just occurred to me while writing this post that a "simple" solution would be an extension of what I posted earlier, to have just two fields per table: one that would be a calculation field with a litany of Case statements to test for each report's minimum field requirement, and the other a summary field of the calculated field. I could then use a very simple script to act as a switchboard to select which report to run based on a global field that has a drop-down menu of report titles; the aforementioned calculation field's result will be based on what's in the global field. Time to get coding!
  10. Greets, all: I have a dozens of print-related scripts but I want to use scripts--instead of using scores of hard-coded calculation and summary fields--to test for the presence of values within fields both in same table and parent-child table fields--so if not all the required fields for a particular printout have values, either in the current record or anywhere in the found set, it's flagged and another script notifies the user that none of the (found) records meet the required minimum field value requirement. Is there an elegant way to do this all in scripts or am I stuck using calculation and summary fields? ( The calculation field sets up the test with a result of 1 or 0 and the summary field sums the calculated fields--if the sum is zero the user is shown the error message. TIA for your help!
  11. I'm having similar problems with Adjust Window in v17 (Mac)—the layouts won't resize even with Adjust Window [Resize to Fit] entered in a resizing script mulitple times. It also acts flaky between user privileges, too--Admin, no problem, but any other privilege and it won't work correctly. I found a temporary way around the problem by creating a standalone script that has just one instruction: Adjust Window [Resize to Fit]. So, in the resizing scripts I have, I've replaced the instruction Adjust Window with Perform Script [Resize_to_Fit] and that works.
  12. Just a quick follow-up: From the parent table, can that calc be tweaked so it will detect if there's more than one of the same value in the child table? ...or a native FileMaker Pro calc which will detect of any of the children's records aren't unique per their relationship with the parent record? It could be a litmus test of "Are all values unique? True/False."
  13. Beauty! Thanks!! I have the FileMaker SQL guides but I'll have to find additional references to help with my SQL education; I never would've gotten the syntax right (now) not knowing about the missing parameter. Because JOB_KEYWORD_JOB is so long, I thought I'd use an alias of it, JKJ, once the calc was nailed down.
  14. Greets, all: I _thought_ this would be simple: signal users that the value they're inputting into a field--in a portal--is a dupe. (For the incredibly lazy who won't scroll through the portal records, first, to see if the value's already there.) I figure a counting function ought to do it--with a count of greater than one, that would set a message window fired by a script trigger. I know I'm close but for some reason I just can't nail it: The calc is in the child table, JOB_KEYWORD_JOB ; the value field to test is Keyword__lxt; the foreign key is _kflt__JobID. I figure I'd count those values with the same foreign keys and keyword and that would give me the answer I need, no? ExecuteSQL ( "SELECT COUNT ( Keyword__lxt ) FROM JOB_KEYWORD_JOB JKJ WHERE Keyword__lxt = ? AND \"_kflt__JobID\" = ? " ; "" ; "" ; Keyword__lxt ) ...but that doesn't work; I'm sure a minor tweak will fix it but I've run out of tweaks. : S Of course, I tend to make things more difficult than necessary so if there's an easier way to accomplish the same goal, I'd appreciate it! Ciao, Rich
×

Important Information

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