View Source

In the table below, find the values passed to client and server scripts according to the type of the column they are in. Most of the values passed in the both scripts are the same, the differences are reflected in the table below.

To find out what type of data a particular field of the form takes, right-click on its name to call the context menu, and select Field info. The window that appears displays the name of the column, its system name, type, and value.

Column type

Entry on the form

getValue()

getDisplayValue()

Fields with no choice

Big Integer

1232886464646464446

Decimal

123.45

Duration

01 days 01 hours 01 minutes 01 seconds

90061000

Client script: 90061000
Server script: 01 01:01:01

Enum form_split_element_type

Available values:

begin_split
split
end_split

begin_split

Float

2222222.2222

Html

You are on the SimpleOne documentation portal.

<head>

</head>

<p>You are on the SimpleOne documentation portal.</p>

</body>

</html>

<head>

</head>

<p>You are on the SimpleOne documentation portal.</p>

</body>

</html>

Integer

123

Journal Input

This is my best comment!

The value disappears after saving the form.

-

Json

{"name":"More","sector":"Oil and gas","top500":1}

Password

ItsaVeryStr0ngPassword

The value disappears after saving the form.

Client script: -
Server script: $2y$13$OSphZNWbAbAJrvA.J65QhO4Q3eAocDWKXZmAryH1gn/UZZCxHTinO

-

Encrypted password

546789-2ssfd

The value disappears after saving the form.

Client script: -
Server script: EgKfp1hEhBY9SlUpqO4QGA==

-

Percent Complete

99.00

Client script: 99.00
Server script: 99

99.00

Phone

+79992848090

+79992751133

Script

const callerId = s_form.getValue('caller_id');
if (!callerId) return;
const callerRecord = new SimpleRecord('employee');
callerRecord.get(callerId, ()=> {
  if (callerRecord.sys_id && callerRecord.personal_schedule) {
    s_form.setValue('schedule', callerRecord.personal_schedule);
    return;
  }
  s_form.addInfoMessage('Расписание пользователя не определено');
});

const callerId = s_form.getValue('caller_id');
if (!callerId) return;
const callerRecord = new SimpleRecord('employee');
callerRecord.get(callerId, ()=> {
  if (callerRecord.sys_id && callerRecord.personal_schedule) {
    s_form.setValue('schedule', callerRecord.personal_schedule);
    return;
  }
  s_form.addInfoMessage('Расписание пользователя не определено');
});

const callerId = s_form.getValue('caller_id');
if (!callerId) return;
const callerRecord = new SimpleRecord('employee');
callerRecord.get(callerId, ()=> {
  if (callerRecord.sys_id && callerRecord.personal_schedule) {
    s_form.setValue('schedule', callerRecord.personal_schedule);
    return;
  }
  s_form.addInfoMessage('Расписание пользователя не определено');
});

Small Integer

23

String

Hello

Text

Kind regards,
SimpleOne

'Kind regards,\nSimpleone'

Translated text

Completed

The text value that has a translation in the System Translations (sys_translation) table is displayed in the language set in Preferences.

Completed

Сompleted

Rich Text

Hello

{"root":{"children":[{"children":
[{"detail":0,"format":1,"mode":"normal"
,"style":"","text":"Hello","type":"text","version":1}],"direction":"ltr",
"format":"","indent":0,"type":"paragraph","version":1}],"direction":
"ltr","format":"","indent":0,"type":"root","version":1}}

Client script: Hello
Server script: {"root":{"children":[{"children":[{"detail":0,"format":1,"mode":"normal"
,"style":"","text":"Hello","type":"text","version":1}],"direction":"ltr",
"format":"","indent":0,"type":"paragraph","version":1}],"direction":
"ltr","format":"","indent":0,"type":"root","version":1}}

URL

your.instance.simpleone.ru

Choice fields

True/False

A checkbox is selected.

Client script: 1
Server script: true

Client script: 1
Server script: Yes

Choice

In the drop-down list, the option Changed is selected.

Changed

Color

A yellow color selected in the palette, the field displays the hex of the color #fccb00.

#fccb00

Conditions

Active is No

(active=0)

Date

2000-12-31

Date/Time

2022-12-22 19:22:22

Date/Time Specific

2022-08-31 07:34:12

Days Of week

Days selected from the list: Wednesday, Thursday, and Friday.

28

Document ID

A record is selected, the field contains a reference with a displayable name.

Client script: 0229fa8abcbe1f540229fa8abcbe1f01
Server script: 0229fa8a-bcbe-1f54-0229-fa8abcbe1f01

Client script: Admin User
Server script: User: Admin User

Field Name

Assigned User field

155931135900001080

Assigned User

Image

An image is attached.

168139165117069552

Client script: {sys_id:'168139165117069552',delete_url:'/ image/delete/168139165117069552',url:'http://s3.simple.test/...', original_url:'http://s3.simple.test/...',file_size:248.833,file_name:'image.png'}
Server script: 168139165117069552

List

The records Admin User and Guest User are selected from the list, the field contains the displayed names of the records: Admin and Guest User.

155931135900000001,100000000000000001

Admin User, Guest User

Record Class

The field contains a link to the table Services. The link appears after saving the form.

157233752019606969

Services

Reference

A record Level is selected.

167327603510375360

Level

Template

Policy > Protected

Client script: {"167327603610803300": "Protected"}
Server script: {"1": {"167327603610803300": "Protected"}}

Time

07:59:22