List Card

Used to report. The requested information can be seen as the desired list card.

l1.png

List Card tool icon at Toolbox

 

l2.png

How it looks like on the Canvas

 

Compatibility

Free Form Responsive Form Mobile
icons8-check-circle-48.png icons8-cancel-48.png icons8-cancel-48.png

 

Remarks

This toolbox is triggered when the form is opened.

 

Properties

  • Name: The name of the tool will be written here.

  • Help Text: It is the text that is entered for comment when the mouse is placed on the tool.

  • Height / Width: Adjusts the height and width of the tool (The width field has been removed from Responsive Forms).

  • From Left / Top: Adjusts the distance of the tool from the left and top (This field has been removed from responsive forms).

  • SQL Query: SQL query will be written here.

  • Fit Horizontal: Fits the tool to the full screen on the user’s screen.

  • Pin Right: Pins the tool to the right.

  • Display: Makes the tool not appear on the screen.

  • Paging: Multi-line data can be loaded quickly.

Actions

  • When the row is Changed: Assign an “Action” as on row value changes handler. For more information please click here.

  • Record is Added: Assign an “Action” as on record adds handler. For more information please click here.

Example Used

Firstly, this tool is triggered when the form is opened with an update value operation.

To use the list card, a label must be added to the list card. The name added to the label should be written as $PTagName$ as in the screen below. After the list card query is written, the areas in this query is added to Group Box of the List Card with $P. If there are aliases in the query, you must use them.

This List Card tool is used to assign tasks, for announcements, to show each row in the table separately.

For example;

 All tasks which is status "New" will be shown off  in this list. In order to do that a List (Card) is needed to  from the toolbox and is named it as “ListCard_1”. In query box the following query is entered;

SELECT  

TM_TASKS.UserTableID, 

TM_TASKS.Task_Title, 

TM_VARIABLE.Name AS TaskType, 

TM_TASKS.Comments, 

XPODA_CLIENT_USERS.UserFullName AS Responsible,

dbo.TM_TASKS.Status

FROM  dbo.TM_TASKS WITH (NOLOCK)  

LEFT OUTER JOIN dbo.TM_VARIABLE WITH (NOLOCK) 

on TM_TASKS.Task_Type = TM_VARIABLE.UserTableID 

LEFT OUTER JOIN dbo.XPODA_CLIENT_USERS WITH (NOLOCK) 

on TM_TASKS.Responsible = XPODA_CLIENT_USERS.UserID

mceclip0.png

How it looks like on Canvas

 

After that “groupbox_1” heading will be changed as “$PResponsible$”. And labels will  be added as "$PTask_Title$", "$PComments$" “$PTaskType$”. The last group item will be a button. these labels and heading will show off every one of task card. Button will be used for edit to the selected task card. Please notice label names and query (in ListCard_1) name must be the same. The color of the List Card tool is chosen from the Property Panel.

To display the data on List Card, Event should be " When the form is opened" and operation will be " Update value" for the ListCard_1.

mceclip1.png