List view displays data-list records in rows and fields in columns, making it a common layout for managing structured data.
A new data list starts with a list view. You can add other views of the same list as needed.
Throughout this article, we will guide you in building a leave management application.
Create an application named Leave Management, then add a data list named Leave Information. You can use an existing application or list for the same example.
Step1: Adding the field
In this scenario, we'll using following field and setting.
Title: Single Line: accepts a single line of text.
Mark as required.
Default value: the original example uses the literal text “'s Leave”. This text alone does not insert the employee’s name; enter or configure the intended title for your own records.
Name: User field:allows you to type-in or select users in the active users list in your organization.
Mark as required.
Leave Type: Single Select:allows users to select one option from a pre-defined list, making it a valuable addition to any form that requires users to make a choice from a set of options.
Set display style as drop down.
Mark as required.
Enable color from predefined color list.
Start Date & End Date: Date picker: enables users to enter a date value.
Switch on the time and format it as HH:MM.
Mark as required.
Minute step sets the selectable time increment in minutes. The original example shows 1 minute.
Leave Status: Single Select:allows users to select one option from a pre-defined list, making it a valuable addition to any form that requires users to make a choice from a set of options.
Set display style as drop down.
Mark as required.
Enable color from predefined color list.
Employee Photo: Image: enables users to submit one or multiple images through the form.
Mutiple: off
Single image size limit (MB) : 2
Mark as required.
Leave Days: Calculation: allows you to create new field that calculates values. It uses Yeeflow built-in Expression Editor to perform calculations.
Calculated field: using Yeeflow Expression Editor to calculate leave days.
Data type: Number.
Thousands separator: choose the ungrouped number format shown as 1234567.89 in this example.
Rounded to: 1 decimal.
In this scenario, the working hour is 8 hours. So, the calculation for Leave Days is
( dateDiff( List Fields: Start Date, List Fields: End Date, Hour)-( dateDiff( List Fields: Start Date, List Fields: End Date, Day)* 16 ) ) / 8
The first dateDiff measures elapsed hours between Start Date and End Date. The second term subtracts 16 hours for each elapsed day, and the result is divided by 8. This is a simplified fixed-8-hour-day example; the formula does not itself consult a weekend, holiday, shift or break calendar. Check same-day and cross-day examples against your organization’s leave policy before using the result.
Id:Id is system autocreated for each data set.
Create by/ Creare time:Automatically generated when creating a new data set.
Modified by/ Modified time:Automatically updated when creating a new data set or modifying existing data.
For more information please refer to Create and manage data fields.
Step2: Chose the view
In this case, we'll choose the list view.
Select List view, enter a name such as Employee Leave Details and the required URL, and choose whether it should be the default view.
Additionally, you can configure the Permissions of this view for specific users based on different departments, users, or user group, depending on your purpose.
For a default view, view permission becomes All users rather than specified users. Review that access scope before saving; see Getting started with Yeeflow data views.
This crop shows one option from the original English list-view settings. Its capture date and product build are unknown; it does not show a saved default-view configuration.
Moreover, you have the option to set
Display field: Select the field you wish to display in the view.
Display order: Arrange the selected columns using Order in Display fields. Use Primary order and Secondary order in View Settings for record sorting; these do not rearrange the view tabs.
Data filters: Configure which records are included in the view.
User filters: Choose fields that viewers can use to filter the data list.
For more information please refer to Search and filter data in data list.
Final view
After saving the settings, open Employee Leave Details and check the displayed fields, record order and filter results. For other layouts, see Understand Data views.
