List Card Connected

Used to report. The requested information can be seen as requested in the Card list. Records in the List Card element can be dragged and dropped to the connected elements.

z50.jpg

List Card Connected tool icon at Toolbox

 

z51.jpg

How it looks like on the Canvas

 

Compatibility

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

 

Properties

Properties of the form tool;

z52.jpg

 

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

  • Field Style: Select whether the information entered is fixed or SQL query.

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

  • Icon: Select the icon, color, and position to be added to the tool.

  • Linked Field: The connecting list will be chosen.

  • Color: Edits the color of inside the tool and/or the text inside 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).

  • Values (Text*Value): The values to be displayed are entered.

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

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

The list card is connected to the tool used to make the report. The requested information is seen as the card list as desired. Records within the list card tool; the list can be dragged and dropped onto the card and displayed in separate list cards within the form. Sample screenshots are as follows.

 

For example;

List(Card) tool, we will show off all tasks which are status "In Progress" in this list. To do that we need to a List Card Connected from the toolbox and name it as “ListCardCon_1”. After that, we must specify the linked field which is name Status in "ListCard_1" query. Values field must be "In Progress*8" because we must filter task status. The color of the List Card Connected tool is chosen from the Property Panel.

This first tool is List Card. The second tool is ListCard Connected.

mceclip0.png

One of the events in this tool; When users drag and drop task card in this field we must update task status. So we add a new action for update. When the “ListCardCon_1” name selected you need to click "Add New Action" to do this. Type of Action should be Record is added". The operation will be " update value". The value area will be “itself”. SQL query field is;

UPDATE TM_TASKS SET Status=8 WHERE UserTableID = '$PUserTableID$'

Another of the events in this tool; We will update UID field When the card selected on the list . And we will use ID for activities of the task. When the “ListCardCon_1” name selected you need to click "Add New Action" to do this. Type of Action should be " When the row is changed". Operation will be " update value". Value area will be “UID”. SQL query field is;

SELECT '$PUserTableID$'

 

While on the client screen;

We drag and drop the tasks from the List Card to the List Card Connected tool.

mceclip1.png

The tasks are red when on the List Card. They are blue when on List Card Connected. Because they take the color of the tool they are on.

mceclip2.png

Client screen for the example