Forms. How to make a search for a field, i.e. a list with a search through a database access (autocomplete)
In the form column settings, specify List-search.
In GetItem, the field is extracted as the entity name, not the key.
Implementing a procedure like fm_formCode_fieldCode_dict (editing via the interface).
CREATE PROCEDURE [dbo].[fm_isp_region_dict]
@username nvarchar(256),
@itemID nvarchar(128),
@q nvarchar(128) = ''
AS
BEGIN
if(isnull(@q, '')='') begin -- (for usual select)
select ' Not selected ' Text, 0 Value, 0 Selected
union
SELECT gr.name Text, gr.id Value, 0 Selected
FROM dbo.as_geo_regions gr
order by Text
end
else begin
select ' Not selected ' Text, 0 Id, getdate() date, '' [desc], 0 type
union
SELECT gr.name Text, gr.id id, getdate() date, '' [desc], 0 type
FROM dbo.as_geo_regions gr
where name like '%'+@q+'%'
order by Text
end
END
An important difference is that the optional parameter @q nvarchar (128)=’’.
When saving the SaveItem field, we are passed the entity name (not the foreign key)):
CREATE PROCEDURE [dbo].[fm_profile_saveItem]
@username nvarchar(256),
@itemID nvarchar(256),
@fieldemail nvarchar(256) = '',
@fieldphone nvarchar(256) = '',
@fieldcity nvarchar(256) = '' -- на входе текст а не ключ-число
AS
BEGIN
update as_users
set
email=@fieldemail,
phone=@fieldphone,
regionID=(select top 1 id from as_geo_regions where name=@fieldcity)
select 1 Result, 'Сохранено' Msg
END
As a result, the field can be set through the search for values in the form and adjust how data will be generated in this search.
Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started
- Management
- Falcon Space Foundation
- Basic components
- Falcon Space Features
- Коммуникация с пользователем
- Дизайн, стилизация
- Integrations
- Каталоги
- Навигация
- Документы
- Additional component
- Продвижение, SEO
- Системные моменты
- HOWTO
- HOWTO Tables
- HOWTO Forms Forms. How do I accept multiple incoming parameters instead of just one parameter(itemID)? Shapes. How to create a form for editing an entity Forms. How to make custom HTML markup for a form (jsRender) Forms. How to make a search for a field, i.e. a list with a search through a database access (autocomplete) Forms. How to set some fields in the form by default when loading Forms. How to display different data on the same form for different roles Forms. How to display a list of check marks in the form (multiple field selection) Forms. How to display and save a multiple list through a chosen field. Forms. To reload a page after saving Forms. How to add a callback after loading the form and after saving the form. Forms. How to dynamically change the column type when rendering a form. Forms. How to make a modal form (opens in the dialog box) Forms. How to update a table (or form) after calling a modal form Forms. How to display a form in a pop-up window near to the button (popover) Forms. How to make dependent fields in a table (Country, City) Forms. How to select an address and save location coordinates (lat,lng). Forms. How to correctly process prices (fractional numbers) on the form Forms. How to display list data or a table inside a form Forms. Setting the background panel for a form Forms. How to pass a hidden parameter to a form Forms. How to make select and chosen lists with categories (optgroup) Forms. How to make a form as a step master Forms. How to show the progress of filling in the form (ProgressBar of filling in the form) Forms. How to use Checkboxes and select radio with picture Forms. How to make fields with animated values (rotating numbers, digits). Forms. How to edit the text of HTML elements in the Rich editor Forms. How to display a table in the modal window Forms. How to use the Select files field in the form Forms. How to hide / show update area on a page when changing a form field Forms. How to work with the Timer field Forms. How can I send a hidden parameter to a form in SaveItem (for example, a Cookie or URL parameter) Forms. How to show changing information when changing fields Forms. How to make a form with saved state Forms. How to work with a Slider type Forms. How to output and process data on a form from an external source via the API Forms. Adding a button to clear the form (Reset form) Forms. How to make a confirmation action in a text MESSAGE (SMS) form Setting the work schedule (weektime form field) Forms. How to make more than 1 action buttons in a form How to add examples of filling in fields in the form How to select a list value via the directory in the modal window How to make a confirmation window for the form action Forms. Dynamic change of the form's ItemId depending on other page elements Forms. How to add a new element if it is not in the list on the form. How to create a custom form with confirmation of action by Email or CMS How to make a delay when saving a form Hints-length limiters for fields in the form How to save the field value in the browser, so that you don't have to enter it every time you load it (leave the last saved one) Inserting links using a template (YouTube link, patternString) Forms. Uploading the form via the link Forms. Manage field settings via field options_ Forms. Using Google Recaptcha in forms How to specify custom mask for input field in form Form. How to display a tree with a selection of checkboxes Forms. How to choose a color in a form Custom verification of form fields via JS How to set available dates in datepicker Loading the form in the drop-down window Adding emojis to form fields Форма. Обработка даты из поля datetime-local Как у формы сделать progress bar при загрузке формы Редактор текста - код поля формы html2 Работа с датами в формах
- Working with SQL
- HOWTO JS
- HOWTO Layout
- Solve problems
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
Note
- Falcon Space Video
- Platform features demo will allow you to understand how this or that component looks and works
- Have a question? Write to the chat at the bottom right