-dp-

Problem solved. As comment suspected, the problem was with the date field. The dates appear to be correct, but changing the format corrects the problem in the other fields. Thanks to both of you for your replies.

I have a tool with the following fields. studentDOB - a date field tracking birthdate studentDOBMonthName - a calculation field returning text result - MonthName (studentDOB) studentDOBMonthNumber - a calculation field returning number result - Month (studentDOB) The DOB field works fine. But the other two fields return question marks. This is an FMPA 17 file, hosted on FMS17, accessed on macOS 10.14.2. Any help would be appreciated.

I have a solution that includes student photos. The standard display is 4.5cm x 5.0cm. I would like to include a popover that displays an enlarged photo. But no matter how large I make the container, the photo remains 4.5x5.0. If I export the photo and open it in Preview, it's much larger. Any suggestions? Thanks. macOS 10.3.6 FMA 17.0.2.205 Photos are JPGs

Wow. How did I overlook this? The path of least resistance! Thank you, Josh.

Well. That would make a difference. I misread their site. Thank you.

Thank you, Lee. Using plug-ins to enhance Script Manager is an approach that had not occurred to me. I should perhaps have mentioned that I'm an in-house developer for a non-profit. At $150 each, the plug-ins are out of my reach, whereas a text editor is already in my budget. I could drop my current editor and switch to one that supports FM without affecting the bottom line.

I develop on a Mac (10.13.6) using FMPA 17. I would prefer to code in a text editor, and have recently become aware of the TextMate + FileMaker Bundle option. From my initial test drive, I prefer this environment to working in Script Workspace. But before I make the investment, I wanted to see if anyone has found an option that is better still. (The path of least resistance for me would be for FileMaker to be a language option in BBEdit, but I haven't been able to find that anywhere.) My primary desires for this coding environment would be choosing my own font (and size), code coloring, code folding, snippet expansion, and the ability to control everything from the keyboard without having to reach for the mouse. I would appreciate feedback from anyone who has found such an environment, and from anyone who has been using TextMate and can comment on that experience. Thanks.

I think I've found a satisfactory workaround. Thank you very much for your time.

Does this help?

I'm afraid that I don't follow. I can't hard-code specific statuses. That summary field is counting them on the fly.

I have a layout that includes two sub-summaries. The topmost includes a summary field called studentGradeCount, which counts the number of students in a given grade. The subordinate sub-summary contains applicationStatusCount, which is a summary field providing a count of applicationStatus. Adjacent to the status count, I would like to provide a percentage, indicating what percent of the students have applications at each status. Logically, it would be applicationStatusCount / studentGradeCount But FileMaker doesn't return anything when I attempt this. Any help would be appreciated. FMPA 16.0.3 macOS 10.13.3

I finally contacted FileMaker support about this. It turns out that I had the wrong version of Java. I had set the Java preference pane on the server to check automatically for updates, and was consequently suckered in when it popped a warning about an urgent security update. I was up to Java 151. I had to remove Java and run the latest FMS update, which installed Java 144, and restored access to my console.

I'm running FMS 16 on macOS 10.12.6. FMS is up and running, and I can access the hosted databases. But I can't get into the admin console. When I enter the credentials, it just sits there. It doesn't throw an error. It just doesn't react at all. Same thing when I intentionally enter an incorrect passcode. No error. Same behavior whether I use Firefox or Safari. Same behavior whether I try to come in remotely, or if I work directly from the server as localhost. So, something is wrong with web services rather than FMS, right?

That got it. I had the portal based on the wrong table. Thanks, LaRetta.

I’m attaching a cluster of screenshots that document a join table. All field are indexed. It looks correct to me, but I’m not able to enter groups in the portal. I can’t even access the field. Any help would be appreciated. Thanks. Join.zip