Build a Projects list to store project details and a Tasks list to track the work. Link each task to its project, then show the matching tasks on a project detail form.
Step 1: Structuring your data
Use one row per project in Projects and one row per task in Tasks. Give each list its own fields. For example, a project has a category and an owner, while a task has a priority, a status, and a link to the project it belongs to.
Step 2: Create a new data list
In your application, select Add resource → Data List → New data list.
Enter Projects as the name, add a description if needed, and select OK.
Yeeflow creates a Title field that you can rename or hide from a view. It also creates Id, Created By, Created Time, Modified By, and Modified Time. Use Display fields to show system fields in the current view. Create new data list
Step 3: Rename the Title field
Open the Title column menu and select Edit field. Change Display name to Project Name and save. Title is a permanent system field, so it stays in the list under its new name.
Step 4: Add new fields
Select New column at the end of the headers. If prompted, choose Create manually, select a field type, enter its display name, and save. Add these fields to Projects.
Description uses Text Area.
Owner uses User.
Start Date and End Date use Date Picker.
Category uses Dropdown. Add your choices and turn on Enable color to give each choice its own color.
Step 5: Add records in the Data List
Select New item, fill in the project fields, and save. Add two sample projects so you can check their task lists separately later. Open either record to review its details. To load existing data in bulk, use Import. Import Excel or CSV data
Step 6: Set up linked records
Create a second data list named Tasks. Rename its default Title field to Task Name, then add these fields.
Owner uses User. Start Date and End Date use Date Picker.
Priority uses Dropdown with Low, Medium, and High.
Status uses Dropdown with Not Started, In Progress, and Completed.
Description uses Rich Text.
In Tasks, add a Lookup field named Project. Keep the current application, select Projects as the source list, and choose Project Name as the display field. Leave Multiple off so each task links to one project. Save the field, then add a task linked to each sample project.
The lookup shows the project name to users and stores the project relationship using its record ID. A lookup can also reference a list in another application when users have the required access. Create and configure a lookup field
Step 7: Build your custom forms of add, edit and view records
Yeeflow supplies a default form for new, edited, and viewed records. For this example, create a separate form to use when someone opens an existing project. Open Projects → More → List settings → Forms, select +, and name the form Project Detail Page. Select Edit to open the designer. List form designer
On the list form designer:
Lay out the project fields
Add Project Name to the canvas. Turn off Display Title, then set the read-only field typography to 20 px.
Add a four-column Grid, hide its title, and put Category, Owner, Start Date, and End Date in separate columns. Set the fields’ Title layout to Vertical.
Add Description beneath the grid and set its Title layout to Vertical.
Show the tasks for this project
Drag in a Data Table from Advanced and select Tasks as the data source.
In Data filters, add a condition for the Project lookup. Choose Equals. For the value, open the Expression Editor and insert List Fields → Id. This is the ID of the project the user is viewing.
In Table content → Display fields, choose Task Name, Owner, Start Date, and End Date. Turn on Display Caption to expose table actions. Enable the search bar if users need to search within the related tasks. Configure a Data Table
Add tasks from the project form
Turn on Allow Add Item in the data table. Open Default values → Assignment and set the Project lookup to List Fields → Id. New tasks started from this table will use the open project as their default.
Submit the design and close the designer. Back in Forms → Display Settings, choose Project Detail Page under View Item. To open it as a full-screen pop-up, choose Pop-up window and set its size to Full screen.
Open both sample projects and confirm that each shows only its own tasks. With an account that can add Tasks records, add a task from one project’s table. Reopen the task and verify its Project lookup. Create custom list forms
Recap
The Projects list holds project details. The Tasks list holds work items and links them to a project. The custom view form uses that relationship to show related tasks and prefill the project when users add a task from the form.

