Jump to content

WF7A

Members
  • Content Count

    559
  • Joined

  • Last visited

Community Reputation

1 Neutral

About WF7A

  • Rank
    Rich

Profile Information

  • Title
    Database Administrator
  • Industry
    Education
  • Gender
    Male
  • Location
    Columbus, NE
  • Interests
    Flying, amateur radio, and my neighbor's wife. ;>

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    19

Platform Environment

  • OS Platform
    Mac
  • OS Version
    10.15.x

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

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

  1. Thanks, and I apologize for doubling your efforts in answering my requests. I'll check with the end users which way they want to go with this.
  2. *sigh* It's a good thing I'm paid by the hour. After Comment's outstanding help with setting up a value list for grade levels, I've run into a snag: how to create a summarized list by individual grade level when each record's value list contains multiple-checked values? Example: If I want an ascending-order, summarized list of teachers who teach in 1st grade, then 2nd grade, then third grade, etc., how do I parse that from a value list field (GradeLevel) where ticked checkboxes have 1, 2, 3, 4, 5? My best guess is to create a looping script to parse 14* separate variables--using GetV
  3. Agreed, and I just created a field in the parent/DISTRICT_STAFF table and created a few quick calcs to copy the data into a text field so I'm good. I'll create a field to convert the text values, Preschool and K, into numeric values so when called upon to do anything with sorting, the records will appear in grade ascending order, e.g., Preschool could be -1; K = 0 ; 1...12 would stay the same.
  4. Sorry, my poor Engfish (English that stinks) strikes again. What I was referring to is that most of the teachers in our district teach more than one grade, so if I want to find teachers that teach only one grade--say, 1st grade--and no other grades, their records will be the only ones to pull up if "1st" is chosen as a search criterion, not teachers that teach 1st and other grades. I'm sure it exists somewhere for FileMaker Pro, but it would be cool to perform a find for records identical to the same way used when queuing pages to print, e.g., 4,5, 7-10. Thanks for the post reference
  5. I'm stuck (again.) Temporarily, I created this goofy setup where DISTRICT_STAFF is the parent to the GRADE_LEVEL table (hence, the portal on the left.) As is, the user clicks the Perform Find button after entering either one grade level or a range of grade levels, but that's no good because what if the user wants to find grades 2, 6, and 10 (and no others)? On a lark I thought of using a checkbox'd value list but I can't even think of how to go about coding a script to find the ticked grade levels. Any help with figuring out the schema, or a better way of doing this, would be greatly appr
  6. Sorry for the delay--I was out of town. Yes, there were two TO's--parent-child EVENT_PARENT to DATE_TIME, and EVENT_PARENT to EVENT_PARENT_xEventFilter; the former I used for data entry and the latter for displaying events to users. However, after additional requests from the users for more types of lists/reports, I bagged the idea of using a self-join portal and just went with layouts using List mode--it's not nearly as compact or elegant, but it gets the job done a whole lot easier.
  7. Thanks again--I'll give it a shot in the morning. My brain is full.
  8. Maybe I need some coffee: What I meant to say is that yes, each child record contains only one timestamp, but there are multiple fields to create that one timestamp as shown above. I'm sorry. The "portal-in-a-portal" reference was that it's easy to sort records in a portal (based on "x" value), so that's just one way of doing it. As an aside, I did happen upon a portal-in-a-portal article that improvises on that idea,( https://filemakerlovers-org.fmlovers.org/filemaker-portal-in-a-portal-4d-printing/ ) but there wasn't a viable link to the sample file.
  9. It's to the child table: from EVENT_PARENT to DATE_TIME ... BUT the portal is a self-join of EVENT_PARENT.
  10. Thanks, your calc worked. : ) The "multiple values" reside in the child table; the portal shown below "feeds" the child table's separate Date, Time From and Time To fields; I use a calc (in the child table) to create a timestamp. One problem was that the user could add dates/times that preceded existing ones in the portal, so that threw the sort order off in my poorly constructed List calc.
  11. Greets, all: Since I can't insert a portal within a portal, I'm stuck: I have a parent (EVENT table) - child (DATE_TIME table) relationship where I want to list (the calculated) multiple timestamps in the Upcoming Events column. I used the List function but it apparently doesn't sort timestamps; I also used the SortValues calculation but didn't get far with that, either. More than likely I'm bollocksing-up the calculation (or using the wrong approach altogether) so I'd appreciate some assistance. TIA for your help! Rich
  12. Sorry for the confusion--simplifying the problem, as you've posted, clarifies things a lot! Indeed, grouping--in Attendance--should work; would getting the CountOfAttendees be best calculated using a Summary field or is there a better choice?
  13. I can see why you're having trouble. In the Attendee table is DistrictCount__lxn--that's the field where I _think_ a number should be pushed in for the the count-per-district; the manually entered number (in the Excel spreadsheet) is Count_Attendees_lct. District names aren't represented in the Excel spreadsheet proper but are listed by NDE code in the District_Name 2::NDE_Code_lxt column. Activity was renamed Topic__lxt in the Excel Spreadsheet. Mind you, I inherited this mess so I'm trying to fix the file; if you only could see the rest of the relationship
  14. Wow, you're fast! Here's one of the reports "old style" where it's one record per school district. 2_7_21 through 2_13_21.xlsx ...and yes, the weekly report will include more than one parent record; how many, that depends on how many events took place that week.
×
×
  • Create New...

Important Information

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