How to show only the actual vacation days in a calendar view
Posted on 2003-11-20
I will try to keep this one on track
Now that we have the day count working what I need to show in the calendar view would be only the 3 days. Currently the name of a person shows up on Holidays and Weekends.
I am thinking maybe a field that show only the actual days after the holidays and weekends have been removed and then use that for the calendar.
But then that raises the whole issue of Calendar view requiements.
To create a calendar view, you begin by creating a standard view. You can either complete Steps 1 through 10 for creating a standard view or you can convert an existing view to a calendar view.
1. Create a new view or open an existing view.
2. Open the View Properties box.
3. In the Style field, select Calendar. A dialog box appears. Click yes to continue.
The first column of a calendar view defines the Date/Time the entry will display and should be hidden.
4. Click the first column. In the Column properties box, check Hide column.
5. In the Programmer's pane, choose one of the following and enter a value for the first column that will evaluate to both a date and time:
Simple function - Select a value from the list that evaluates to a date and time, for example, creation date.
Field - This displays a list of all the fields in the database. Select a date/time field from the form you will use with the calendar view.
Formula - Write a formula in the Programmer's pane that evaluates to a date and time.
6. Open the Column properties box and click the Sorting tab . Choose the sort option Ascending.
Note If you have a field on your form that allows multiple values, and you want each value to display as separate entries in the calendar view, select the column sorting option "Show multiple values as separate entries" for the first column. For example, the Mail template uses this technique for displaying repeating events. Otherwise, the entries display under the first matching date only.
7. Click the Date and Time tab of the Column properties box and select Date and time.
The second column of a calendar view defines duration of the entry and should be hidden.
8. Create a second column or click the second column of the existing view. The second column must map to a field or formula on the document that specifies, in minutes, the duration of the event. In the Column properties box, check Hide column.
9. Create a selection formula for the view that will select the documents to be displayed in the calendar view, for example, _Calendar Entry.