When Data-Studio connects to an AppSheet app, does it see? 1.Tables which are based on Google Sheet. 2.Slices which are created on AppSheet. 3.Virtual columns which are created on AppSheet.
I would love to give a case scenario, I want to order 40 items, and they are all documented in a csv file, is it possible in appsheet to upload the form, and it scraps the items and adds the items in their subsequent fields in appsheet?
You can create an action that uploads csv files. Follow these steps: 1. Create a new action of type import a Csv file 2. Assign to the table that you want to import the data to 3. Ensure the prominence is set to Primary. 4. Create a table or deck view You should see a button when you go to the view you just made that let's you upload the CSV file. The CSV needs to have the same names as the target table.
Perfect! Thank you... Would we be able to implement security filters for this, especially if we have multiple companies using one app (I've added a multi company login system to my appsheet app ) so that I put have to manage updates and development for the one app.
I have not tried this but it seems possible. support.google.com/datastudio/answer/9713766?hl=en#zippy=%2Cemail-filter-examples. You can use data blending to associate allowed email address to each record. support.google.com/datastudio/answer/9888200
It’s possible to create reports with multiple filters, i guess as much as you want for all data fields Check this ruclips.net/video/WJuy-UMXvo0/видео.html
Great video, take your like
Thanks for liking :)
Great tutorial, how to bring dashboard (data studio) into appsheet app ? thank
You're welcome!
I have same question like you😌.
Have you found the solution, sir? Please share it with me if you have already found it. Thanks!
When Data-Studio connects to an AppSheet app, does it see?
1.Tables which are based on Google Sheet.
2.Slices which are created on AppSheet.
3.Virtual columns which are created on AppSheet.
It shows Tables and Slices. Virtual columns are not supported at the moment.
@@appify
I would love to give a case scenario, I want to order 40 items, and they are all documented in a csv file, is it possible in appsheet to upload the form, and it scraps the items and adds the items in their subsequent fields in appsheet?
You can create an action that uploads csv files. Follow these steps:
1. Create a new action of type import a Csv file
2. Assign to the table that you want to import the data to
3. Ensure the prominence is set to Primary.
4. Create a table or deck view
You should see a button when you go to the view you just made that let's you upload the CSV file. The CSV needs to have the same names as the target table.
Perfect! Thank you... Would we be able to implement security filters for this, especially if we have multiple companies using one app (I've added a multi company login system to my appsheet app ) so that I put have to manage updates and development for the one app.
I have not tried this but it seems possible. support.google.com/datastudio/answer/9713766?hl=en#zippy=%2Cemail-filter-examples. You can use data blending to associate allowed email address to each record. support.google.com/datastudio/answer/9888200
It’s possible to create reports with multiple filters, i guess as much as you want for all data fields
Check this
ruclips.net/video/WJuy-UMXvo0/видео.html
Hello dear can we add data studio report in AppSheet please share video if possible
I hear this is coming very soon.