-dp-

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

Duh. How embarrassing. But with that correction, it works perfectly. Thanks very much to everyone who helped.

Thank you very much for troubleshooting this, and for suggesting so efficient a correction to my code verbosity. I implemented all of your suggestions. I created a clone and imported. I changed Set Field to Insert Calculated Result. I changed the calculation to the one you suggested. It's still broken, but we're making progress. I can see what's happening in the debugger. It's entering only the first date in the calculation. For example, if I click on March, it enters "2017-03-01...?" So, it's not resolving the second half of the calculation. Here's a copy/paste of exactly what I entered. Date ( Get ( ScriptParameter ) ; 1 ; Year ( Get ( CurrentDate ) ) ) & "..." & Date ( Get ( ScriptParameter ) + 1 ; 0 ; Get ( CurrentDate ) )

My short date format is set to YYYY-MM-DD. I've attached a screenshot.

See attached. I've deleted all but the relevant layout and script.Thanks. Organizer Copy.fmp12

I didn’t know that I could leave the day out of the query. Thanks for the education. The date format is yyyy-mm-dd. Here’s the whole script thus far. ===== Set Variable [ $_year ; Value: Year (Get ( CurrentDate ) )]. /* I haven’t yet started working through what to do if the month is in the next calendar year. */ Set Variable [ $_range ; Value: Case ( Get ( ScriptParameter ) = "Jan"; $_year & "-01"; Get ( ScriptParameter ) = "Feb"; $_year & "-02"; Get ( ScriptParameter ) = "Mar"; $_year & "-03"; Get ( ScriptParameter ) = "Apr"; $_year & "-04"; Get ( ScriptParameter ) = "May"; $_year & "-05"; Get ( ScriptParameter ) = "Jun"; $_year & "-06"; Get ( ScriptParameter ) = "Jul"; $_year & "-07"; Get ( ScriptParameter ) = "Aug"; $_year & "-08"; Get ( ScriptParameter ) = "Sep"; $_year & "-09"; Get ( ScriptParameter ) = "Oct"; $_year & "-10"; Get ( ScriptParameter ) = "Nov"; $_year & "-11"; Get ( ScriptParameter ) = "Dec"; $_year & "-12"; "" )] Enter Find Mode [ Pause: Off ] Set Field [ Calendar::calDate; $_range ] Perform Find [ ] ===== When I run it through the debugger, I can see that it’s building the variables correctly, but it’s not populating the calDate field in the Set Field step. I tried using Set Field [ Calendar::calDate; “\” & $_range & \”” ] but it returned the same error. The error is 500, but I don’t know if validation fails because it doesn’t like what I’m unsuccessfully *trying* to enter, or if it’s not entering anything, which therefore fails validation.

I’m trying to create an interface that will find all entries in the month specified in the script parameter. If the user selects the Sep button, I want the script to query a date field for “2017-09-01…2017-09-30”. This works correctly when I do it manually, and a case statement correctly builds this string in the variable $_range. But when I try to script the query as follows: Enter Find Mode [Pause: Off] Set Field [Calendar::calDate; $_range] Perform Find [ ] it consistently throws a 500 error, even though I’ve set no validation restrictions. Set Field [Calendar::calDate; “\” & $_range & \””] does not resolve the problem. Can anyone troubleshoot this, or suggest an entirely better method? Thanks, dp

This is helpful. Thank you for taking the time to reply, and for providing the example.