Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

1232886464646464446

1232886464646464446

...

Decimal

123.45

123.45

123.45

...

Duration

01

...

days 01

...

hours 01

...

minutes  01 seconds

90061000

Client script: 90061000
Server script:

...

01 01:01:01

...

90061000

...

encrypted_password

...

-

...

EgKfp1hEhBY9SlUpqO4QGA==

Enum form_split_element_type

Available values:

  • begin_split
  • split
  • end_split


begin_split

...

begin_split

Float

2222222.2222

2222222.2222

2222222.2222

...

Html

You are on the SimpleOne documentation portal.



<html data-lt-installed="true">

<head>

<title></title>

</head>

<body data-gramm="false" data-lt-tmp-id="lt-752273">

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

</body>

</html>

<html data-lt-installed="true">

<head>

<title></title>

</head>

<body data-gramm="false" data-lt-tmp-id="lt-752273">

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

</body>

</html>

...

Integer

123

123

123

...

Journal Input

This is my best comment!

...

Info

The

...

value disappears after saving the form.


-


-

...

Json

{"

...

name":

...

"More","

...

sector":

...

"

...

Oil and gas","

...

{"glossary": {"title": "example glossary", "GlossDiv": {"title": "S", "GlossList": {"GlossEntry": {"ID": "SGML", "Abbrev": "ISO 8879:1986", "SortAs": "SGML", "Acronym": "SGML", "GlossDef": {"para": "A meta-markup language, used to create markup languages such as DocBook.", "GlossSeeAlso": ["GML", "XML"]}, "GlossSee": "markup", "GlossTerm": "Standard Generalized Markup Language"}}}}}

...

{"glossary": {"title": "example glossary", "GlossDiv": {"title": "S", "GlossList": {"GlossEntry": {"ID": "SGML", "Abbrev": "ISO 8879:1986", "SortAs": "SGML", "Acronym": "SGML", "GlossDef": {"para": "A meta-markup language, used to create markup languages such as DocBook.", "GlossSeeAlso": ["GML", "XML"]}, "GlossSee": "markup", "GlossTerm": "Standard Generalized Markup Language"}}}}}

top500":1}

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

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

Password

ItsaVeryStr0ngPassword

Info

The value

...

password

...

disappears after saving the form.

...


Client script:

...

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

...

-

Encrypted password

546789-2ssfd

Info

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

+

...

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);

...

    } else {

...


    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)

...

    } else {

...

;
    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);

...

    } else {

...


    return;
  }
  s_form.addInfoMessage('Расписание пользователя не определено');

...


}

...

);

...

Small Integer

...

23

23

23

...

23

...

string

...

A record is selected from the list

...

'{"name":"John", "age":30, "car":null}'

...

'{"name":"John", "age":30, "car":null}'

...

text

...

Hello

...

Hello

...

Hello

...

translated_text

...

String

Hello

Hello

Hello

Text

Kind regards,
SimpleOne

'Kind regards,\nSimpleone'

'Kind regards,\nSimpleone'

Translated text

Completed

Info

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


Completed

Сompleted

...

Completed

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

URL

your.instance

...

.simpleone.

...

ru 

your.instance

...

.simpleone.

...

ru 

your.instance

...

.simpleone.ru

...

Choice fields

True/False

...

Поля с выбором

...

A checkbox is selected

...

Yes

...

1

.

Client script: 1
Server script: true

Client script: 1
Server script: Yes

Choice

...

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

Changed

Changed

...

Color

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

#fccb00

#fccb00

...

Conditions

Active is No

(active=0)

(active=0)

...

Date

2000-12-31

2000-12-31

2000-12-31

...

Date/Time

2022-12-22 19:22:22

2022-12-22 19:22:22

2022-12-22 19:22:22

...

Date/Time Specific

2022-08-31 07:34:12

2022-08-31 07:34:12

2022-08-31 07:34:12

Days Of week

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

28

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

...

Ленивцы: 168068576413762231

...

0253c0a9-bdeb-6af9-0255-197ad30c42b7

...

fieldName

...

Assigned User 

...

Image

An image

...

is attached.

168139165117069552

Client script: {sys_id:'168139165117069552

...

list

...

A record “Maxim Popov” is selected from the list 

...

Maxim Popov

...

Maxim Popov

',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

...

template

Policy > Protected

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

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

...

Time

07:59:22

07:59:22

07:59:22