Distribution of tasks between employees

AppSheet AppSheet Q&A
, ,
1

Hi, I create an application in which people report IT problems, in the report form from the drop-down list depending on the choice, the task is assigned to a different department. Several people work in each department. The question now is whether there is any way to distribute tasks between people. For example, so that tasks are allocated sequentially and equally?

2

Task is assigned basis department or per indivisual?

3

Create a helper table to manage the task queue and use actions to add, modify and delete tasks.

When adding tasks, set the assigned to and other fields as required. Delete tasks when they are completed.

2 Likes
4

per individual

5

Do you have access to Appsheet API?

1 Like
6

until now I did not know that I could have. I need to read about it

7

If you can use Appsheet API, then you could namage what you want. But I m not sure any other workaround to achieve without API…

1 Like
8

Thank you very much for the tip,I will explore this knowledge about API

9

FYG, you need business subscription in order to use Appsheet API features, which probably you need to bear in your mind.

10

Thanks a lot for all the advice

11

Welcome.

12

The tips and tricks @Steve introduced may solve your problem. I just had a thought.

[FAQ: add a set of rows](https://community.appsheet.com/t/faq-add-a-set-of-rows/30846) Tips & Tricks ?

When a row is added to a table, add a set of rows to another table. Try the sample app! This example uses three tables: Master Table: when a new row is added here, all rows from Source Table will be copied to Target Table and linked back to the new Master Table row. This table must allow adds. Source Table, from which all rows will be copied to Target Table. Target Table, to which all rows from Source Table will be copied. This table must allow adds. Action 1: Copy Source Table row…

4 Likes