I am creating a ticketing system with multiple department

Hi All,

I am beginner here in Appsheet. I create a ticketing system and I can't figure out how can I direct copy the details on other sheet.

Ex. I created a new ticket and I chose IT dept. (It's Enum list)
I want to see this details on IT sheet only .(BTW I have 3 department which IT, Marketing & Building Admin)

Please help what and where function I need to input on these.

Thank you

 

0 4 340
4 REPLIES 4

So it could be your app structure. Make one sheet to host all the tickets. Have a table with your departments and their keys that reference to those tickets. Will require parent child table connection. Then differentiate the tickets from a view row filter.

You can create a slice view for each department.

Just filter rows of each slice by your department column:

Slice TI: [Departament]="TI"

Slice Marketing: [Departament]="Marketing"

Slice BA: [Departament]="Building Admin"

And create a new view for each department using their matching slice.

 

Hi MiguelPilo,

Thanks for your response, How about if I don't want to make a slice per department, cause I will use the slice when I separate a staff per department. 

It is possible?

Thank you

You can use the same Slice for many diferent views. Not problem with that.

Top Labels in this Space