ASSIGN TASK TO A REPRESENTATIVE BASE ON TYPE OF REQUEST

I have an app which takes in complain and request.

I want an automation to assign these complains or request base on the department that will resolve it and assign to the personnel on duty. below are the tables.

how do I go about it please?

Achiever2023_3-1710407298192.png

 

Achiever2023_5-1710407351529.png

BELOW IS THE TABLE I WANT AS OUTPUT, (auto assign the task base on user complain/request)

Achiever2023_0-1710408432292.png

 

 

 

 

Solved Solved
0 18 233
1 ACCEPTED SOLUTION

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Achiever2023 

Sorry for answering that late.

I built an app to get exactly your point I realized I was missing the complaint/department matching part.

I built this: 

Aurelien_1-1710830209177.pngAurelien_2-1710830246582.pngAurelien_3-1710830262540.png

Aurelien_4-1710830278397.png

 

and I set these settings:

Aurelien_5-1710830330070.pngAurelien_6-1710830345495.pngAurelien_7-1710830358917.png

Aurelien_8-1710830451726.png

 

Eventually, I got this (small record of the result):

https://share.zight.com/BluqeJoj

 

View solution in original post

18 REPLIES 18
Top Labels in this Space