File Management with AppSheet - Real Estate App

AppSheet is a powerful automation tool and can be a great interface for managing document and file workflows. In this webinar, we take an example of a real-estate application and explore the options AppSheet gives us for uploading and working with Files.
Based on comments on: • Automated Document Gen...
00:00
01:28 - Great Ways to Learn AppSheet
03:15 - Create the App and Data Set in AppSheet
09:47 - Connecting Files using a Google Sheet Table and the File Column Type.
15:47 - Nuances of Uploading files using a standard table
19:50 - Connecting Folders in Google Drive directly to the App.
29:38 - Customizing file names
42:30 - Parsing file names to extract information
52:00 - Relating Google Drive Files to another Table in your app with a virtual column.
59:00 - Add a child record to a related table with an Action Button and LINKTOFORM() deep link
Link to the App We Made:
www.appsheet.com/Template/App...
AppSheet Training Bootcamps:
appsheettraining.com/bootcamps
AppSheet Training OnDemand Paths:
appsheettraining.com/ondemand
AppSheet Toolbox Extension:
chrome.google.com/webstore/de...
AppSheet Toolbox User Guide: docs.google.com/document/d/1U...
Expressions Library: www.appsheettraining.com/expressions
Feel free to catch us every week for a new concept from AppSheet Training using this link: appsheettraining.com/webinar

[@MrJackByron]

This is great! thanks for sharing it solved my problem dealing with pdf files

[@AppSheetTraining]

Glad to hear!

[@GamingMemories141]

Great explanation

[@upish_cat6303]

Hi there, I would just like to ask what steps were taken to make sure that the file uploaded to the google drive had the same name without AppSheet modifiying it? Roughly around 41:57 mark. I am having trouble reproducing this.
Thank you!

[@benrubin5238]

Great tutorial! Is there a way to make the [File] text a hyperlink in Google Sheets? Similar to the hyperlink that is created when you upload a file using Google Forms.

[@AppSheetTraining]

Thanks Ben. The most reliable way is to use AppScript to do this. However, there are some other link structures you can try here: help.appsheet.com/en/articles/961605-displaying-images-and-documents

[@benrubin5238]

@@AppSheetTraining Where can I find the code for AppScript to do this?

[@macmacho]

I need that when uploading the file, keep the same name that it has on my pc. It can?

[@macmacho]

Only this thanks

[@jlotica]

How can I change the showed file name?

[@AppSheetTraining]

@Jorge Moreno Should be able to edit the file name within the app. You can also navigate to UX Views and select a different field to show other than the Name of the file. Hope this helps let us know if you have any other questions. Thanks!

[@Mathi3500]

I am working as teacher..I would like to maintain my class students weekly test marks record in appsheet and also like to generate as PDF file whole rows in one PDF file (25 rows in 1 page) but i could generate only one row in one page....for example if I have entered 25 weekly marks in record by using appsheet( I have included HM sign and class teacher sign too)..it means 25 rows in sheet then I try to generate whole rows and column (25 X 10) I want to genrate my whole records in legal sheet land scape ... Is there any way?...pls help me ...it will promote me and my co-workers(teachers).....thank u ..i need a video explaination..I think, text explanation is not easily understandable ...atleast photocopy explanation is fine for me.

[@AppSheetTraining]

Hi @Mind Access ThIef if you would like to sign up for a Tech Talk that would be the best way we can help you: calendly.com/austin-qrew/15min .

[@moses5407]

Must be me, judging from the other comments, but I found this reallly scattered and hard to follow compared to most of the info on this channel and by this presenter.

[@ramysaid2144]

Do not repeat a date in the same field