Reports are a great way to visualize data in the way you'd like: filtered, grouped, summarized, and sorted.
The problem is they lack the ability for a user to ADD a row.
Example: If I give colleagues a filtered view of data that are relevant to them (say, from an underlying sheet they don't have access to), they can easily edit rows that exist but can't add rows without leaving the sheet and accessing a form.
That friction makes them less likely to add data. Especially when using the mobile app where they can't have multiple tabs open simultaneously (there's another idea).
I imagine adding this ability is complicated for many reasons. BUT a simple solution is to provide for a big + button on the page that can pull up a form.
Hello,
please consider to the capability to add a new row in a report or edit the formula or change the formula in a report directly instead of going back to the original database.
thanks,
Franklin
I second this. I would love to be able to add a row (with new data) to a sheet through a report. The report is a powerful feature in that it allows us to limit what the user sees from the Sheet (or sheets) so managing a massive Sheet is easier, when the user only needs to see a few fields. Using a form is fine too, but a Report can be more powerful tool.
Would definitely love the ability to add a row directly through the report. It will streamline the process for our users so that if they are updating data, they don't have to update in place and add new information in another. Right now, we have to do silly things like adding placeholder rows they can edit specific to each report (which complicates our underlying data sheet) or having them go two places to do something that should really just require one click. We even tried filtering to show blank fields, which worked inconsistently (aka didn't work).