Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


comment last won the day on August 16

comment had the most liked content!

Community Reputation

1,382 Excellent

About comment

  • Rank

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  1. First Monday Calculation

    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 ) )
  2. Layout Sizing

    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.
  3. Find and delete a word in a paragraph

    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?
  4. Find and delete a word in a paragraph

    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"?
  5. Add link to insert appointment to calendars

    Do you mean an .ics file?
  6. portable tickboxes

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

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

    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?
  9. Yes, it's corrupted. Throw it away and go back to the last good backup.
  10. Rank function

    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.
  11. Rank function

    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.
  12. Rank function

    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.
  13. portable tickboxes

    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 )
  14. Rank function

    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
  15. 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.

Important Information

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