Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
OK, so let's answer the very specific question
How many holidays are on this month.
1. Make a table of holidays and enter then next 5 or 10 years of holidays.
2. Make a calculated checkbox field on the table to flag holidays in the current month. The formula for that will be
FirstDayOfMonth([Holiday Date]) = FirstDayOfMonth(Today())
3. New table with one and only 1 record in it and then block all users even you from adding or deleting records.
4. Make a relationship back to the Holidays table where the reference field call [Link to Holiday count] is a formula field with a formula of 1.
5. Make a summary of the # of holidays for the current month.
6. make a relationship similarly from that single Holiday count record down to all Orders and lookup the # of holidays for the current month.
How many holidays are on this month.
1. Make a table of holidays and enter then next 5 or 10 years of holidays.
2. Make a calculated checkbox field on the table to flag holidays in the current month. The formula for that will be
FirstDayOfMonth([Holiday Date]) = FirstDayOfMonth(Today())
3. New table with one and only 1 record in it and then block all users even you from adding or deleting records.
4. Make a relationship back to the Holidays table where the reference field call [Link to Holiday count] is a formula field with a formula of 1.
5. Make a summary of the # of holidays for the current month.
6. make a relationship similarly from that single Holiday count record down to all Orders and lookup the # of holidays for the current month.