Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by comment

  1. How to show record number in sub-summary

    Use a summary field defined as Count of [any field that cannot be empty], Running count, Restart summary for each sorted group. That would create a conflict when two users want to produce different reports.
  2. How about = MEDIASIZE * If ( PatternCount ( MEDIASIZE ; "GB" ) ; 1024 ; 1 )
  3. Hide Object based on Field Value and Permission

    I agree. There is a big red flag waving over this question. If this is an attempt to deny some users access to some records, then it's bad practice and wholly unsafe.
  4. multi files

    This is also why you should have a good reason to separate a solution into individual files. If you don't, consolidating it into a single file with multiple tables would seem to be the simplest solution.
  5. Returning a field from latest record

    Have a look at the Last() function. Note that the order of related records can be changed by sorting the relationship. If you sort the related records by date, descending, the latest record will become the first related record and its fields can be referenced simply by their names (or displayed directly on the layout of the parent table).
  6. Perform AppleScript and Filemaker Pro 16

    Because of FMP 16 enhanced security. See the first one of "Tips on usage" here: http://www.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/perform-applescript-os-x.html
  7. If I understand your question correctly, you need to import your records (to a new table) multiple times, each time importing the title and one of unique combinations of size, color and short.
  8. Relating 2 DB using a range of timestamps

    Do you mean like this? Archive.zip
  9. Okay, I have managed to reproduce the problem. It's a bug. 1. How to work around the bug: Use Insert Calculated Result[] instead of Set Field[]. 2. How to avoid the bug: Save a copy of your file as clone (no records) and import the records into the clone. The new file's date format will be YYYY-MM-DD and your script will work. 3. How to avoid the bug and follow the best practice of not having your script depend on any date format: Make your script do: Enter Find Mode [] Set Field [ Calendar::calDate; Date ( Get (ScriptParameter) ; 1 ; Year ( Get (CurrentDate) ) ) & ".." & Date ( Get (ScriptParameter) + 1 ; 0 ; Year ( Get (CurrentDate) ) ) ] Perform Find [] where script parameter is a number between 1 and 12 (there's really no good reason to send the month name as text, then spend 12 lines of code converting it to a number).
  10. First thing, your file's date format is MM/DD/YYYY. It is set to always use the current system's setting. Are you sure your OS short date format is YYYY-MM-DD? Because if it isn't, that would explain the described behavior.
  11. Could you post a copy of your file with only the date field, the buttons and the script?
  12. I mean perform the script in your file that does "Save a Copy as" .
  13. You're not showing us how the $_range variable is being defined, so there's very little we can say. We also need to know what date format your file is using.
  14. Actually, there were at least four of them: EventScript, DoScript, zippScript and FMI's own plugin example.
  15. You could use the OS scheduler to open a file that does nothing but call a backup script in your "real" file.
  16. Middle letters? Possible?

    Try = Right ( Yourfield ; Length ( Yourfield ) - 2 )
  17. Try the Middle() function: Middle ( full_ticket_number ; 3 ; Length ( full_ticket_number ) - 3 ) If all ticket numbers have the same length, you can shorten it to: Middle ( full_ticket_number ; 3 ; 13 )
  18. Couldn't you simply place the portal in a popover and keep the existing functionality? If you really must go with a popup menu, then define your value list to use values from the URL field, also display values from the Value field, show values only from second field. That way your global field will actually contain the selected URL. Consider also http://www.briandunning.com/cf/908.
  19. Script to send email based on date field

    There is no way you can tell Filemaker to watch a date field and run a script when it passes some threshold. The best that you can do is run a script every day on startup, find the records that have passed the threshold and send the notification/s. You will also want to mark these records and exclude marked records from the find. That way you won't skip a bunch of records when the script did not run for some reason (e.g. on a holiday) nor send a notification twice if you restart.
  20. I presume you create the HTML file by exporting as XML with a custom XSLT stylesheet?
  21. Exporting to Excel with Formatting

    Actually it does mention 360Works' Scribe. This has very little to do with the main topic here. In any case, only fields selected in the export field order are exported. There is no way to point the export to the portal - you need to replicate the choice in both places.
  22. Exporting to Excel with Formatting

    See a previous discussion on the same topic: https://fmforums.com/topic/100534-creating-an-excel-file-from-filemaker-data/
  23. Let me add a general note: Portal filtering is slow - and will get progressively slower as the number of records to filter grows. It is much more efficient to filter the relationship itself. You may think it's not possible because it would require an unstored calculation to serve as the match field on the portal side. However, that is not true: you can define a stored calculation field in the Services table as = Next Service Date - Day ( Next Service Date ) + 1 and use it as the match field opposite an unstored calculation field of = Get (CurrentDate) - Day ( Get (CurrentDate) ) + 1 in the dashboard table, to make only records in the current month related.
  24. The calculation field would be in the dashboard table. However, such calculation field cannot duplicate your filtering expression. How about a different strategy: define a summary field in the portal table as Count of [ primary key field ]. Merge this field in the button text, and place the entire button within a one-row portal to the same TO, filtered by the same expression. Note that a side effect of this is that the button will disappear if there are no records shown in the portal.
  25. You can merge a calculation field within the button text. Therefore the real question is whether a calculation field can determine the number of records shown in a portal. I suspect your portals are filtered, so it's difficult to answer without seeing the filtering expressions. If they're not, it's a simple matter of = Count ( PortalTO::MatchField ).

Important Information

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