Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by BruceR

  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 .... ?
  16. Help with relationship

    But you already know this answer. You cannot use the quantity part either, due to the unstored calc.
  17. Help with relationship

    This makes no sense.
  18. Display active portal row

    As recommended by Comment: in the original window, do not ever leave the original layout. Open a NEW window. Do what you want there. CLOSE the new window when done. Get to this new window however you want. You said you did this. It is obvious from your reply that you did NOT.
  19. Help with relationship

    That is the correct result. Why is this field involved in the relationship? And - for that matter; why is CONSTANT involved in the relationship?
  20. Display active portal row

    Delete that script. You don't seem to have actually followed the suggestion. See attached. portal row edit.fmp12.zip
  21. I'm in a bad relationship

    True; and also ... Layout #5 has the correct table occurrence but still shows the problem, due to the other issue (invalid field ref). And once the table occurrence for layout MONTHLY DISTRIBUTION SHEET is straightened out, the problem still exists on that layout; because of the bad field ref. [edited]
  22. I'm in a bad relationship

    There is nothing wrong with the merge expression. The text block in question is actually a GROUP; and part of the group is an invalid field.
  23. Comment, a request for clarification. Perhaps I missed something. I understand how "Greens" will not be a match, when using the return-separated list, filterValues approach. But it seems to me that "Green" would match "Green"
  24. Deleting rows leaves button behind

    NA. If you look at the file provided - you will not that allow create is not turned on. Ben: switch WHAT off/on?
  25. Deleting rows leaves button behind

    1. I don't experience that problem. 2. But let's be sure we're clear on what you mean by "delete a record". When you delete a parent (Client) record? When delete one of the Note or Document records?

Important Information

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