May I suggest an extra field in the security-panel? → FullName.
Now you can give a username and password.
Is it possible to add that field: Fullname?
Mostly a username is a shortname which you use to login. I want to use the fullname than, for the auto-fill functions: creation username, modification username, etc..
What you could do at the moment is create youre own user table with youre fullname (and address information ect) and user the userid of the servoy user also as youre primairy key.
Then you can do everything you want.
Oke Johan, you got me thinking!
oke, but I see a problem, if I want to do that.
I have a field: creationname with the autofill-option: creation username.
I want to change the auto-fill-option to: creation userid
than, with a relation to the usertable I can link this to the right fullname
But, now it comes, you can’t setup a relation between an integer and a textfield. So I have to change the creationusername, to an integer, to make the relation work. But than I have a problem, that I have to change this manualy by all my customers (now just 2, but mabey in the future a lot more ) because the import of an updated solution does not support this.
Do you have a solution for this kind of things?
How about this: Create a separate column in you table for a STORED calculation. Call it userid_int and make it an integer?
That way - you effectively have one “version” of the key as text and one as integer (to join on).
Cheers,
Bob Cusick