Summary Field Issue
I am at my wits end and have decided to reach out for help. This is the same project that I was previously posting for assistance with API calls. I moved on from using API's and have revamped the design but, I am stuck on one piece at the moment. Hopefully, someone can explain where I am going wrong.
SETUP
- Meetup Credentials table with Time, Cost, Date, Name, # of Checkins, etc
- Membership table (parent to Meetup Credentials) with Name, Type, Payment, Balance, etc
- Check Ins table (child table to both Membership and Meetup Credentials tables) with lookup fields to each of the above fields
SCENARIO
It's possible for one Member to have multiple Check Ins to the same Meetup. A Check In is done when a Member wants to access the online event (whether it's about to start, already in progress, or has already occurred). Members are not charged for additional Check Ins for the same Meetup. I am trying to get a summary of how much has been spent by the member, so I can have the Balance updated accordingly. The problem is, I cannot get a sum of the cost for each unique Meetup a Member has Checked Into. I did create a formula field in the Check In table to combine the Member Name, Meetup Name, and Meetup Date into a string but, apparently, I don't now what to do to take advantage of that for capturing the proper cost. To give a visual:
MEETUP CREDENTIALS DATA
- MemberA, MeetupOne, 08-01-2020, $4, etc, etc, etc
- MemberA, MeetupOne, 08-01-2020, $4, etc, etc, etc (same data due to multiple check ins)
- MemberA, MeetupTwo, 08-05-2020, $4, etc, etc, etc
The Summary field I created is showing a total cost of $12 but, there are only 2 unique meetups for MemberA so, I need that total cost to be $8. Hopefully, someone can successfully guide me to a solution. Let me know if anything else is needed from me, in order to assist. Thank any and everyone in advance for help.
James
------------------------------
James Carr
------------------------------
SETUP
- Meetup Credentials table with Time, Cost, Date, Name, # of Checkins, etc
- Membership table (parent to Meetup Credentials) with Name, Type, Payment, Balance, etc
- Check Ins table (child table to both Membership and Meetup Credentials tables) with lookup fields to each of the above fields
SCENARIO
It's possible for one Member to have multiple Check Ins to the same Meetup. A Check In is done when a Member wants to access the online event (whether it's about to start, already in progress, or has already occurred). Members are not charged for additional Check Ins for the same Meetup. I am trying to get a summary of how much has been spent by the member, so I can have the Balance updated accordingly. The problem is, I cannot get a sum of the cost for each unique Meetup a Member has Checked Into. I did create a formula field in the Check In table to combine the Member Name, Meetup Name, and Meetup Date into a string but, apparently, I don't now what to do to take advantage of that for capturing the proper cost. To give a visual:
MEETUP CREDENTIALS DATA
- MemberA, MeetupOne, 08-01-2020, $4, etc, etc, etc
- MemberA, MeetupOne, 08-01-2020, $4, etc, etc, etc (same data due to multiple check ins)
- MemberA, MeetupTwo, 08-05-2020, $4, etc, etc, etc
The Summary field I created is showing a total cost of $12 but, there are only 2 unique meetups for MemberA so, I need that total cost to be $8. Hopefully, someone can successfully guide me to a solution. Let me know if anything else is needed from me, in order to assist. Thank any and everyone in advance for help.
James
------------------------------
James Carr
------------------------------
