Appointment table

•
Environment: cloud
• 3 minutes to read
 • 3 minutes to read

Appointment fields. Key constants are in BulkUpdateSystem.AppointmentFieldValueKeys.

Appointment

FieldValueKeys

OperationTypes

Expected Field Values

Affected Properties

Activitylink

Add, Remove, ReplaceWith, Clear

Values Count = 1…n

Values are encoded as tableName=recordId values with an optional comment:

“appointment=78” or
“appointment=78&comment=Some link comment”

Allowed table names:
(case-sensitive)
appointment, document, project, sale or URL

add:
Creates and adds all values as RelationRows.

remove:
Deletes all similar relations.

ReplaceWith:
Deletes all similar relations, then adds back new ones.

Clear: deletes all existing relations.

LinksHelper

AlarmOffSet

Set

Values Count = 1

Values[0] = (int) Alarm

Alarm

Description

Set, Clear, SearchAndReplace, RegEx

Values Count = 0 to 7

Set: Values[0] = (string)

Clear: Clears value

SearchAndReplace:
Values[1] = searchString
Values[2] = replaceString
Values[3] = options

RegEx:
Values[4] = expression
Values[5] = replace with
Values[6] = options

AppointmentText

Done

Check, Toggle

Values Count = 1

Check:
Values[0] = (int) 0 or 1
0 = Status.NotStarted
1 = Status.Completed

Toggle: invert current

Appointment.Status, Appointment.AssociateId, Appointment.GroupIdx

FreeBusy

Set

Values Count = 1

Values[0] = (int)
0 = FreeBusy.Free
1 = FreeBusy.Busy

FreeBusy

HasAlarm

Check

Values Count = 1

Values[0] = (int) HasAlarm
0 = No, 1 = Yes

HasAlarm

Owner

SelectOne

Values Count = 1

Values[0] = (int) AssociateId

Owner

ProjectId

SelectOne

Values Count = 1

Values[0] = (int) ProjectId

ProjectId

Priority

SelectOne

Values Count = 1

Values[0] = (int) PriorityIdx

Priority

Published

Check

Values Count = 1

Values[0] = (int) IsPublished
0 = No, 1 = Yes

PublishHelper

SaleId

SelectOne

Values Count = 1

Values[0] = (int) SaleId

SaleId

Type

SelectOne

Values Count = 1

Values[0] = (int) TaskIdx

Task

StartDate

Set

Values Count = 1

Values[0] = (datetime)
Only changes Date. Times are changed via StartTime field.

 DoBy (Date Only)
EndDate (Date Only)

StartTime

Set

Values Count = 1

Values[0] = (int)
minutes since midnight relative to current datetime

DoBy
EndDate

EndTime

Set

StartTimeAndEndTime

Set

Values Count = 2

Values[0] = (int) DoBy
Values[1] = (int) EndDate

minutes since midnight relative to current datetime

DoBy
EndTime

VisibleFor

SelectOne

Values Count = 1

Values[0] = (int)
Int.MinValue = All
Neg: -10 = GroupId (10)
Pos: 10 = AssociateId (10)

VisibleFor

See User-defined fields.