Forms. Manage field settings via field options_

Description of using options

Previously settings for some complex elements were made via the dict field elements procedure.

Now you can use the special pseudo-field options_{colCode} in getItem SELECT 1 (colCode is the name of the corresponding column). 

This method overrides similar settings from dict (but the old method of settings via the dict procedure is also supported). 

Example of settings: 

--SELECT 1 в GetItems
select name,
   '{
    "title": "Title1",
    "disabled": true
    }' options_name
from t1

IMPORTANT. Be sure to use quotation marks for field names.

Settings by Type 

General Settings

disabled: true false,

title - replaces the element title,

class - sets the CSS class,

width - sets the width as the css value for width,

placeholder - hint for entering the element value,

saveState - if true, the field will retain its value after saving and will be substituted in the future when loading the form (if no value is specified in the field).

string 

  1. mask - '9999999' - input mask
  2. prefix, suffix - adds additional markup to the field at the beginning or end of the field.

Examle: 

select  '{"prefix":"prefix", "suffix": ""}' options_s1  

int, float, html-number

  1. min - minimum value,
  2. max - maximum field value,
  3. step - increment step,
  4. readonly - if true, the element is read-only

date

  1. availableDates - available dates to select (separated by commas, see the separate documentation for using these modes)
  2. disabledDates - unavailable dates to select (separated by commas)
  3. format - if set, it sets the date format (if not, the global date format settings are taken from getLayout). 
  4. isInput - if true, it is displayed as an input field with a drop-down calendar

daterange

  1. format - if set, it sets the date format (if not, the global date format settings are taken from getLayout). 

time

  1. format - if set, it sets the time format (by default, hh:ii). 
  2. minuteStep - step of choosing between minutes (default is 5)

bool

  1. hideLabel - if true, the label will not be displayed for the jackdaw

switch

  1. size - sets the size of the radio button (mini, normal, small, large)
  2. on - text when enabled
  3. off - text in the off state
  4. onstyle - enabled state style(success, danger...)
  5. offstyle - off state style (success, danger...) 

text

  1. rows - the number that sets the height (rows) of the textarea
  2. cols - the number that specifies the width (cols) of the textarea

select-search

  1. selectHint - a line that specifies the initial hint in the element 

select2

  1. placeholder - hint in the element when there are no selected elements
  2. multiple - if true, multiple choice is available. If multiple elements are selected, they are passed comma-separated to the procedure. 
  3. tags - if true, you can add your own element, if it is not among the existing ones (write the text and add it). The newly added elements will have a value which is the same as text.

treeCheckboxes, treeOrder

  1. cascadeCheck - if true, then selecting the check mark also selects all child elements.
  2. width - number, tree width

files, fileContent

  1. code - resource manager code
  2. title - resource manager header
  3. compact - if true, then compact mode displays the file gallery
  4. ultracompact - if true, then very compact mode displays the file gallery.
  5. emptyText - text when there are no loaded items in the resource manager
  6. uploadTitle - download window title

intrange (range of numbers)

  1. min - minimum value of the selected interval
  2. max - maximum value of the selected interval
  3. step - range change step
  4. minValue - minimum limit
  5. maxValue - maximum limit

geo-autocomplete (geo point selection)

  1. jsonOptions - a line with the geo JSON settings (see the Geo documentation). This is exactly a nested JSON object.

Example of how to make it so that only business objects and settings are shown without restrictions on the type of objects (by default, types= ["geocode"]):

-- SELECT 1 in GetItem - business objects only
select '{
    	   "jsonOptions": "{\"types\": [\"establishment\"] }"

    	}' options_geoAddress


-- SELECT 1 in GetItem - no type restrictions
select '{
    	   "jsonOptions": "{\"types\": [] }"

    	}' options_geoAddress

Details - https://developers.google.com/maps/documentation/places/web-service/supported_types#table3

timer

  1. code - sets the timer code 
  2. itemID - sets the ItemId of the associated element to which the timer belongs

slider

  1. min - minimum value, number
  2. max - maximum value, number
  3. step - move step, number
  4. enabled - if true, then enabled
  5. ticks - a comma separated line of numbers where the labels will be
  6. labels - comma-separated label labels (line), corresponding to the position of ticks
  7. orientation -horizontal, vertical

weekTime

  1. standartWorkTime - line, the name of the button for setting the standard work schedule 7/2 9-17
  2. showHours - if true, the grid will show the clock
Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started

SQL-tool for creating personal accounts on the site

The essence of the approach and the history of the creation of Falcon Space
Web platform for creating personal accounts

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

MS SQL web applications. Affiliate program for developers and web studios

You can develop yourself or collaborate with us for web development on the Falcon Space platform using only SQL and HTML.
View examples with SQL code
Platform documentation
Working on MS SQL Server
Note