comment

You could have deduced this from the answer to your previous question. The date of the first Monday in a given month is = Let ( [ firstDayOfMonth = Date ( Month ; 1 ; Year ) ; diff = 2 - DayOfWeek ( firstDayOfMonth ) ] ; firstDayOfMonth + Mod ( diff ; 7 ) )

Not sure what your question is. Both printing and saving records as PDF use the page size selected in Page Setup. You can select a custom page size (at least on a Mac you can), if you want.

I am afraid this is still not clear enough. You did not mention a list until now. A return-separated list of values is not the same thing as paragraph of words (even if your list contains only single-word values). Anyway, it sounds like you want to go over a list of values, and remove a value if it contains the string HOME (case-sensitive) - is that correct?

Yes, it's possible. Tell us more. Is your search case-sensitive? What about words that contain the string "home" e.g. "homeless" or "psychometric"?

Do you mean an .ics file?

You would have to define each button individually, with the specific field being hard-coded in the Set Field[] script step.

That is correct: you need to use a script parameter to identify the field. Or attach a single-step action to each button.

That is the nature of the hack you have devised: a script triggered OnObjectEnter runs after entering the field - and while a field is active it will display its contents unformatted. If you use a button instead, the field won't be entered at all and you won't see the raw contents. What is the purpose of these boxes?

Yes, it's corrupted. Throw it away and go back to the last good backup.

Well, I only had a few minutes to look at it, but I believe this is basically how I would approach this: D'Hondt.fmp12 This takes the data from the example in the Wikipedia article and, AFAICT, arrives at the same results.

It may be classic to you, but this is first time I've heard of it, at least by that name (spelling it correctly would also help ). And glancing at the Wikipedia article, I see no mention of "rank" - so it's not clear to me what exactly you're talking about. Are you trying to calculate the number of seats based on the votes received? This may be possible in Filemaker, but I get the impression Excel would be a far better tool for this.

I think so too. I don't know what your data represents, but I am quite sure you should have records in a related table instead of numbered fields. Fields cannot be sorted, records can.

Get (ActiveFieldName) gets the field's name. You want to modify the field's value, so set the field to = Abs ( Get ( ActiveFieldContents ) - 1 ) or simply = not Get ( ActiveFieldContents )

There is no Rank() function in Filemaker. You can calculate rank on your own. The exact method depends on whether you want to calculate the rank based on the found set or the entire table, and a few other factors (e.g. ascending or descending). The attached file shows how you can calculate rank based on the found set, descending. Note that duplicates are ranked the same, and the corresponding ranks are skipped. Records do not need to be sorted. Requires version 16. Rank_v16.fmp12

What is the eventual purpose of making these selections? If it's just for viewing, then you don't need any additional tables - only 3 global fields and a couple of additional occurrences of the existing table.