OnTheOutside

It's too bad nobody has answered this one. I would also very much like to know how to track which scripts aren't being used so I can clean them out. I came up with something clunky, but it does work. If you create a new table called "ScriptUse" and make fields IDNum (autonum), scriptname (txt), dateused (creation date), then you can put a series of steps in EACH of your existing scripts. The steps essentially write a new record in "ScriptUse" with the name of the scripts captured from 'Insert calculated result: Get(scriptname)'. I tried to make this a subscript step and just add THAT to each script, but then it would only get the name of the subscript, not the main one I was trying to track. I'm certain that somebody more clever than I can improve on this.

Greetings, I am trying to run an Applescript from within FM8 to create a folder on our server "automatically" with the name of the applicant so that we can add related documents to it. The folder gets created, but I can't figure out the syntax for making FM feed in the applicant data for the folder name. Can anyone give me a hand? Applescript: ------------------------ tell application "Finder" activate select Finder window 1 select Finder window 1 set target of Finder window 1 to disk "Groups" select Finder window 1 select Finder window 1 set target of Finder window 1 to folder "Applicant Group" of disk "Groups" clean up Finder window 1 by kind select Finder window 1 select Finder window 1 set target of Finder window 1 to folder "2007 Admissions" of folder "Applicant Group" of disk "Groups" clean up Finder window 1 by kind select Finder window 1 select Finder window 1 set target of Finder window 1 to folder "2007 Applicant Correspondence" of folder "2007 Admissions" of folder "Applicant Group" of disk "Groups" select Finder window 1 make new folder at folder "2007 Applicant Correspondence" of folder "2007 Admissions" of folder "Applicant Group" of disk "Groups" with properties {name:"LASTNAME, FIRSTNAME APPLICANT"} end tell ------------------------ Just above here is the hardcoded name of the folder, what I need is how to get: Applicant::LastName &", " Applicant::FirstName & Applicant::ApplicantNum ...into there correctly. Any help with this syntax? Thanks in advance.

Thanks, but a subsummary report does not provide statistics on several different fields in the same report. I need things like: -"how many ethnic students and how many of each" AND -"how many military applicants & which branch" AND -"how many economically disadvantaged students applied" AND -"How many of what type of visa" AND etc., etc. The subsummary reporting seems to me to require a separate report for each item you need stats on. Is this wrong?

Greetings, I need to have statistical calc field which can count up the number of records that have a certain value in a specific field. Example: field= Student::ethnic possible values= asian, caucasian, black, hispanic I need another calc field which will total each of the different choices in the found set (Student::Cstat_ethnic). Can you help with the If/Case statement to make this work? I have several other fields to do the same with, but if I get one working then they should all work to create dynamic stats on the found set. Thanks in advance.

I've had difficulties in the past with this, so I'm not surprised I wound up back here to get a hint. My organization sends students out to different sites to receive different types of training (TrainType). Where The TrainType is = "Nutritional Counseling" (for example), I can match up Students:studentID = TrainingSession:studentID AND TrainingSession:TrainType = k_NutritionalCounseling (k_NutritionalCounseling is just a text calculation = "Nutritional Counseling"). This is working. The problem I have is that I want to make a portal (table view) of TrainingSession that EXCLUDES students who have graduated (table_view_TS#NotGrad). The example file should be more clear than I can write here. Please let me know if you have a suggestion. NotGrad.fp7.zip

This last suggestion worked out great. Thanks for getting me unstuck.

There is a field called "ReviewerOpinion" and it is a radio option. Choices are "Interview", "Reject" or "Undecided". The reviewer has some other fields to put in a score, but the only thing I'm concerned with is if I get 1 "Interview" and 1 %anything else%. This would be a "disagree".

Greetings, I can't seem to find a good way to do this, lack of experience, I'm sure. I have a database of Applicants, I have some Reviewers in another table, I have a bridge table Applicant_intvscore_Reviewer so that I can assign 2 reviewers to each applicant. When the reviewers disagree on whether to accept or deny the applicant, I assign a third reviewer as a tie-breaker. What I need is to KNOW when there is a disagreement so that I can assign the applicant to another Reviewer for a tie-breaker. I tried making a dup_check (applicantNum & ReviewerOpinion), search for that and then show omitted, but I get where one Reviewer has made a decision and the other hasn't made a decision yet, in addition to disagreements. It'd be best to just show a line for each applicant that says "disagree" and then I can GTRR to that applicant's record to assign another reviewer. Thanks for any thoughts...

OMG!@ Thanks so much. This is exactly what I needed. Thanks so much for the example; now I know how to do this myself.

Greetings, I have an ENORMOUS database (16 million records, only two related tables). "AcctNbr" ties the two together. The problem is that there are records for the same accountnumbers in the Accounts table, one was created for every year the account was open, "AcctNbr"=1, "BillYr"=1998, "AcctNbr"=1, "BillYr"=1999, "AcctNbr"=1, "BillYr"=2000, "AcctNbr"=1, "BillYr"=2001 What I need to do is this: 1) Show records with duplicate "AcctNbr" and then show only the "top 1" ("top 1" refers to the 'most recent year'. In the above example it would only show me the record for "AcctNbr"=1, "BillYr"=2001--everything else should be hidden/deleted. 2) [i can handle this part], Show all records that don't have dupe AcctNbr and preserve these so they don't get deleted when doing the above search. It is something like FIND "AcctNbr"=! & then "BillYr"=%ExcludeAllButTheMostRecentYear% Help, suggestions?

