Jump to content

DreadDamsel

Members
  • Content count

    14
  • Joined

  • Last visited

Community Reputation

0 Neutral

About DreadDamsel

  • Rank
    Volunteer Developer

Profile Information

  • Title
    Ms
  • Industry
    Volunteer Chair, Community House
  • Gender
    Female
  • Location
    Melbourne, Aus

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    12 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra

FileMaker Partner

  • Certification
    Not Certified
  1. Counting the number of checked boxes in portal rows

    Comment - Brilliant - was the solution completely. Works like a charm. This has been the last component to getting the project complete and our Community Centre now has a fully-functioning Contacts and Booking Management system. Everyone's help is absolutely fantastic on this forum and has gone a long way to helping me complete this project which I undertook on a voluntary basis for the organisation. Thank you Lesley Wheeler Chair Karingal Neighbourhood House In. Frankston, Vic, Australia
  2. Counting the number of checked boxes in portal rows

    Still can't get it to work. Number_of_children - number, Lookup (source is a calculation which counts the number of entries in a list field) Inactive_Activity - a number, set as Boolean configured so that non-zeros=1 and zeros=0 (source a value list with 1 as the only entry) I need a calculation to go on a field named total_children_inactive_in_class such as (but I can't get to work): if(Inactive_Activity=1 ; sum(Number_of_children) ) Once I have this number, subtracting it from the total of children (which I have) is a simple matter. I need for the admin staff to be able to see both a number of active and inactive children, as if they all turn up at once we exceed our legal limit.
  3. Counting the number of checked boxes in portal rows

    Thanks Steve, classes aren't confined to childcare only, most of them are single person participants, and that count is easy to ascertain correctly. Childcare however, is just the number of children. The parents aren't there. I already have a field that is a calculation that counts the total listed children associated with a parent (in the parent's contact details elsewhere). We have to keep track of whether the participant is active or inactive because they may not come to all the sessions. If they stop coming, they're marked as Inactive (the checkbox), and the class number reflects only active numbers. The inactive box is also linked to their enrolment history, so we can see what people have enrolled in in the past. Once a class is completed, all participants are marked as inactive as that activity has ended. All I need to do is get a total of the number of children there are where the parent has been marked as inactive in that class. Once I get that, it's a simple matter of subtracting it from the total number of children (which I've already got the calculation for).
  4. Hi, I have a bit of a dilemma that I've tried a number of solutions to sort out, to no avail. I have a portal that lists the participants in a class. In each row is a checkbox that can be used to indicate whether that participant has withdrawn from the class. I've used a summary field to count the number of checked boxes and have a field that subtracts that number from the total of records in the portal - easy peasy. Where it gets tricky is that, one of the fields relates to the number of children associated with a participant (a mum may have 3 kids in the class if it's one of the playgroups). Now I need to know how many kiddies there are in the class. I have a field that totals the number of children in total and that works fine, but... ... and here's my problem - where a parent has withdrawn (and the box is checked), I need to subtract the number of children associated with that parent from the total number of children). The checkbox is a value list with a single value, 1. All the solutions I've tried so far are fine unless it pertains to portal rows - and I can't figure it out for the life of me. Can anyone help me out?
  5. Script to go to a related record in another table

    Siroos. Thank you so very very much for this. It's EXACTLY what I needed and works well. However - as in the way of many of these things, once my user saw it, there came the inevitable query... "Can we list all the participators in a class and have their participation showing in their Contact Details layout?". So I created a new table called Participants, with participantsID_pk and have linked it to the Contacts table via a participantsID_fk, which I was hoping to use as a Portal on a tab on the Activities layout so I could add multiple participants and have their phone, email and mobile display. Participants is also linked to the Activities table via a ActivityID_pk/fk relationship. The participants I've structured as dropdown selector the same as your example (using the lookups). Portal and lookups all sourced from the Participants table. In that table, I've got Participant_name lookup to ContactWholeName in the Contacts table. What's happening is that if I link the portal to Contacts table, I can see the fields, but the dropdown doesn't work. If I link it to Participants, the fields don't show. Just want to be able to add participants to classes and on the contact details for each participant, the relevant Activities they're signed up for can be seen. (so we can go to a Details and see what they're doing and have done - so keeping a record of past participation). Sorry about asking this, but if I can get this sorted out - I can hand the damned thing over. Setting up all the printout pages and stuff is easy peasy. Oh yeah. Your example I've also adopted for our volunteer project leaders so double thank you:) Cheers Lesley
  6. Script to go to a related record in another table

    For your info and anyone else's reference, here's the setup. I'm working with FM 12 Advanced. It's a community centre database that keeps a record of all the people we need to have details for - so anyone who hires a room, signs up for an activity, or is associated with the centre in some way. Anyone who hires a room has to sign an agreement and pay a bond to get an access card for the building, though this may not necessarily be the person running the activity - it may be the secretary of their group, rather than the activity leader. The agreement/bond isn't an issue as it's directly part of the contact's details, as is any membership they may have - a contact can only have 1 of each of these. All the general contact information, membership, agreement and bond stuff is done and works fine. Where I'm having difficulty is: Table for: Contacts Table for: Activities Table for: Volunteer Projects (once I get my head around the associations for Activities, I'll adapt it for these projects too) An activity is run by a single contact, but a single contact can be running multiple activities. I have all contacts on a value list referenced from a calculated name field (joins first and last names - the calculation is in the field which is a text), and I have all activities also on a value list referencing from a field (the Activity Name). On the Contact Details Layout, I want to be able to select from a dropdown, 1 or more Activities the contact is running and be able to then go directly to the activity details via a button. Conversely, on the Activity Details Layout, I want to be able to select from a dropdown, the 1 person running the activity and go directly to the contact details via a button. I have ID_pk fields for each of my Tables, and matching ID_fk fields in them all to. The Contacts Table is my central starting point, as everything revolves around them. I'm not new to Filemaker (have played with it since FM3), but I'm not a scripter and my head simply doesn't work that way. If I understand the logic of something I can work it out. I do however, understand the complexities and logic of Excel formulae. I find all discussion relating to Relationships by FM people is from a scripter perspective, and I've not been able to find anything that explains it in plain language. If there's something anyone knows - I'd be only too happy to learn. I've yet to try the solutions you've all mentioned above, but will get to them later today - I'll let you know how I go - and thank you very much for your assistance with this - it's much appreciated:)
  7. Script to go to a related record in another table

    Both Contacts and Activities have ID keys and are related via these. I've also set up relationships so that Activity Leader in the Activities table relates to NameWhole in the Contact one. Don't know if that's right. I have SOOOOO much trouble wrapping my head around Relationships...
  8. Hi guys, I have a Contacts table and an Activities table. A Contact can be a leader of many Activities. On the Activities Details layout, I want to be able to select a Contact from a dropdown and have a button that can then be used to take the user to the Details page for that contact. I've tried several things from researching, but can't seem to get it working. PLEASE can someone help me. It's driving me nuts. I'll also want to do show the Activities a person is leader of on the Contact Details layout, but I'm presuming that's a simple portal.
  9. Single email to multiple recipients

    I tried a number of things, but eventually just did it as a Find that exports to excel, and the girls just pick up all the email addresses from that and mass email
  10. Single email to multiple recipients

    I'd like to bump this as I'd REALLY like an answer. My only other solution is do do a sorted report that exports to Excel, then my staff can select all the email addresses and do a mass mail from these. However, that's an added step and clunky. There's surely a more elegant solution via Filemaker.
  11. Associating a contact with a membership number

    Hm - what I suppose I could do is work on the basis that if a radio box is checked for "Member?", then the Contact_ID could show, otherwise it's left blank. Reckon that would work?
  12. Single email to multiple recipients

    Hi, I've spent a lot of time searching around to try to figure this out - to no avail. I want to be able to send a single email (may be different each time the mailout is done) to multiple recipients that are the result of a find. I've created the script and it works fine EXCEPT I get a separate email window pops up for every recipient, into which I then have to complete the Subject and contents - not what I was hoping for. Even to do it as a an email to a single address (our organisation) and all others gathered as BCC opens up separate windows for each found record. Can someone please help me resolve this? If I can solve it for this list, then I can apply the same principle to the other 4 "finds" I need to be able to do. Using FMP12 Advanced on Mac (so using Mail), though the final product will be on Windows.
  13. Associating a contact with a membership number

    Hi Mike - not all contacts are members, though those who are can only have a single membership number and class. For example, a contact may be a government advisor - so not a member of the community house. Also, a member may be either a voting or non-voting member - so different classes of membership. We were also wanting membership numbers to be preceded by the joining month - so 052017-23 for example, this way we can easily keep track of when it's time to renew membership.
  14. Hi. I'm using FMPro 12 Advanced. Creating a database for our community centre and I need to add a membership number to contacts - but not all of them. I've created a separate table for Membership numbers (as not all contacts will have one, so serial numbers aren't appropriate). Each membership has a number of details fields. It's probably a REALLY logical and stupid problem I'm batting against - but I need to: Select a contact>go to their details>add a membership number (go to a floating window layout, enter the details to the serial-number-derived membership) and have the details including the number show up in a tab on the contact's details layout. I've created a relationship between my contacts file and my membership file via the Contact_ID>Contact_ID_fk and have played around with other relationships. I've also created a simple script from a button on the Contacts membership tab to go to the Membership Layout window and create a new record. But it keeps creating a new record in the Contacts, not Membership - even though the relationship only has to create new records in the memberships side. I'm now running around in circles - please can anyone help me out here?????
×

Important Information

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