Create and update customers

Void setValue(String column, String Value)

Sets a named field to the given value. Look up names in the reference section down below, or check out the class reference.

🛈 Note

Both parameters are strings! Remember to use quotes even for IDs.

User u;
u.load(9);
u.setValue("email", "bob@example.com");
u.save();

Saves a new or updated user and returns its ID.

User u;
u.setValue("firstname", "Sam");
printLine(u.save().toString());

Parameter	Db field	Description
id	id	ID (primary key)
username	username	Unique username or uid
profileId	profile_id	The user’s profile (profile.id)
firstname	firstname	The first name of the person
lastname	lastname	The last name of the person
email	Email	1 or more
ownerCompany		The ID of the company linked to user’s person entity
group	usergroup	The primary group for the user
status	status	Status active (1), not present(2), deleted (3)
language	language	The user’s language, see list below for values

Parameter	Db field	Description
loginAttempts	login_attempts	How many times the user has tried to sign in with an incorrect password
lastLoginAttempt	last_login_attempt	The last time the user tried to sign in but failed
idleTime	idle_time	Duration in seconds the user has been idle

User flags represent preferences. For example, Use24HrsClock = 10.

Access flags represent what a user may do. For example, AccessDocuments = 8.

Notifications (pop-up warnings) to the user are controlled by a bit mask.

Learn more about tickets.