While making an AppSheet application on a Complaint Management System for a CCTV company, I had to create a slice where I had entered a complaint but had not assigned that complaint to an employee. To achieve this, I needed to filter the data to show only those complaints that were logged but not yet assigned.
Here’s how I did it.
First, I navigated to the “Slices” section in the AppSheet editor and created a new slice. I named it “Unassigned Complaints” to make it clear what this slice would represent.
In the “Row filter condition” of the slice, I needed an expression that would filter the rows based on two conditions:
1. The “Complaint Number” must not be empty.
2. The “Assigned Engineer” must be empty.
To do this, I used the following expression:
AND(ISNOTBLANK([Complaint Number]), ISBLANK([Assigned Engineer]))
Let’s break down this expression:
– `AND(…)` ensures that both conditions must be true for the row to be included in the slice.
– `ISNOTBLANK([Complaint Number])` checks that the “Complaint Number” column is not empty. This condition ensures that only complaints that have been entered are considered.
– `ISBLANK([Assigned Engineer])` checks that the “Assigned Engineer” column is empty. This condition ensures that only complaints that have not yet been assigned to an engineer are included.
By applying this filter, the slice will dynamically show only those complaints that have been entered but not yet assigned to an employee. This is extremely useful for the management team to quickly see which complaints need attention and to assign them to the appropriate engineers.
Using slices in AppSheet is a powerful way to manage and display subsets of your data based on specific criteria. It allows you to tailor the app to meet the specific needs of your business processes, making it easier to manage and track important tasks and assignments.
In this case, creating the “Unassigned Complaints” slice helped streamline the complaint management process for the CCTV company, ensuring that no complaint goes unnoticed and that every issue is promptly assigned and addressed. This not only improves efficiency but also enhances customer satisfaction by ensuring timely resolution of complaints.
Creating effective slices can greatly enhance the functionality of your AppSheet applications, allowing for more targeted data views and streamlined workflows. ISBLANLK and ISNOTBLANK are great ways to create effective slices in App sheet.
While making an AppSheet application on a Complaint Management System for a CCTV company, I had to create a slice where I had entered a complaint but had not assigned that complaint to an employee. To achieve this, I needed to filter the data to show only those complaints that were logged but not yet assigned.
Here’s how I did it.
First, I navigated to the “Slices” section in the AppSheet editor and created a new slice. I named it “Unassigned Complaints” to make it clear what this slice would represent.
In the “Row filter condition” of the slice, I needed an expression that would filter the rows based on two conditions:
1. The “Complaint Number” must not be empty.
2. The “Assigned Engineer” must be empty.
To do this, I used the following expression:
AND(ISNOTBLANK([Complaint Number]), ISBLANK([Assigned Engineer]))
Let’s break down this expression:
– `AND(…)` ensures that both conditions must be true for the row to be included in the slice.
– `ISNOTBLANK([Complaint Number])` checks that the “Complaint Number” column is not empty. This condition ensures that only complaints that have been entered are considered.
– `ISBLANK([Assigned Engineer])` checks that the “Assigned Engineer” column is empty. This condition ensures that only complaints that have not yet been assigned to an engineer are included.
By applying this filter, the slice will dynamically show only those complaints that have been entered but not yet assigned to an employee. This is extremely useful for the management team to quickly see which complaints need attention and to assign them to the appropriate engineers.
Using slices in AppSheet is a powerful way to manage and display subsets of your data based on specific criteria. It allows you to tailor the app to meet the specific needs of your business processes, making it easier to manage and track important tasks and assignments.
In this case, creating the “Unassigned Complaints” slice helped streamline the complaint management process for the CCTV company, ensuring that no complaint goes unnoticed and that every issue is promptly assigned and addressed. This not only improves efficiency but also enhances customer satisfaction by ensuring timely resolution of complaints.
Creating effective slices can greatly enhance the functionality of your AppSheet applications, allowing for more targeted data views and streamlined workflows. ISBLANLK and ISNOTBLANK are great ways to create effective slices in App sheet.