Jump to content


  • Posts

  • Joined

  • Last visited

FileMaker Experience

  • Skill Level
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Windows 7 Ultimate

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Jim65's Achievements


Rookie (2/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. comment, Thank you very much for your help. I looked at the file and tried to understand it from the point of view of my file. I got it to work exactly like I had hoped! Thanks again, Jim
  2. The Id connects the student table to a rank table. It's true that one rank has many students so maybe I just stated it incorrectly. In the Rank table is what's called kyu and dan ranks. These correspond to colors. Many of the colors have sub ranks but only one color that's why I was searching by color. My script goes to the students table, finds all of the Active students then looks for a color that I entered into the 'EmailFind' field. It then 'Finds' those students. It works fine if I only search for one color or all but not for just 2 or 3 colors. Sorry, I'm gonna be late! Thanks, Jim
  3. Students::StudentsIdPk to Ranks::StudentIdFk I currently have the search field (EmailFind) on my Main Menu layout. It is a txt field set to global storage. I'm thinking the checkbox would work but I'll be darned if I can figure it out. I don't like to make excuses but I am getting old! I have to go teach class right now and won't be back until after 8 EDT tonight. I apologize. Thanks, Jim
  4. The example certainly does find whatever I check but I'm lost as to how to implement it into my file. Instead of entering the list of states I need to find my already existing ranks? I truly have no clue? I also wondered why I could download the file from you but not on my own. The links are different: https://fmforums.com/applications/core/interface/file/attachment.php?id=24674 - the link you sent me. http://fmforums.com/applications/core/interface/file/attachment.php?id=24674 - the link in the article. It's missing the s on the end of http Thanks for your help but I'm going to need more guidance if you don't mind. My ranks are stored in a table named Ranks Students are in Students My search field is EmailFind and it is global Using a checkbox is ok since I only have 7 different color belts. Thank you.
  5. Thanks, I'll check it out. When I click the link in the article it doesn't do anything. But yours worked. Much appreciated.
  6. I look at that thread but couldn't download the file?
  7. No. I want to find students that have a black belt AND other students that have an orange belt or all the brown belts, all the purple belts and all the green belts. Then send this found set an email. The RankColor is: Black Brown Purple Green Orange Yellow White Occasionally I have to send out emails to only one group of them or several. Everyone except a white belt will have earned the other belts up to black. But each student only has one current belt color.
  8. comment, I don't have the belt colors in EmailFind. That is a search field I use to find students to send emails to. I need to find everyone that has a, say black belt and the ones that have maybe an orange belt not either but both. Or yellow and brown or black and purple and yellow and so on. The script I have is: If isempty (students:EmailFind) Beep Show Custom Dialog - Warning goes here Go to field Students::EmailFind Halt script End If Got to layout - students layout set error capture on Enter find mode set field students::RankColor ; students:EmailFind Perform Find Send Mail Send via email client Yada, Yada. This is a representation of the script. There are many typing errors but I think it covers the basics. It finds any individual color that I enter into EmailFind field and a range if I enter Black...Yellow or * for all but the range of Black...Yellow includes all of the belts due to the Filemaker's Find when I may only want black and yellow. I hope this is a bit clearer. I tried the New Record Request but can't seem to make it work. Thanks.
  9. Hi! Thanks for taking the time to try and help me. I have a script that uses a field named EmailFind. If I enter a karate belt color such as Black it finds all of the students that have a black belt and I can then send them an email. That works fine. However, if I wanted to find, say, all of the black belts and yellow belts I type in black...yellow and it finds every belt starting with a b through a y. I understand this is how Filemaker searches. Is there a way I can pick 1, 2 or more colors (the names for the colors) and only find those? Any help is greatly appreciated. Jim
  10. Steve, Thank you for your time and input. Without actually showing me where the issue is with the way I'm doing things it's difficult to learn to do better. I can't hire someone - that's why I'm asking the forum for help. This 'version' of my file is of one that started with Filemaker 8 so it's come a long way also. I'm sure there's ways to do things better and I do try when I'm shown. This old dog can learn new tricks when taught! That said I'd like to mark this as closed as I've figured out what was wrong with what I had already set up and have gotten it to work exactly like I wanted. I had a relationship id incorrect and I needed to add 2 more fields to connect the dates of my dues fields and such with the month/year on the attendance sheet so they showed only the data created during those months/years. I re-uploaded the corrected file. Specific advice and hand holding on anything is always greatly appreciated. Thanks, Jim Attendance.zip
  11. Lee, I am attaching a copy of my file. To create a record for the payment of dues and such you need to go to the Students Information layout and click the Payments tab. Click the New Payment button and click on what was paid - Dues, Clinic, Exam or ISKF. Then go back to the Main Menu and click on Print Attendance. This the layout I want that information to show. To change the Month and year of this layout you need to go to the Administration Menu and click on the Month and Year drop downs where it says Select - Month/Year. This runs a script that updates the information and takes you back to the Attendance layout. Hope this makes sense. I realize that by putting my file up for help it will also receive a lot of criticism for how it's created. I will take all and any help I can get. This file is used only by me and for a very small martial arts dojo that I own. It doesn't have to be fancy but it does need to be accurate! Thanks for everything, Jim
  12. Long winded but hopefully descriptive enough to describe my problem. I have the following Tables: Students Ledger Ledger_Chgs Ledger_Pay Ledger_Self They are connected as such Students table to Ledger table - StudentIdPk > StudentIdFk Students table to Ledger_Chgs table - StudentIdChgs > StudentIdChgs Students table to Ledger_Pay table - StudentIdPay > StudentIdPay Ledger_Self table to Ledger_Chgs table - StudentIdFk > StudentIdFk These are all used with a layout called Students. In my students layout I have a portal to Ledger_Pay (and Ledger_Chgs but that's not an issue) In this portal I can create a new record and record the students payments. This works really well. I also have 4 other text fields (DuesPaid, Clinic Paid, Exam Paid and ISKF paid) than I mark either Pd or leave blank when I take their dues or other payments. Here's my problem I have another layout (Attendance) not based on these tables but on TO's that shows the students name, attendance daily for the month and phone numbers. I also have text fields for the above mentioned text fields - DuesPaid, Clinic Paid, Exam Paid and ISKF paid that I have been filling in on this layout too. Double work and double the chance for a mistake. I can get the fields to show on this layout from the Ledger_Pay table but not for the correct month/year. When I script a FIND I can go to the Ledger Table and get the correct Month and Year using varibles based on g_Month and g_Year but when I go the the Attendance layout it always shows the last recorded created unless I sort differently. I want to be able to pull up these records for the correct month/year at any time, not just when the month is current. I'm not trying to get fancy financial software or complex book keeping, just to show the records created in one place to display in another. I do have the attendance table connected to a TO of the Ledger_Pay TO but can't get past what will probably be simple to most everyone but me. Thank you for any and all help, Jim
  • Create New...

Important Information

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