Hello everyone,
I’m trying to create a simple app to track task completion across multiple stores. Here is the structure of my app: Store > Universe > Sector > Aisle.
For each aisle, there is a fixed list of four tasks to complete (e.g., restock the aisle, place equipment, install signage, etc.).
I want users to be able to select a store, navigate through the hierarchy to the aisle they need, and mark tasks as completed (I only need a binary “done” or “not done” status, no need for “in progress” states).
What I have done so far:
- Uploaded an Excel file with one sheet per hierarchy level (Store, Universe, etc.).
- Added IDs to establish relationships between the different tables.
- Created relationships between tables so that users only see the relevant tasks for each aisle in each store.
- Added a Boolean field in the Task table to store the task status (completed or not).
- Used a checklist component on the task page so users can mark tasks as done.
- Set up basic calculations to track progress.
I do not need user-specific columns, as the same tasks are shared across all users.
The issue: Video here Unique Download Link | WeTransfer
Whenever users click on a task in the checklist, they get an error message, as if they do not have permission to edit the task status.
From what I understand, the checklist component should allow users to update task statuses, so I’m not sure what’s causing this issue.
Does anyone have any ideas on how to fix this?
Thanks in advance for your help!