calendar
It would be extremely helpful to be able to put records with several different date fields on a single Calendar.
For example, a table has fields for ‘DateCreated', ShipDate', and ‘Received_Date'. I need to have a single calendar that puts each of these dates (if there is a value in that field) using another field's value (‘Description’ in this case, to identify the calendar ‘even't) in the same calendar.
For example. A record in this table with a Field:Description value of 'Oushak Rug' could have:
DateCreated: 05/01/15
ShipDate: 07/06/15
Finish_Date: 09/03/15
I need the value 'Oushak Rug' to show up 3 times on the calendar, once for each date, along with a label, so it makes sense, like:
In the 5/01/15 box of the calendar: Oushak Rug- Item Created
In the 07/06/15 box of the calendar:Oushak Rug- Est. Ship
In the 09/03/15 box of the calendar:Oushak Rug- Est. Receive
The labels would be based on the date field name the date was taken from. It really doesn't help to have to have several Calendars, one for each kind of date field as that's a very clunky UI. This would really help on apps that are very calendar-heavy.
-
Greg Griffin commented
This is exactly my problem that I have been trying to find a workaround for. Alternately, I was trying to create a view that would give me a separate line for each date field and then try to recombine into a single calculated date field, but alas, the calendar report won't let you use a calculated field as the date field for the report :( There is no way around this other than disconnected calendar reports. Makes the calendar really only good for meetings or appointments and nothing else. Alternately, if we could have calculated fields created in the view, this could fix it or use calculated field in the report could provide a way....not elegant, but at least a way'