Hi, I would like to know how Genius manages multiuser conflicts:

Example:

I have 2 primary keys: Number and name of the contact. The number increases with 1 on each insert(SQL added in the GeniusConnect configuration)

On the other side I have two users , and they record data (SaveItem button) in MySQL.
What will be the result if both of them insert the same contact(Same Name)?I consider that before saving the item they didn't synchronize the information with the database. Usually that opération will generate two differnt rows, but I don't want to record the same contact twice.
Can you give me an advice.
Thanks.

hello,

GeniusConnect is not handling duplicate names, same name does not mean it is the same contact!
It is not recommended to use name as part of primary key, name can be changed by the user!
Example:
User 1: change name from "A" to "B" and saves this to the database.
User 2: want to change the phone number of the same contact, during the save, geniusconnect will raise error "data not found".
Since Name is part of the primary key, the "A" key dosn't exist anymore.

Also, Outlook allows duplicate names, it will warn the user when adding contact with existing name, but it will not stop the operation if user proceeds with insert.