IT Programme 20 days 4 Weeks

IT Programme - No-Code Web Development Programme using Softr and Airtable

Explore

Day 2 - 3: Fundamentals of Airtable

Day 3 - Hours 1-2

Hour 1-2: Basic Data Manipulation

Part 1: Introduction to data manipulation in Airtable

Explanation of the importance of data manipulation in organizing, analyzing, and presenting information

Overview of the various ways to manipulate data in Airtable, including sorting, filtering, and searching

Part 2: Sorting, filtering, and searching data

Sorting data:

Click the "Sort" button at the top-right corner of the Airtable interface or right-click a column header and choose "Sort".

Select the field to sort by and choose the sorting order (ascending or descending).

Add additional sorting criteria if necessary.

Filtering data:

Click the "Filter" button at the top-right corner of the Airtable interface or right-click a column header and choose "Filter".

Set the filter criteria by selecting a field, a condition, and a value.

Add additional filters if necessary, choosing whether they should be combined using "AND" or "OR" logic.

Searching data:

Use the search bar at the top-right corner of the Airtable interface to quickly search for specific keywords or phrases within the table.

Use the "Advanced Search" feature to perform more complex searches based on multiple criteria and conditions.

Part 3: Hands-on exercise: Manipulating data in a table

Students will work with a sample Airtable base provided by the instructor.

Practice sorting the data by different fields and in different orders.

Apply filters to display only specific records based on certain criteria.

Use the search functionality to find records containing specific keywords or phrases.

In this hour, students will learn about the basic data manipulation techniques in Airtable, including sorting, filtering, and searching. They will practice these techniques using a sample base provided by the instructor, helping them gain a better understanding of how to effectively organize and analyze data in Airtable.

Here's the sample data in a table format:

Table 1

Table 1

Task ID

Task Name

Assigned To

Priority

Status

Due Date

Design homepage

Alice

High

In progress

4/5/2023

Write blog post

Bob

Medium

Completed

4/3/2023

Update user guide

Carol

Low

Not started

4/10/2023

Fix bugs

David

High

In progress

4/7/2023

Test new feature

Alice

Medium

Completed

4/1/2023

There are no rows in this table

⁠

To create this base in Airtable:

Choose "Start from scratch" and name the base (e.g., "Team Tasks").

In the new base, you'll see a default table called "Table 1". Rename it to "Tasks".

Customize the fields in the "Tasks" table:

Keep the first field as "Task ID" and set its field type to "Number".

Change the second field to "Task Name" and set its field type to "Single line text".

Change the third field to "Assigned To" and set its field type to "Single select". Add options for the team members (e.g., Alice, Bob, Carol, David).

Change the fourth field to "Priority" and set its field type to "Single select". Add options for priority levels (e.g., High, Medium, Low).

Change the fifth field to "Status" and set its field type to "Single select". Add options for status (e.g., Not started, In progress, Completed).

Change the sixth field to "Due Date" and set its field type to "Date".

Enter the sample data provided above into the "Tasks" table.

Now you have a simple Airtable base for managing tasks, with fields for task ID, task name, assigned team member, priority, status, and due date.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.