Greeetings
I am a newbie to Appsheet and have been given the task to design an app for my company. I have 2 tables. A “tasks” table with columns of task_id, dept_id and name of the task. I have another table, “departments” with columns of dept_id and name of dept.
I would like to create a reference between the tasks and departments table on the dept_id, and then slice the resulting list and extract certain tasks for a department. Below, an excerpt of the tasks table, and the department table can be found.
| dept_id |
task_id |
name |
| 5 |
1 |
Safety Glasses |
| 5 |
2 |
Gloves |
| 5 |
3 |
Safety Boots |
| 5 |
4 |
Branded Jacket |
| 5 |
5 |
Pants |
| 5 |
6 |
Hard hat |
| 4 |
7 |
Collect office keys and fob’s |
| dept_id |
name |
| 1 |
Engineering |
| 2 |
Finance |
| 3 |
Analytics |
| 4 |
Legal and Risk |
| 5 |
Health & Safety |
| 6 |
Account Management |
| 7 |
Operations |
| 8 |
General |
| 9 |
Business Development |
| 10 |
EXCO |
I am looking at creating a view, to display the specified tasks for a new employee when they select their department. Please may someone help or direct me to a tutorial or similar question. Thank you
LinkedIn
Twitter
