Fill in another sheet based on a certain topic.

I am building a app for a daily tracker of issues. I want to be able to copy certain issues to another sheet each department is in charge of. So when using the app you will select a disscusion point like "HR related issues" and then next field is a text field to put the issue we are having. I want any time the discussion point is selected it copys those issues to another sheet. I was thinking maybe a Bot setup. 

0 1 87
1 REPLY 1

It's very rare that copying a record to another sheet is the optimal solution. It's better to not unnecessarily duplicate data. If you have records of the same entity, but in different "category" (departments, locations, people, etc), you should split them up with Slices or Security Filters.

https://help.appsheet.com/en/articles/895302-slices-the-essentials

https://help.appsheet.com/en/articles/954497-security-filters-the-essentials

https://help.appsheet.com/en/articles/1128148-limiting-users-to-their-own-data

----

If you really do need to copy the data to a new sheet, yes a Bot can do that. Or a Form Save Action. Both of which would probably just be a "add new row" type action.

Top Labels in this Space