Hello,
1. is it possible to recognize wich records in our "outlookagenda" table are updated by GeniusConnect? For inserted records by GeniusConnect I can specify default values for mandatory fields. I really would like to have such a feature for updated records (my own triggers then can "reset" such a value after handling the records).
You can define a (Mandatory/Primary keys dialog) mandatory field with a select statement returning always a flag value
like select 'this is from outlook' or you can use the Timestamp value See help file topic "Timestamp"
2. is it possible to use the current outlook username as a dynamic parameter for the retrieval filter? (our customers all use an exchange-server in combination with active directory, and I don't want all clients to login to the database with their own name, so I don't have the possibility to extract it from the database). Or can I just use the WINDOWS_USER variable then (is that allways the same as the outlook user)?
You can use:
{DB_LOGIN_USER}
{DB_USER_NAME}
{WINDOWS_USER}
"is that allways the same as the outlook user?"
It depends on your setup, if you are using MS Exchange the User account often linkes to a NT User, so it may be possible.
Enterig a login name and password per user is not necessary if you are using NT Security to connect with the database!
3. I've got a problem with the "Assign table" dialog: after some testing, it does not show all fields anymore for the agenda-folder (e.g. start, duration, organizer are missing). I've read in the forum that you use the 1st custom-form you can find for displaying the fields? But i'm not using custom-forms... I suspect that some "corrupted" appointments are somewhere in my outlook agenda (invisible). Do you have some hints/tips for me to resolve this?
GeniusConnect uses the first item in the folder only for custom fields, but I'm not 100% sure, we will test this.