Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

3 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

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

1,102 profile views
  1. Thanks--I'll take a look at Edoshin's Fast Summaries. Yeah, I originally thought about using a looping script but I got hung up trying to create the comma-separated field of RecordIDs; it just occurred to me that I can re-use/overwrite a dedicated/new text field with each loop of the script, adding ", " & RecordID to the calc. Cheers, Rich
  2. Sorry, I should've included it earlier: https://stackoverflow.com/questions/25042819/whats-the-sql-equivalent-of-a-filemaker-subsummary I used the second example; I excluded ROLLUP since I don't think it's supported in FSQL.
  3. Greets, all: I know FSQL isn't for creating documents, but tables, but this should be do-able: I have a single table (OJI) where I'm only concerned with two out of its many fields, Injury_Root_Cause and zz_RecordID. What I want to do is sub-summarize by Injury_Root_Cause and list each's respective (unique) zz_RecordID's under each heading--sorted in ascending order--horizontally listed and each zz_RecordID separated by a comma. So far, I have some of the calculation working: ExecuteSQL ( " SELECT zz_RecordID FROM OJI WHERE Injury_Root_Cause = 'Carelessness' ORDER BY zz_RecordID " ; "" ; ", " ) That works great for listing the zz_RecordIDs for one value, Carelessness, but it doesn't list the Injury_Root_Cause's value. I stumbled on one possible way of doing this by gutting an example on the 'net, but I got lost in the syntax so it doesn't work: ExecuteSQL ( " SELECT * FROM ( SELECT Injury_Root_Cause,zz_RecordID FROM OJI GROUP BY Injury_Root_Cause,zz_RecordID ) ORDER BY Injury_Root_Cause,zz_RecordID " ; "" ; ", " ) Soooooo, if you see where I need to tweak the calculation I'd greatly appreciate it. Cheers!
  4. Yes, that's later on, but how do I intitiate the auto-run of the script? Does Perform on Server automatically track the date/time while the file is sitting idle on FM Server?
  5. Greets, all: A simple question yet I can't seem to find a definitive answer: I want to have a script automatically run (in a hosted file on FM Server 18) on the last day of every semester that will create a report (which will be further scripted to be sent by e-mail to multiple users). What do I need to code/set up so the script will run autonomously? TIA for your replies!
  6. Greets, all: I'm sure this has been asked but after searching through 168 pages of this forum, I couldn't find an answer so it's on me that if this is a repeat question. Sorry. This involves FileMaker Pro v12 client and server on another company's machine in another location; I'm using a VPN to help out. I want to code a script to import a file from the user's desktop (in a folder named StuAdd; the filename is Full_Download.xlsx) but I don't know how to code the syntax for importing from either a Mac or PC to the file on the server. So far, I have: Case ( Abs ( Get ( SystemPlatform ) ) = 1 ; "filemac:" ; "filewin:" ) & Get ( DesktopPath ) & ...and that's as far as I got. I tried ...(Get (DesktopPath) & /StuAdd/Full_Download.xlsx, but that didn't work, so I need help with the syntax. One question off the top of my head is, with FMP v12.x being so dated, does it even recognize .xlsx as an extension? Cheers, Rich
  7. Thanks for the suggestions! Cheers, Rich
  8. (I apologize if this isn't the correct forum for this, so feel free to move it to the proper one, please.) I'm stuck. I built a solution with a parent-child portal setup, the user can see the four, court reservations for the day (Current Setup attachment). However, she'd like to be able to see a "big picture" view as depicted in the Capture 5 attachment. I figure a popover or a jump to another layout is in order, but beyond that I don't know how to pull this off schema-wise, especially when it comes to filling out a range of time slots shown in Capture 5, e.g., Court 1 would have the time slots 8:00 and 8:30 populated with Practice (Emilio Lizard), blank spaces from 9:00 am to 10:00 am, then from 10:00 am to 1:00 pm each half-hour time slot would have Practice (Emilio Lizardo)...and the rest of the time slots after 1:00 pm would be blank because there aren't any reservations for that court number. I thought of using four, repeating fields (one for each court) of 32 "slots" each that would span the 32 half-hour time slots from 6:00 am to 9:30 pm, but dealing with repeating fields with scripting to loop through each reservation to populate the appropriate slots...that's so ancient FileMaker Pro and it would be convoluted as all get out. (Note: since we're still using v.17, I can't get creative using the new scripting commands in v.18) If I could have some direction which way to go, I'd greatly appreciate it!
  9. Greets, all: I'm using this calculation--in a parent table in a field temporarily named 'Temp'--to grab course numbers from the course_number field in a related/child table: UniqueValues ( List ( ASSIGNMENT_COURSE::Course_Number__lxt ) ) (I'm using this calc because the child table contains multiple records with the same course number; it's not a key field.) My intent is to use six buttons--in the parent table--where each button would grab an assigned row's value using the calculation above. For example, say that the above calc has this result: AST-100 EDU-100 EDU-300 PHY-100 SOC-100 TMA-001 I want Button 1 to grab AST-100; Button 2 to grab EDU-100; Button 3 to grab EDU-300, etc. Mind you, I can't make a value list out of Temp because it can't be indexed. TIA for your help!
  10. That's a fair question, Darren, and also a sore point for developers who sell runtimes as a home/cottage business. Because that function will soon be deprecated, that will force some of us to give up that means of livelihood because we can't, in good conscience, sell a product that can no longer be supported long-term; that, too, is the subject of its own thread.
  11. Thanks for all the good info, guys. *blush* The typo with RESERVATON--good catch! Maybe it's time I update my trifocal prescription. (Getting old sucks!) I like the related matching global field suggestion--it's simple to be sure. (Thanks for reminding me about using SQL in scripts and not hard-coded in fields--I know the latter slows things down a lot.) Here's my logic for not using a Find--it would take fewer resources to "peek around the corner" to "see" a record/value than to go through the gyrations of finding, parsing, restoring, etc. Then again, I may be fooling myself since it's a small database with maybe 500 records at most (with only a handful of data fields), so I may be projecting a non-existant performance hit.
  12. I don't know--I get the dreaded question mark as a result. I suppose I could just perform a Find; part of this is hoping to learn e-SQL skills but I'm beginning to think that it may be beyond my ability.* (I tend to make things waaaay more complicated than they need to be. ...and thanks for the FM website update.) *"Check this out, Dad--I aced the I.Q. test by scoring a 100!"
  13. Howdy, all: Once again, I know I'm close but the syntax is getting the better of me. My goal is to use a global variable ($$_ProposedDate) to test against a date field (Date__lxd) in the same table (RESERVATION_PARENT) to see if a date has already been used. Here's what I have so far: Let ( TheDate = $$_ProposedDate ; ExecuteSQL ( " SELECT COUNT ( * ) FROM RESERVATON_PARENT WHERE Date__lxd = ? " ; "" ; "" ; TheDate ) ) If the count > 0, then I know the date has been used. Obviously, I'm missing something, but what? Along this calculation, I could swear there's a native FileMaker Pro way of doing the same thing--I hazily remember that by making the date field into a value list, one could "beat" a value against it to see if it's there or not but for the life of me, I can't remember how to do that. (Using ValueCount, maybe?) Anyway, it's good thing I have a bottle of Tylenol handy. TIA for your help! (On a completely different note--what's going on with FileMaker's site? None of the links online to the Community section work anymore.)
  • Create New...

Important Information

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