Jump to content

snickwit

Members
  • Content Count

    6
  • Joined

  • Last visited

Community Reputation

0 Neutral

About snickwit

  • Rank
    novice
  1. Thanks for responding. I didn't realize I could do "If ...then" & " If ...then" commands meaning thread multiple "if...then" formulas together. That makes sense now. As for the discounts, they are in random pattern if that is what you mean? In other words, some folks get 3 discounts, some get none and some get only 1 discount. Does that help? Thanks again, Shelley
  2. Hmm, I see where you are going with this. Pardon me but I'm not exactly sure how I would implement this. Here is what I would like to see as a result - here are is a scenario: Example 1: A Field labelled: Prorate = 100 A Field labelled: Discount = (null) A Field labelled: Famiy = 200 The calculation field in the layout would then show: "Prorated Discount = $100 Family Discount = $200" So it would need to know that Prorated is not empty, thus provide: "Prorated Discount = $" & Prorated also Family is not emtpy, thus provide: "Family Discount = $" & "family. If I concatenated the fields as you suggested, I would get: "100, , 200" (or would I get "100,,200"???) from the above example. I have 6 different discounts so would it make sense to generate a CASE formula with 6 different possiblities? I can see how I can use the LEFT, RIGHT ...how can I use that when I am using 6 concatenated formulas since I won't know how many characters to move in the middle? Thanks again for your help! Shelley
  3. Hi all, I am a network administrator (having fun with my filemaker DB projects) working on a simple calendar layout for room schedules at a non-profit so you can imagine, our budget is limited. The layout is a 7-day weekly layout for rooms scheduling using global fields. Based on my research, I could not find a simple answer and/or some of it was too complicated. Here is the lowdown on my project: Requirements: Display 7 day layout for each room onsite (preferably, as many rooms on a 11x17" sheet I can fit in it) which comes from two databases: CLASSES DB and private LESSONS DB both which have rooms booked. I have created a ROOMS DB which links to both and I can display results. In the rooms DB, I have (I can only fit 6 rooms onto one page layout): gDay1, gDay2 ...gDay 7 gRoom1, gRoom2 ...gRoom6 (for each room) which totals: 13 fields and conconcated formulas: gDay1 & " " & gRoom1 (this could be Monday Room1) gDay1 & " " & gRoom2 (this could be Monday Room2) gDay1 & " " & gRoom3 ........ thru......... gDay7 & " " & gRoom6 which totals 42 fields Does this mean I need to generate 84 relationships to the 2 related database files (classes and lessons). I wonder if there is another smarter way to make the relationships based on something else rather than hard-coded gday and groom fields. I have a script which can auto-fill the global fields and make print outs so I end up with prints that I need for all rooms which I believe there are 25 rooms. I realize this does not take in account to start date and end date so I will probably need to change the formula to include: gStart_date gEnd_date and concate these two into the conconcated fields but it still remains as total of 42 fields. Let me know what your thoughts and suggestions are. Thanks, Shelley
  4. Hello, I've been quite a bit of time working on Filemaker for about a year so I'm not a complete newbie though, I have no idea how to post this question or what the feature is called: I have multiple fields which show Credits that were applied in a DB such as: 1. Pro-rated 2. Family Discount 3. Scholarship When working on statements layout, I need to itemize where the credits came from. Rather than placing straight text with the above 3 fields, I rather only display the field if the field is not empty. In other words, how do I generate calculation to show only fields that are NOT empty? Do I need to build a long "IF...then ..if, then" formula? I tried CASE but that doesn't work because if there is data on the field 1 and field 3, it only shows field 1 since it is the first match. Let me know what you suggest or if I need to post this elsewhere. I will be happy to provide more details if needed. I just want to avoid bombarding anyone. Thanks in advance! Shelley Version: v6.x Platform: Windows 2000
  5. snickwit

    Calculating Future Dates

    Hmmm, not sure I follow exactly what you mean by looping one date at a time. I'm still fairly new to developing databases so perhaps, I am missing something here? Do you have a sample of what it might look like or what the script should look like? I'm not sure how to run the append within Filemaker, is it similar to a dos command: >>? I'm starting to revist and wonder if it would be easier to generate a script that would automatically import this data into an outlook calendar instead. The problem with that is all items would be in one calendar. If I could do a calendar for each room ...somehow get it to script to CSV and import to the appropriate room calendar ...that would eliminate all my needs to build any kind of "smart" calendar features within FileMaker. Are you familiar with anything like this? I saw a blurb on google groups recommending this solution: http://www.datavations.com/dvpages/products/fmcomponent_outlook.cfm Thanks in advance for your help, S
  6. snickwit

    Calculating Future Dates

    Hi all, I need help setting up calculations working with dates for a non-profit community school. I am developing a course listings database which lists courses and holds fields such as: start_date, end_date, number_of_weeks, days_of_the_week, number_of_class_sessions as well as others. I need to generate calculations that have the ability to list all the possible dates for a course. For example, let's say there are two classes: A mini-course which runs for 1 week based on 5 days meeting Mon, Tu, Wd, Th and Fri. Therefore, this class has 5 total class sessions. A course which runs for 16 weeks based on twice a week which meets Mon and Wed. Therefore, this class has a total of 32 class sessions. I have this formula to calculate the "number_of_weeks": Int((end_date - start_date)/7) "Day_of_the_week" = repeating field which holds all the days of the week the course can be hosted on. "Calculate_day_of_the_week" = corresponding daily number based on "day_of_the_week" using a case formula: Case(days_of_the_week= "Monday", 2, etc. etc. etc. days_of_the_week= "Sunday", 1) "Number of days" counts how frequently a course is taught within a week such as if a course is offered once a week or twice a week using this formula: Count(days_of_the_week) "number_of_sessions" = total number of sessions that class run such as 16 week class meeting twice a week equals 32 using: Count(days_of_the_week) * number_of_weeks However, I cannot seem to build a smart functionality to start with first day of class and increment by next class meeting date and continue to the end_date so I can automatically generate our class attendance roster sheets. My goal is to build layouts which can list attendance sheets based on number of weeks per course. Is there a way to generate a formula based on number of weeks and add +7 to each date incrementing by number of weeks? Or perhaps, there is a better method? Such as if a class starts 1/5/2004 and meets for 2 weeks on Mondays and Wednesdays
×

Important Information

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