AppSheet Office Hours: Discover new AppSheet databases and No-Code Chat Apps

Can we export data from the database to sheets as many reports are built from there in our organization. will there be a function or click to export to Google sheets. Like, specify the range like in import range formula.

Does the AppSheet database leverage any existing Google data storage technologies or is it "fully proprietary"?

We're going live for today's Office Hours shortly! Join us to discover new AppSheet databases and No-Code Chat Apps.

• Join the livestream: https://youtu.be/rh_hVSe6KC0 

Try this.

How to Create a Countdown Timer in Google Sheets (chromeunboxed.com)

Will there be possibility to add a timer. 

For examples I want to build an app that I can calculate how long does it take to do some chords. I would like to make a stop and star and continue buttons for that. 

And also I would need a cowntdown timer with adjustable starting time, and a sound alert when the time reaches zero. 

Can we have a better integration with google calendar? Specifically, can you make the time zone editable? The assumption that the current user's time zone shall be used does not hold in international setups (e.g. bulk upload calendar events in various locations from a spreadsheet). 

---

@martincalzada wrote:

Any chance of getting CSS control over the UI?

---

Hi @martincalzada, thanks for this question. Can you please expand on which UI you're referring to exactly? Thank you! 

Database:
I am struggling to understand the benefits to a data store based on Google Tables. It looks like one would need to build scripts to conduct simple tasks such as bulk adding or exporting rows from a table. I have no idea how else you would manipulate existing data. There are no formulas, so things that are so easily done on Google Sheets such as VLOOKUPs are not available. Relationships still need to be defined separately in AppSheet . I did not see  a performance benefit is a simple prototype as far as adding and updating individual records, so it would be helpful to have a very specific scenario to look at where performance (syncing and/or transactions) was improved over google sheets. In the end, Google Sheets are highly integrated with other sheets and other tools - this is very isolated and not likely to have a future ecosystem, so I do not really understand the investment in resources.

Web-Browser Dashboard
It will be very helpful to have a web-browser dashboard views that are more stable in the layout and more visually appealing, so I am looking forward to seeing the updates.

Charts
There are still basic features to charts that could turn them into a useful tool - most notably data labels on scatterplots. A grouping capabilty would drastically improve charts as well. There were new chart "features" introduced a few years back and I have never used them - my apps that have charts use the original charts because they work much better. Is this something that AppSheet can prioritize? 

IMHO, AppSheet is a great tool, but so much development focus seems to be on  entry level "features" that have little practical use and not much focus is on supporting real no-code innovation for experienced developers. Critical aspects of Bots seem still undeveloped or unexplained. Being able to schedule tasks in hourly increments would be great. The charts as mentioned above. OCR that can read and find fields in simple forms.... 

TY

George

Can you please discuss how to make the dashboard more intuitive with better functionality. Would be great to import data directly into different slices within a dashboard instead of navigating to separate areas where that slice data can be captured. Why not have an option to add the data to a dashboard view.

Can we create dashboard in appsheet Data base by pulling data in existing google sheets? This would be very useful. 

Our organization has been utilizing Google Tables extensively.  Will Google provide ways for us to port to Appsheet easily?  How long will we have before Google Tables are completely subsumed by Appsheet or will there be a Google Workspace component of Tables within Docs/Sheets?  I am very excited to go to the next step in Citizen Development with Google Workspace!

Fuera excelente si lo tradujeran al español

Is it planned to allow references across appsheet databases? The current table limit per database requires me to create more than one appsheet database to develop my business logic.

The pricing for this database feature ..

will it be available with the core plan ?

then only it will be widely used by majority.