Hi. I am having big trouble creating a very simple, basic app. I’m trying to use for internal purpose only to track tickets. Every time I open a ticket it has to drop points for one client, max points are 100. I created a table All clients, added manually UniqueIDs for relation purpose, I created TicketTable and also I created ClientManager table, managers who maintain the clients.
I tried everyway to build tables that whenever I add a ticket for one client, it drops 1 point and to have dashboard to see chart of 100% clients and the ones 90-99 and the ones 0-89
Any help?
What have you tried so far?
Are you creating a ticket from the details screen of a client? Do you have a workflow with two main actions, the first adds a ticket to the tickets table and the second increment the clients points by -1?
When you “complete” a ticket, does the point go back up or is this more intended on how “satisfied” a client is?