Melborne
-
Content Count
11 -
Joined
-
Last visited
-
Calculate absences within a date range, separated by months.
Melborne replied to Melborne's topic in Relationships
@GisMo Thank you for the reply. The days(Calendar days table) are created for entire year, only 1 record per day.(~365 per year pre-generated records) Absence table is where I create absences with a start and an end date. It could span over multiple months. I have a table for Hours sheet (hours sheets table) where an hour sheet is created per month. I want to grab number of days in Absences per hour sheet i.e per month. Example: If user applies for Absence from 26th Feb to 5th March: I want 26th Feb to 28th Feb(or whatever the end date of Feb) in hour sheet of February and 1st -
Hi! I have an Hours Sheets table, and hour sheets are created per month. I have Absences table which has absences specified by start and end date. and I have a Calendar days table, which is related with Absences with start date and end date. Now, When I create an absence spanning over two or more months, (e.g 26th March to 5th April) I want to get related calendar days for the particular month in hour sheet. (i.e if I create an absence from 26th March to 5th April I want to have 3 days (26th, 27th and 28th) in hours sheet of February month and 5 days (1st, 2nd, 3rd, 4th and 5th) in hours
-
After searching for some time on cross-tab reports, I found this amazing technique by Comment : http://fmforums.com/forum/topic/71836-getting-more-out-of-filtered-portals-in-version-11/ It almost gives me the output I need. I am thinking of a way to somehow integrate search on year range in this file. Cheers! CrossTab using Comment's technique.fmp12.zip
-
Thank you very much for your reply and the modified solution file. Although it makes more sense to design the report vertically as you suggested, my client wants a horizontal report. I will search about creating cross tab reports and try to make the report horizontal as per the requirement. Again, thank you for the reply and to get me started.
-
hi! Â I have a table which has Date, Amount and Source fields. I want to display the aggregated Amount for a particular Source grouped by Year. User can select the year range and we should be able to display aggregated Amount for all the years which fall under the selected range. ( Please refer attached screenshot: 'Required Report') Any suggestions on how to proceed with this? Â Thank you! Source.fmp12.zip
-
Hi! Â I have a file with 'Check OUT' and 'Check In' functionality. I 'Check Out' a file from a container field to temp storage using 'Export Field Content' and 'Check In' from the same location(temp storage) using 'Insert File' after making changes. If I Check Out an Excel or Word file, and try to 'Check In' while the 'Checked Out' file is still open, I get the error 'This file is locked or in use.' (please refer screenshot) but the script does not throw any FileMaker error.(It works fine with Text file) How can I capture the error if file is open and FileMaker can not perform 'Insert Fi
-
@Brooks, Thats Perfect! Thank you very much!
-
Thanks for replying. @doughemi Not exactly what I need, I want the user to select a day by clicking in portal, and then center that selected day in middle. I think it is not possible to display a scroll bar as we are displaying filtered records.
-
We can display a checkbox, which will set a flag field, and exit script if the flag field is set. check attached file. container burtton 2.zip
-
check if this file helps ( create a new record first). container burtton 1.zip
-
Hi! I have a 'Days' portal on my 'Sheet' layout ( which shows list of days from a particular month). Requirement: 1. I want to display seven rows in the portal. 2. I want to be able to select a day from the portal and then position it in the middle ( i.e 3 days less than selected day are placed above the selected day and 3 days greater than selected day are below the selected day). 3. Allow scrolling using portal scroll bar. I am able to position the selected day in the middle using a portal filter and a script, however I am not able to enable scrolling using the portal scrollba