Very new to FileMaker here.
I have an Event Table with fields EventID, EventDate, and EventDuration, AND an Attendees Table with fields EventID, PersonID, and SignupCreatedTimeStamp. I would like to add a Field to the Attendees table that that will tell me how many hours of activities this person is already signed up for in the 30 days before/after that event. I can do this using the Find Records method, but I think this could be done in a Calculation Field using GetSummary.
The point of this all is to prevent people from signing up for more than 20 hours of activities in a month. After I get this calculation worked out, other checks will be put in place when creating new records to make sure people are in compliance.
To make this a little more flexible I added the following fields to the Events table
EventWindowStartDate = EventDate - 30 EventWindowEndDate = EventDate + 30 Guess what I'm not sure on is the syntax for GetSummary .... I've tried putting the following in a calculation field with no luck
GetSummary(EventDuration, if(EventWindowStartDate...EventWindowEndDate, EventDuration, 0)) Am I going about this the right way? What is wrong with my calculation above?
Any thoughts or pointers would be much appreciated. Thank you very much in advance!!
I've got to believe I'm just having a brief episode of "stupid" and I'm just over thinking this...
I'm essentially trying to create a portal of summaries of items that appear in another portal. Here's the plan...
I have a table with individual expense items. I then I have table used for invoicing the expensed items. The data is sorted by date and customer and category creating an invoice with the total amounts. There are several items on each invoice of the same category (i.e. meals & entertainment, or car rental or hotel).
A simplified list of expenses on the invoice might look like this..
04/01/14 Hotel $250
04/20/14 Car $63
04/02/14 Meals $50
04/03/14 Hotel $200
04/12/14 Meals $50
04/06/14 Hotel $175
04/16/14 Meals $48
I'm trying to create a portal that lists the summaries of the categories. Something like this...
Since the categories are dynamic, and I'm filtering by invoice number I can't set up summary fields for each category. I've created a self-join relationship and used the GetNthRecord trick to grab the first occurrence of each category from the main portal but now trying to grab the totals of each category is presenting a problem. If I simply do a GetSummary of each category it only lists the amount of the first record (due to the GetNthRecord used in the portal filter).
I'm looking forward to learning the errors of my ways! Thanks.
I have a form which uses a drop down list to store an ID and an edit box overlay to show the related value chosen. (still baffled that FM hasn't just made that a native option)
The problem I am noticing is that the Edit box only refreshes when one clicks on a blank area on the form. I have drop down lists in other forms that refresh their edit boxes as soon as a value is selected. The difference being that the ones that refresh immediately, the drop down list field is from the table the form is based on, but if the drop down list field is based on a related table it doesn't refresh immediately.
How do I get it to refresh without changing the forms base table reference or clicking on a blank area of the form?
I have just let this behavior go but now the users are getting annoyed by it. I am on FM 11 but I am not sure all the users are.
Thanks for any help or even just let me know if this is something that just is the way it is.