I was wondering something I made a pivot table using a 3 a SQL query table that combine 2 data sources.
So this table as filters and all the data I want. But i was wondering if it would be possible for a user (given the proper right) to have some sort of way to add info from the report itselft.
Here is the case.
So the report for example takes the time log entry from Zoho People and we use this to charge the customer once per month. When they bill the customer I would like them to be able to check a box or press a button that would update that table and change/add a status in a column. This way the next month those would not show up if they are already billed.
Because sometime users can make the time log late and those entry could still be in the past month but not have been charge.
So this is what I came up with in my test
So like these entry once they have been billed I would like them to be flag as so with a simple button press. Can't for the life of me see how to do this.
Should I look into Zoho Creator to do this or can this be done in Zoho Analytics?