Synchronizing Custom Time Field with Outlook
I am running Gemini 3.5.4 and have installed the Outlook add-in for Outlook 2007. The issues that I have created in Gemini with a start and due date of the same date show up as separate appointments within the same day on my calendar, one for the start and one for the due date. I have created two custom fields called Start Time and End Time, which I would like to be synchronized with my Outlook calendars Gemini Issues start and due dates times. My problem is that all the appointments start dates have a default time set to 9:00 - 9:30 and all the due dates have a default time set to 5:00 - 5:30. In addition, why do the start and due dates have two dates and times each?
Jeremy
· 1 |
|
Monday, September 28, 2009, 6:54:25 PM |
0
|
We are not sure about your issues but think we can explain: |
||||
|
0
|
No, that is not my issue. That I understand. My problem is that each Start Date and each Due Date for a task has a preset/default time in Gemini Outlook. The preset/default time for the Start Dates are always 9:00-9:30 and the preset/default time for the Due Dates are always 5:00-5:30. Lets say for example that I wanted to have an Issue with a Due date of October 5, 2009 at 2:00-2:30 and I wanted to use the notifications/reminders in outlook to remind me 10 min prior to the issues Due date, which would be at 2:00 - 2:30 on 10/5/09. When creating this Issue in Gemini, there is no Time field by default to specify my time of 2:00 - 2:30, so it would automatically show up in my Outlook calendar with a correct date but with a incorrect time of 5:00 - 5:30. The 10 min reminder would remind me 10 min prior to 5:00 - 5:30 when in reality my due date is 2:00 - 2:30, making the reminder useless. So to try and solve this problem, and because Gemini doesn't have a time field by default, I created two custom fields in Gemini called "Start Time" and "Due Time", but I have no idea how to synchronize these custom fields with Gemini Outlooks issues Start and Due Date times, or if it is even possible. |
||||
|
0
|
Gemini does have start and due date for each issue, you might need to set the visibility of these in the relevant field visibility scheme. |
||||
|
0
|
I am aware that you are able to set the start and due dates in Gemini, I'm not concerned about that. I am concerned about setting the times for the start and due dates. |
||||
|
0
|
Sorry, Got you. We do not allow for setting the times for date fields at all. |
||||
|
0
|
In my previous post, when I said "The issues I have created", I meant "Gemini Issues". That is what they are referred to in the Countersoft Documentation and in Gemini. I am glad we are on the same page now. How could you synchronize/set the time with SQL Triggers? |
||||
|
0
|
Create a trigger on the gemini_issues table that will update the start and due dates with the correct time when inserting / updating data. |
||||
|