The Reports capability in Creator is nice to quickly display data, but opening the data in Zoho Sheets does not help the user make changes to the data. Is there a way to specify a View to open with criteria set by the Report data.
Example for Pivot Table:
Date = x axis
Number of Sales = y axis
Product = data
Clicking on the 'Product' number hyperlink in the pivot table displays the data in Zoho Sheets. Could a pre-selected View open instead with the same criteria, Date, # of Sales and Product. Then users can easily select Edit to change the record.
Is this possible?
I have created this using html using <a href....#View:AllSales?Area=<%=selected area%> etc.....
If Reports was capable, I could use a function to pass data to a Report, instead of html coding all possible conditions in html.