Im currently building an app for technician/supervisors and (chatbot) for customers to log complain.
What i did?
currently i have a chatbot app for customers to log a ticket on defects for a building on another hand in the same app i have another slice which serves as the
backend service for technicians to receive notification based on tickets created by customers and also to log a ticket. However this option has a limitation in terms of views for the chatbot.I have restricted certain columns in the sheet to only be viewed by technician and this works. However certain slice which is meant for technicians still appears in the chatbot. When i restrict the show_if to only technicians it works however the view for technicians can only be set to “gallery” or “detail”. This is not proper as technicians needs to swipe left/right to view new/current jobs rather than having a list of it.
Option 2 created two different app for chatbot and technicians Shared the same google sheet however unable to add new entry from technicians side as there’s error which states "Table xxxx does not allow new entries’.
Appreciate if you guys could advise which option is better and workable.
FYI for option 1 im 90% near completion and just started exploring option 2