Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


BruceR last won the day on February 3

BruceR had the most liked content!

Community Reputation

160 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

34,221 profile views
  1. Get(ActiveFieldName)

    Where is your actual script? How are you triggering the script? Can you show us your file or a simple example file? There will need to be a second step in the script so you can stop in debugger and look at the variable contents before the script ends. Since you are using a script variable ( single $ variable) it will always be empty after the script runs. While this is something you should be able to do successfully - in real life, what do you want to do with $fieldName?
  2. WHICH two layouts? No, they are not independent of each other. They are based on the same table. Your entire premise here has been to do something "not the parent" which makes no sense, and you have been unable to explain.
  3. Selecting unique records

    What does select mean - to you? And after "selecting" - what is next? What are you actually trying to do?
  4. Find multiple words in Value List

    Doug, there is a very important omission in your script. After the first Perform Find, you need to re-enter Find Mode. Otherwise; you're changing data in the current record. And you probably want to add some error trapping. Also: not sure what's up with your square brackets in the set field statements. I removed them here. Enter Find Mode [] Set Field [template::year ; 2018] Set Field [template::InParentDiary; 1] Set Error Capture [ On ] Perform Find [] If [ get( lastError) = 0 ] Enter Find Mode [] Set Field [template::season ; "spring"] New Record/Request Set Field [template::season ; "summer"] Constrain Found Set [] End If
  5. Find multiple words in Value List

    Basically you are declaring: you tried something and it didn't work. What exactly does your script look like? Since you have return-separated values (from a checkbox field) you are going to have to create multi-step script.
  6. May I suggest that you work with this version going forward. It clarifies key field names, reorganizes the graph, and eliminates "portal" from any table or relationship names. The TO may be used in a portal. But labeling the TO as someThing_someThingPortal hides actual relational concepts. Test File DemoJOBR.fmp12
  7. Here's cleaned up graph screenshot though.
  8. That isn't the way it looks to me. Looking at your description and your file is like looking at what used to be a functioning car. Now the spare tire is in the back seat; the steering wheel is attached to the left fender; and the windshield wiper are attached to the passenger door handle. No, I don't understand your vision of where you're going with your file. No, I don't think the solution is simple.
  9. It's a mess. The "Library" and "Album" and "Song" tables are the same table. You don't have a separate Song table. The Song Title is set to always auto-enter "" into itself. There are established solutions which do this.
  10. Your request makes no sense. You cannot print in layout mode. For that matter; you cannot click a button in layout mode; and you cannot enter data into a field; global or otherwise; in layout mode. It is extremely difficult to understand what you are trying to do. If you can attach your file; or a clone of your file; it would help.
  11. 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?
  12. 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?
  13. 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
  14. 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.

Important Information

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