Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Melborne

  • Rank

Profile Information

  • Gender
    Not Telling
  1. @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
  2. 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
  3. 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
  4. 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.
  5. 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
  6. 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
  7. @Brooks, Thats Perfect! Thank you very much!
  8. 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.
  9. 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
  10. check if this file helps ( create a new record first). container burtton 1.zip
  11. 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
  • Create New...

Important Information

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