Please add a capability to include a filter when defining a Data Mesh. It can be a pre-existing filter from source sheet, such as is available when creating a dynamic view.
Sign in to see the current vote count, add your own vote, or leave a comment.
It would be helpful to have the ability to filter data when using Datamesh. (Please, not a report, they break so easily.)
I would really like to see the ability to choose from the most recent version of a particular ID number when running a Data Mesh, rather than the first ID number it happens to find. I end up manually archiving rows to a separate sheet simply because of this lack of feature (because I need to have the most recent version available and cannot automatically archive based on dates).
Available Solution: "
You can DataMesh using a report as a source. So if you filter the report to the employee's 'main department' for each main department sheet, then you'd be able to mesh information of that employee to target sheets they're on, but isn't their main department.
"
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
I have project with automations sending emails based on specific criteria in the row. These automations are sent via email with a form to acknowledge receipt of the automated email. It would be fantastic if there was a way to track/ensure the email was sent without the need to send a copy of the automated email to my inbox.
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…