Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Synchronizing Custom Time Field with Outlook

web-app

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
Jeremy
Replies (7)
helpful
0
not helpful

We are not sure about your issues but think we can explain:

Gemini will only show the issue start date (and time) and due date. This will be 2 seperate appointments.
Is this not what you are seeing?



Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

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.


Jeremy
· 1
Jeremy
helpful
0
not helpful

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.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

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.


Jeremy
· 1
Jeremy
helpful
0
not helpful

Sorry, Got you. We do not allow for setting the times for date fields at all.
However, you could do so via SQL triggers.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

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?


Jeremy
· 1
Jeremy
helpful
0
not helpful

Create a trigger on the gemini_issues table that will update the start and due dates with the correct time when inserting / updating data.


Saar Cohen
· 5000
Saar Cohen