Using multiple tables in AppSheet

Check out the previous episode → goo.gle/3pXJ26C
When enterprises deal with vast amounts of datasets in different tables, they need to be able to recognize relations between these datasets. In this episode of Building with AppSheet, we show you how to use multiple tables in AppSheet - allowing you to automatically recognize relations in data and apply references. Watch to learn how you can use AppSheet to quickly identify relational data for your enterprise!
Timestamps:
0:00 - Intro
0:20 - Extending the ‘Tasks’ application
0:43 - AppSheet References
1:30 - Demo: Intro
2:00 - Demo: Creating an app from a Sheet
2:40 - Demo: Adding an Owners Table
4:03 - Demo: Adding an Owners View
5:17 - Demo: Trying out the app
6:21 - Summary & More Info
Watch more episodes of this series → goo.gle/BuildingWithAppSheet
Citizen developer learning path → goo.gle/3GqKebL
Subscribe to Google Workspace → goo.gle/GSuite
product: AppSheet; fullname: Christian Schalk;
#BuildingWithAppSheet

[@barmolino]

I did a test. This App sheet is awesome and mind blowing option for the spreadsheet data with all options and funcs, formulas etc.

[@mariasnaider3759]

Thank you from us at AppSheet!

[@hjehlers]

Powerful!

[@untukhp7483]

I inserted the second table and it appears on the bottom of the screen phone. On the other hand, I also wanted to insert the third one but it does not appear and shows as reference with the logo of 'insert'. How do I solve that problem?

[@itdepartment2263]

I need the view, in the "ref" field to automatically show a value from the related table, how can I do it? thank you

[@jaymehta6333]

This video is no 3 in playlist but should be no 2.

[@alvin5107]

Hi, how can get total of child form to parent form?

[@emilioestebanjimenez4711]

I have a problem, when a column has a formula. The next register go until the last row to record it. Does someone know how to solve it?

[@zaydc7316]

hi, what about using multiple sheets? i.e a single sheet (potentially with multiple tables) PER USER, each user having their own sheet, associated only to them. Is this something that could work with appsheets? Thanks

[@NdCharlesNweke]

Same question I came for. Were you able to sort this out?

[@zaydc7316]

@@NdCharlesNweke No I wasn't, I have given up on that for now. Let me know if you find a solution !

[@michellecasey7172]

How hard is this to use, It looks awesome but also looks like a lot of work and complicated

[@andriuspleska4283]

Hello. Question - how to sort an exel table if one of the data is GPS coordinates ? I constantly need to sort in groups of 8 nearest coordinates. How can I do it faster?

[@usmankhan5397]

Some kindly refered me the link to add multiple UI through app sheet

[@microcontrolledbot]

The cost is outrageous when your already paying per user per month for workspace. And then to pay another per user per month fee to use this (yea i know it's "free" ... for now but you can see the pricing table). And on top of that the actual database integration doesn't even show pricing you have to open a sales team request...

[@WormholeVenue]

Why does only one of my tables, the first one, show up in the app.
I’m trying to make an app of multiple checklists for employees to submit.

[@hamedrajhi]

From where did app sheets got the profile images of the owners?

[@JasonTM1]

The Owners table had a column named Photo which contained URLs pointing to each photo.

[@hamedrajhi]

@@JasonTM1 Thank you that's totally make sence

[@JeremiahTownsend]

Come on guys, love you, but please, if you’re referring to a previous demo video (Tasks), add the link?

[@mariasnaider3759]

Hi Jeremiah- please find the link in description or here for easy access: goo.gle/3pXJ26C

[@tuycsbmsyld4468]

@@mariasnaider3759 a

[@petersoncpxb]

Trying to do so, but appsheet isn't recognizing it as ref. So I am doing it myself, but I doesn't work

[@eudesgrangeDGC]

Same. And the virtual column isn't created. Basically the reference isn't detected automatically like it's supposed to.

[@petersoncpxb]

@@eudesgrangeDGC I figured it out. Put ref and open the menu and inside it there is a drop-down menu with all your collums. Select the proper one.

[@eudesgrangeDGC]

@@petersoncpxb Perfect, it's not automatic like they say but it's quite easy to manage. Thank you !

[@petersoncpxb]

@@eudesgrangeDGC yeah, it took me sometime to work with ref

[@jamesbottomley2596]

As far as I can tell, this doesn't work - AppSheet does not automatically create ref for a co-named field as in your example.

[@uniquelyunrulydaniel4575]

i really just dont unserstand this app