Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


BruceR last won the day on December 14

BruceR had the most liked content!

Community Reputation

155 Excellent


About BruceR

  • Rank

Profile Information

  • Gender
  • Location
    Redmond WA

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Sierra and El Cap

Recent Profile Visitors

33,799 profile views
  1. Then I don’t understand what you are trying to do. If you are in browse mode; and the found set is not zero; then the script should always run? What initiates the script? User clicks button?
  2. You have not defined what it means for a record to be “selected “. Neither we nor Scriptmaker know what you want. How is a “selected” record different from the current record?
  3. Portal, layout or relationship

    Here it is again (hopefully). Reason for CREATE relationship: The existing relationship leave a non-functioning ghost bottom row in the portal. WTC_v_1_2017-18_TEST_ModBFR.fmp12.zip
  4. Portal, layout or relationship

    1. Try skinnier padding. 2. Your script doesn't check for empty Student ID. 3. Change the graph to add a CREATE relation

    The thread there is 21 posts long, with many specific specific suggestions and specific questions. At this point it ends with a specific question for you; that remains unanswered. This forum does have some great tips on how to ask a question; and perhaps Lee will provide that link. Since you have an important business requirement that you can't currently implement on your own, you might consider paying somebody to do this for you.

    Apparently an [xpost] with FileMaker Community, where more progress has already been made. https://community.filemaker.com/thread/98378
  7. Indeed, as Lee mentions, comparable??? You haven't yet described anything about your project, so more detail, made public here, will be helpful.
  8. ( year( get( currentdate)) - Date of Hire) & " Years"
  9. Middle letters? Possible?

    Then you want the Middle function. I think that Comment provided exactly the answer you wanted recently here. But maybe that was somebody else; or over in a different forum. Anyway: https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help%2Fmiddle.html Middle Purpose Extracts the specified numberOfCharacters from text, starting at the specified character position. Format Middle(text; start; numberOfCharacters)
  10. No; it is not possible with Pro. You can do it on demand. If you want schedules; you want Server.
  11. That seems like an extremely odd reason to move away from FileMaker Server. Scheduled backups are one of its prime, easiest to use features. FileMaker Server can make backups for you; including full backups; and clones.
  12. Portal for DataEntry/Ingredients of recipes

    Attached is a modified version of your file with a few of the errors corrected. Steve mentioned some of your errors; including putting foreign keys in the Recipe table, instead of the Recipe_lines table. Also, you had set up all your relationships to be cartesian relationships ("X" relationships) That means "put everything everywhere." You don't want to do that. 2017_09_Essensplan_MODBFR.fmp12.zip
  13. Portal for DataEntry/Ingredients of recipes

    HJS: it may be your desire that this be a simple exercise. That doesn't make it a reality. Lee: that said; I don't think this is a useful starting point.
  14. Portal for DataEntry/Ingredients of recipes

    Lee: I tried a search and got "hits" but actually did not find anything useful. If somebody has done a search and found relevant examples, then it would be helpful to link directly to those "curated" examples. Unfortunately - yes, that does mean a bit more work.
  15. better way to go through data

    Different game. OK; how so? You do not seem to have actually revealed the performance stats for parsing. XML import took 5 seconds. JSON parsing was; somewhere wandering a different ballpark. Buying hotdogs with Applepay. Specifically, completion of JSON parsing took .... ?

Important Information

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