Kanban is a visual system used to manage work as it moves through a process. Kanban visualizes both the process (the workflow) and the actual work going through it. r.
Kanban is a method designed to help you optimize your workflow and use your team's full capacity.
The appearance of the Kanban element in the toolbox
Kanban element added to Free Form
Compatibility
Free Form | Responsive Form | Mobile |
Kanban element properties
Name: The name of the field is written.
Help Text: On the client side, an informative text is written on how to enter information into the element.
Height- Width: The height and width of the form tool are adjusted.
From Left-Top: Adjusts the distance of the form tool from the left and top.
SQL Query: A query must be written for the values that will appear in Kanban. If the query field is left blank, no data will appear in Kanban.
Column Query: This is the field where Kanban column headings should be entered. Kanban columns will be shaped according to the values you have written in this field and the title order.
The Order No field represents the order to appear, and the Column Name represents the title to appear. * sign should be used between them when writing.
Table Name: It is selected from which form page the values that will come to the kanban will be taken.
Group Column: It is selected according to which field the columns that will come to my kanban will be grouped.
Search Column: A search field is placed on the kanban in order to search among the values in the kanban. You need to specify the region you want to search from this area. If the title is selected, a search will be made within the title you have written in the search section. If the content is selected, only the cards with the search word in the content will be displayed.
Color Definition: Coloring the items in the kanban as cards or columns is selected.
Fit Horizontal: Fits the form tool horizontally to the full screen on the user's screen.
Pin Right: Fixes the form tool to the right.
Display: Makes the form tool not visible on the screen.
Example Usage:
A firm; It needs a structure to keep the records to be opened to the Technical Service department and then to report these opened records via Kanban.
First of all, a form page was designed where the records were created. The designed screen is as follows.
Tablo ve alan isimleri
Tablo Adı: TEKNIKSERVIS
Kayıt Tarihi: KayıtTarihi
Servis Numarası: ServisNumarasi
Müşteri ID: MusteriID
Cihaz Tipi: CihazTipi
Marka: Marka
Cihazın Modeli: CihazinModeli
Açıklama:Aciklama
Durumu: Durumu
Aciliyet: Aciliyet
After the form page and fields are created, a new form is opened and the kanban element is added to the form page. The newly opened form page must be in Free Form. Kanban cannot be used in responsive form.
When the kanban tool is dragged and dropped on the form page, it will be placed on the white canvas with a GroupBox inside. The GroupBox represents the card view in the kanban.
First of all, the Kanban tool is clicked on, and then the SQL Query field is reached and the fields that are to be displayed in Kanban are written here with the query.
The query written in the Sql Query field is as follows.
SELECT
TS.UserTableID,
TS.KayitTarihi,
TS.ServisNumarasi,
TS.MusteriID,
TS.CihazTipi,
TS.Marka,
TS.CihazinModeli,
TS.Aciklama,
TS.Durumu,
TS.Aciliyet
FROM dbo.TEKNIKSERVIS AS TS WITH (NOLOCK)
After the query is written, the headings that are desired to appear in Kanban should be written in the Column Query field.
The column headings to be used will come from the options in the Status field on the Create Technical Service Record form page. The options are as follows.
Record Created
in review
Being Repaired
Repaired
Delivered to Customer
Since it is desired to appear in this order, Order No and then Column Name are written in the Colum Query field. The written values are as follows;
1*Registration Created
2*in review
3*Repairing
4*Fixed
5*Delivered to Customer
Table Name: TEKNIKSERVIS table is selected from the tables.
Group Column: All fields on the TEKNIKSERVIS form page will be listed in this drop-down box. The column headings in the kanban are selected from this field. The Status field is selected for this example.
Search Column: Since it is desired to search according to the Description field from the fields in the incoming values, the Explanation value is selected from this field.
The form page is saved and the result is displayed on the client screen.
*Kanban element is an element that needs to be triggered externally, so when the form page is opened, the Kanban element must be updated with the update value action.
Client view
1- Since there are 3 records whose status is selected as 'Record Created' in the Technical Service Create Record form, the number 3 is included in the column header. Since no record is created for other cases, the value 0 is next to the titles.
2- The Search field comes with the Kanban tool. The Kanban element is searched for the value you have written in this field.
3- Card structure is used for each record you want to create in kanban. This is how the cards look.
The values to be displayed in the cards are added with the Label element. For this, the studio screen is returned and labels are added for the data to be displayed in the Group Box.
The same name used in the kanban query with the $P expression should be used to fetch the values. If ALIAS is given to the fields in the query, the value after ALIAS should be written in the Label Text field.
All values to be displayed in order are added to the Group Box with labels.
Client view
You can drag and drop your cards into other columns. You don't need to create any query for this.