Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Kremlarkin

  • Rank
  • Birthday 06/19/1978
  1. help creating custom login system

    Manny, Why don't you just post a zipped copy of your solution to this thread? That way anyone who chooses to browse the thread will have access to your solution and you won't be inundated with email requests.
  2. Error's when searching for dates

    Fenton, Thanks tons. I really am a newbie developer. I have recently implemented the development standards put together by CoreSolutions and though i have many tools to debug my database problems, I have not had enough experience with filemaker to really know what to look for and where to look for it. Thanks for your help! You've taught me something that i hope i can use in the future.
  3. Lo' again all, I've updated my attendance file and its scripting. Its a little more manageable now. There are two ways that a user could input invalid or incorrect data when doing date range searches. They could search for a date range yields a zero found count (e.g. error = 401), or they could mess up and use the incorrect number of days for a given month (e.g. they could do a search on the range: 1/1/2003...1/31/2003). When i am doing a manual find and i place that in my date field (dateAttendance) it pops up the "The date in this field must be a valid date..." message. This is an acceptable and understandable function. However, when i script my date range search, it performs a find without informing the user of any errors. I have my script set up to catch errors and i have steps that look for error 401 and deal with it appropriately. However, i don't know how to have it catch errors of the second type, (i.e. the user says there are more days in this month than there actually are "11/31/year"). I am attaching a stripped down version of my attendance module. Thanks in advance for reading and helping (past, present, and future). modules.zip
  4. finding dates

    This post is WAY late given when the original question was posted. Anyway, when Mark Appleby suggested using "<= //" to find all dates equal to and before today, the reason filemaker barfed at you was the space between the "=" and the "//" terms. Just remove the space and you will end up with "<=//", which should work.
  5. Summary fields & summary reports

    Ok, last post on this thread i hope. Not only have you two helped me out with the attendance problem, you two have also helped me make another part of my database MUCH more efficient.
  6. Summary fields & summary reports

    Oh, to give you more of an update as to what i did - I used the concatenated LeftKey (RECORDID / gMonth) & RightKey (StudentID / MonthName(Date_Attendance) ) keys that you suggested. The key i was thinking about creating was MUCH more complicated than that and i don't know why i thought it had to be so complicated. I just wasn't thinking. I also put the report in the students.fp5 file and it was MUCH easier to accomplish that way as you predicted, espringer. Thanks.
  7. Summary fields & summary reports

    I believe i have it working. Thanks to you both for the input. I have asked my relatives for a Filemaker download that i can just pour into my head. Again -thanks...
  8. Summary fields & summary reports

    You are correct. I am attempting to isolate and obtain summary information for one month at a time. You are correct in all of your assumptions. I am having trouble telling it to sum attendance records for ONLY the month represented by the found set. Do you think i will have to create another relationship in order to do this?
  9. Summary fields & summary reports

    Quick reply. I believe i have discovered a part of my problem. I believe I need to be basing the sums in the cAbsenceCnt and the cPresenceCnt fields off of a different relationship that concatenates the studentID fields and the found set's date range (for the left key) and the studentID and the date_attendance (for the right key). When thinking about it, i believe that the summation fields are pulling data in from all the records that correspond with a given student, regardless whether or not those records are in the current found set. If i am right, then i will have to create a new self-join. Espringer (glad your here as you helped quite a bit with my last major problem). I'll try creating the cAbsenceCnt and cPresenceCnt fields in the students.fp5 file and see if i can get accurate data that way (well, mainly just to see if i can figure it out). That will be a project for tomorrow. This is my last post before i get in bed for the night. Thanks to you both for providing valuable input.
  10. Summary fields & summary reports

    Ok, i have implemented your suggested solution and am one step further to my goal. The problem i have now run into is the numbers that i am given. For instance, "32" for student 'aaa aaaaa' is not the correct summation of the number of times the student was present. Interestingly, i have created two calculation fields that record the total number of averages for the given found set. One field returns a "1" if the field "attendancestatus" has 'absent' as its value (0 if anything else or nothing). The second calculation sums the first calc field for a given found set. It does this through a relationship (studentID=::studentID) so that it will only sum the absence_calc fields for a given student. This set of fields, dealing with absence, works correctly. The two fields for presence are set up exactly the same, however they do not produce correct results. For instance, the second presence calc field is set to sum the first presence calc field (just like the absence fields). In the current found set, the field cPresence for each record contained the number "0". The field "cPresentCnt" summed these 31 zeros as 17. Now, i have no idea where it is getting the number 17. I'll post another copy of the file. (I just changed the student names and in checking it all out, student's "D" and "E" are working correctly. I wonder if there is something wrong with my relationship -though i can't see what...) Secondary information: I am first running the Find Date Range script that can be accessed from the script menu. I am isolating the month of December. attend_module.zip
  11. Summary fields & summary reports

    Fenton, i'm trying your solution...
  12. Hello all, This is another newbie question, though an easy one. I am having trouble creating reports that summarize my data. I was wondering where i could go (books, online resources -free if possible) to learn ALL about how to create summary fields and reports appropriately. *My specific problems is: I have an attendance database and attendance is recorded in the field "AttendanceStatus". Three values are allowed as input to this field: Present; Absent; and Homestay. I would like to be able to display the total count of presence and absence for a given month for a given student, but every attempt i have made results in either the averages or the totals for every student in the found set. I have one field (cPresence) checking for the text "Present" in the field AttendanceStatus and returning a "1" if it finds that text. My summary field (sPresentCnt) is a 'count' of (cPresence). Anyway, its an un working mess at the moment and i need to find some instructional material that will help me figure out how to best create summary reports in all sorts of circumstances. Thanks guys! attendance_module.zip
  13. Accessing Values from Adjacent Files(Databases)

    I have combined the databases and the current summaries_points database works perfectly for my needs. Given the small number of different types of data i will be recording, combining the databases will not create a behemoth. Thanks guys! [more questions to come! -) ]
  14. Accessing Values from Adjacent Files(Databases)

    After reading several threads on this board and giving some time for reflection, i have been bouncing around the idea of combining the summaries and points databases. It would certainly make that problem go away. It might also make for a cleaner and more efficient database? What do you think?
  15. I have and will continue to have multiple issues with learning how to use filemaker well. I have decided to focus on individual components of my student information tracking system for my small school. I currently have the summaries component working. To be more specific, daily comments must be made on each student. At the end of each treatment week, those comments are presented on a form which displays thus: one page is dedicated to a given student with the five summaries corresponding to the five week days listed in chronological order. We also assign 'behavior points' to the students each day. I have a 'dailypoints.fp5' database that keeps track of their points. The points are broken up into 10 different elements and there is one calculated field that sums all the points for a given day. I would like to display the total daily points information (field) next to the corresponding day of week on the summaries form. I have played around with relationships but have not met with success as of yet. The results i typically get are one of three things: a value is displayed, but it is the same value for every day of a given student (e.g. 37 points is displayed for student jane doe for every day of the past week, even though in fact the point values were [37,40,30,31,29]). This happens when i define the relationship by studentID. Both "dailypoints.fp5" and "summaries.fp5" are 'below' the Student.fp5 file. However, neither is below the other (they are on the same level). I have also tried to relate the two based on a date field value. This date is always the date on which the points and summaries were supposed to be given. So, to recap, i wish for information in an adjacent (not above or behind) database to display in the summaries database. How might this be done?

Important Information

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