Sample App - for those who are beginner to intermediate (Dashboard, Map, Chart etc)

[tsuji_koichi]

Just created sample app for those who are new to Appsheet and/or on intermediate level to share some of the tricks to build up dashboard with chart etc. using Appsheet Dashboard interactive mode, plus some other tips I introduced in the commuinty before.

Getting live web data regarding Cornavirus outbread case and extracting to the google sheet to use as data source for this sample.

The origin of the app is just one table, but generate the master table out of it using also unique() expression of Googlesheet, and use Google free addon to get the latlong for the Country.

Sample app is available in my company portfolio here.

[Kirk_Masden]

Fantastic job! I like your use of the tabs. Was this something you got from @Marc_Dillon’s recent tip, or did you already know about it?

Tabs in Detal Views

To make your Detail Views have tabs, similar to a how a Form view can have them, follow these steps: Either create slices for each “tab” of your table, and their corresponding detail views, or just create detail views with different column order settings. Create a dashboard view that holds all of the above detail views. Make sure to select “Use tabs in mobile view” Create an action to navigate to this Dashboard view for a specific row LINKTOROW([key column] , “dashboard view”) Set the Row Sel…

[Kirk_Masden]

Shouldn’t this be in “Tips & Tricks” too?

[tsuji_koichi]

Yeah, sorry my fat fingers!

@Aleksi Sorry for troubling you again, could you move to tips and tricks if you never mind?

in terms of use of tabs, you mean my dashboard?

[Aleksi (Aleksi Alkio)]

Done

[tsuji_koichi]

thank you for your usual help!

[Kirk_Masden]

Don’t you think it would be nice to have column headers in the tables inside your tabs? I just noticed that we don’t have this.

[tsuji_koichi]

I dont know which view you are referring to? Could you put a screenshot?

[Kirk_Masden]

Sorry for not being clear. This is what I’m thinking about:

Tabs in Detal Views

One more thing . . . Here’s how I’m trying to use the tab function: [Screen Shot 2020-02-29 at 22.25.54] I have a table in which I use lots of abbreviations to avoid wasting space. The abbreviations are explained in the detail views that the table links to, but I wanted to have general explanations, in English and Japanese, about how the table is intended to be viewed, where to find explanations about the columns and the data they contain, etc. I think the tabs are very good for that. One …

There are some screenshots on that page.

[Kirk_Masden]

On your app, what I mean to say is that from this view . . .

. . . if one scrolls down . . .

. . . one can no longer see the “GaugeChart,” “Country, Other,” and “Total Cases” headings.

Your app is really good but I think that it would be nice if this aspect of the dashboard view could be improved by AppSheet.

By the way, the headings are only lost in “tab” view. The same headings remain visible, even with scrolling, when the dashboard is viewed on a large screen.

[Juan_Gutierrez]

cannot access, this message appears User ‘1568719’ does not have a valid ‘google’ account

[Jordan_Davis1 (Jordan)]

Hey Tsuji,

First of all, I read through your posts all of the time and I really appreciate your contributions, they’ve been enormously helpful. I’d love to take a look through this app but it’s not working (I think you need to regenerate the columns for Sheet 2). Thanks again!

[tsuji_koichi]

thanks for your comment. This app is no longer maintained, unfortunately…