I'd like to do this too, but I'm not sure how. I have the same multiple table, multiple layouts thing going on. Imagine an Invoicing system where you are looking at a particular customer, then look up an Invoice and go back to the Customer screen and have to search for the customer you were just looking at. It seems I could do a sub-script to get the current RecordID for each table and store them each in a global, then when someone went back to a layout they had previously been on then it would feed the global value as the record to go to for that table/layout. ...?

I was able to solve my own problem, I fussed with OSX Server. Create the LDAP groups and add users to groups in OSX Server, then in FM7 just use External authentication and type in the name of the group...voila!

We have the same issues. We are often doing crazy workarounds such as saving as pdf, then reducing PDF size via Acrobat Pro or just printing one page at a time direct from FM. Our HP 4050 printers were upgraded to max memory, we routed print jobs thru a print server and we still have this issue. We also get 79.000 errors which are non-specific memory problems on HP LaserJet printers. Egad! Does anyone have suggestions?

Greeetings, I have a heck of a time printing large, complex "reports" so as a bandaid fix, I created a script to save what I want to a pdf. This is acceptable, however, it'd be great if I could get a dialog to come up that asks the user what they want to call the report. It currently saves the .pdf to their Desktop as "FileMakerPrintout.pdf" and will overwrite the last file if it is not renamed. "Printing Problems script" Print Setup Print (as pdf) [Restore, no dialog] Custom Dialog: "Your print job is on the Desktop, called "FileMakerPrintout.pdf" The PRINT command needs to be no dialog because my users will not remember to save as PDF, too many steps. Thanks in advance for your suggestions.

I have worked with the HELP and Admin Guide for FM 7 Server and cannot get the FM Server to register with my OD running on OSX. Anybody had success at this willing to lend a hand? I have made matching entries in Server config and client 'List by LDAP'-"Specify" dialog dc=%subdomain%,dc=%mydomain%,dc=fmp7 (where %subdomain% & %mydomain% are the actual names), however the server never shows up on the client when selecting List by LDAP--no problem with showing up under Local Hosts.

Awesome, thanks!

Apologies, I'm new. I have a database in FM7. I would like to exclude some records from showing up in a portal, but have those records that don't show, appear in a portal on the same page. Basically, we send out STUDENTS assigned to a SITEGUIDE to make VISITS to different SITES, one table for each. Anyway, there are different kinds of visits, but they all are recorded in the VISITS table--each record has a VisitID, StudentID, SiteGuideID, SiteID (pulled from SITEGUIDE). What I want is something akin to 'Show all Visits except attribute:TypeOfVisit="Special" in the first portal; in the second portal show ONLY Visit records where attribute:TypeOfVisit="Special". Is this possible in FM7? It is important that I keep ALL visits in the VISITS table even though I need it to appear to users as if there are Special visits separate from all of the other types of visits. Thanks in advance.