Jump to content

Rich

Members
  • Content Count

    97
  • Joined

  • Last visited

Community Reputation

3 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
    18

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Mojave

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

1,159 profile views
  1. I do, but I still don't get how individual records are created since there's no part of the script--that I can tell--that creates individual records in Interface. That, and I can't see how the RecordNo field (in the Interface table) becomes populated with a record number(?) *heavy sigh* Time for more coffee.
  2. Greets, all: I downloaded this instructional file (https://www.seedcode.com/virtual-list/) to learn about virtual lists and I'm stuck trying to understand how part of it works, so maybe the wizened among you can explain it to simpleton moi; I'm in the corner wearing the pointed hat. After the Contacts script runs, the Interface Records layout is populated with records from $$VarContent, but I can't figure out how that layout gets populated with individual records from $$VarContent; the data within that global variable is return delimited, so how does it from that to individual records? VirtualList.fmp12
  3. 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
  4. 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.
  5. 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!
  6. 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?
  7. 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!
  8. 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
  9. Thanks for the suggestions! Cheers, Rich
  10. (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!
  11. 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!
  12. 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.
  13. 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.
×
×
  • Create New...

Important Information

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