ExtraTable - SuperOffice

A class to access extra tables and create, edit and delete entries.

Constructors

ExtraTable()

ExtraTable

Initializes a new instance of the ExtraTable class.

Methods

delete()

Deletes the loaded object.

Void delete()

Returns: CRMScript.Global.Void

delete(Bool)

Deletes the loaded object.

Void delete(Bool signalWebhook)

Returns: CRMScript.Global.Void

getValue(String)

Returns the value of the given field for the currently loaded entry.

String getValue(String field)

Returns: CRMScript.Global.String - The value of the given field for the currently loaded entry. Example:

ExtraTable ex = getExtraTable("y_myTable");
Bool b = ex.load(2);
print(b.toString());
print(ex.getValue("x_table"));

getValues()

Returns all the fields and values of the extraTable row as a Map.

Map getValues()

Returns: CRMScript.Native.Map - All the fields and values of the extraTable row.

load(Integer)

Loads the extra table entry with the given ID.

Bool load(Integer id)

Returns: CRMScript.Global.Bool - True if the entry was found and loaded; otherwise, false. Example:

ExtraTable ex = getExtraTable("y_myTable");
Bool b = ex.load(2);
print(b.toString());

loadFromAgentAndKey(Integer,String)

Used for integrating data from external systems.

Bool loadFromAgentAndKey(Integer agent, String key)

Returns: CRMScript.Global.Bool - True if the entry was found and loaded; otherwise, false.

save()

Creates a new or updates an existing extra-table entry. If ID is set, the table will be updated. Otherwise, a new extra-table entry will be created.

Integer save()

Returns: CRMScript.Global.Integer - The ID of the newly saved object.

Use save(Bool) to signal that the entry should be reloaded after the save.

save(Bool)

Creates a new or updates an existing extra-table entry. If ID is set, the table will be updated. Otherwise, a new extra-table entry will be created.

Integer save(Bool reload)

Returns: CRMScript.Global.Integer - The ID of the newly saved object.

save(Bool,Bool)

Creates a new or updates an existing extra-table entry. If ID is set, the table will be updated. Otherwise, a new extra-table entry will be created.

Integer save(Bool reload, Bool signalWebhook)

Returns: CRMScript.Global.Integer - The ID of the newly saved object.

setValue(String,String)

Sets the value of a given field if it exists.

Void setValue(String field, String value)

Returns: CRMScript.Global.Void Example:

ExtraTable ex = getExtraTable("y_myTable");
Bool b = ex.load(2);
print(b.toString());
ex.setValue("name", "Test");
print(ex.getValue("x_table"));

​Constructors

​ExtraTable()

​Methods

​delete()

​delete(Bool)

​getValue(String)

​getValues()

​load(Integer)

​loadFromAgentAndKey(Integer,String)

​save()

​save(Bool)

​save(Bool,Bool)

​setValue(String,String)

Constructors

ExtraTable()

Methods

delete()

delete(Bool)

getValue(String)

getValues()

load(Integer)

loadFromAgentAndKey(Integer,String)

save()

save(Bool)

save(Bool,Bool)

setValue(String,String)