Відео

Thanks Landan for another AppSheet video. I try to take away as much as possible from any of AppSheet Training's videos whether they pertain to what I am working on or not. Never know when it may apply but in a different context. These tidbits of information have made my app what it is today. Even though it is structured around a single user, that user being myself, I still use dynamic expressions explicitly throughout the app just for my own UX and to break up the monotony of what I call "cookie cutter" apps. For example, changing the localization settings to something a little more humorous rather than your typical boring "cancel", "save", "back" options, I've included phrases like; "Forget about it", "Put in the memory warehouse", "Whoa, did you see an alien back there?" Just to liven it up a bit. My personal favorite is making display names dynamic. Having the display change based on criteria is amazing in my mind, down to pluralization based off a COUNT() function or a running total using a SUM() function and in some case both combined in a CONCATENATE() function ("&"if you prefer). You and Stefan have taught me so much in the past two years, for free mind you, I'm super appreciative of you and the entire QREW team. You deserve much more attention than it receives. Regardless, good job guys and gals!

How to scan multiple inventory IDs in the same row without moving to other row

Dude anyway you can help me convert my AppSheet into this

Hi. Watching from south africa. Thanks for your work. Been looking for how to build my own CRM and avoid paying so much for zoho etc.

Thank you for your video. It is very good to see where are the limitations. I personally was surprised how much more helpfull ChatGPT was for building my app in comparison to Gemini. But hopefully Gemini will improve over time.

I make 300 column's in google sheet and because of that my App was getting slow to sync ...what should i do

The link you have provided is not working, Please provide a new link 🙏

my menu just wont appear

Thank you Sir...now my apps already usable.

Thanks Camron for the insightful part 2 of the CRM app build. I never thought of using a VC to use as an inline action placeholder, very creative workaround. I can sense your frustration doing these live streams because of the time crunch. I know just from watching how you perform that this CRM app could be worlds better given more time to clean up the small details and possibly think for a minute without the pressure of being live and remembering screen share, lol. In my app, most every visible column name has a dynamic display name, even if it's just to pluralize by using a COUNT() function. Like having one item displayed would say "1 installed item for $X.XX" or multiple items "3 installed items for a total of $X.XX" as the display name for an inline ref view inside a detail view. The flexibility of AppSheet is amazing, and with an imagination, so much can be accomplished. Learning how to use the functions is what takes the longest time. With no formal training and with only what I found on the AppSheet Training and Google Community websites I have learned from the best. Looking forward to part 3 of your app🦾

Is there any formula or expression for remember last value(text) in a text box remain same text after submit until we edit that again

You deleted the demo app

Hi in the HTML long text format, is it possible to display child records in a table as well with looping (start, end tags)?

i have been learning from your videos n started making an app . now i got stuck cant see anything like that on ur video.i have put details of one person then i give same as above yes n no. when selecting yes i wana copy above details. any way to do that? 🤔 really need ur help 😊

I recommend that the next training video has an example of what is being created and how it will be used by users because without it, it's difficult to understand the big picture.

Thank you! Great session!

nice.... I have long time waiting for...

Following from Rwanda, East Africa. Thanks for these helpful appSheet tutorials.

This is really helpful, thank you!!🙏

You do not say what field I should attach the expression to (like a URL), or a special button. Neither do you then show a working example. It would be so awesome if you did! For instance, I have a view (list) of concerts. I have another view of ALL the concerts and repertoires(the songs). Starting at the Concerts view, I want to click on one concert and jump to a filtered view of repertoires that ONLY shows me the songs for the selected concert. For starters, I will make the concert title the location for my link... Let's go see if this works. Sound good?

Do you guys have an appsheet community I can join

Please suggest expression to filter parent record based on products in child record, from product column in filter dashboard. Products are added as line items in parent table.

Hey Camron, could you please provide the link of this app? I want to try to rebuild it.

Thank you! Could you possibly create a turorial for a app for the financial sector? For example, for small businesses or the billing department? That would be great.

Thanks Cameron. Didn't learn anything new yet, but was awesome watching how you built your CRM app. Too bad I missed the livestream. I'd like to share my app and get some input on possible improvements but the time it would take would be considerable. Great content as always.

Copy the app here: www.appsheet.com/template/appdef?quickStart=False&appId=1f177368-3613-4cf4-9a6b-f059a3e68276&appName=QREWCRMAug1-Template-672988#Manage.Author.TeamWork

Help me set-up a SQL database

What about limit 2500 row meaning in plans.

i have in sheet male 1 female 2 and Transgender 1 how can i sum this

make speed to 1.25, it helps for me

The naming should be QR code Scanners rather than Barcode Scanners. Thanks.

Thanks a million for this tutorial. It took me a bit to get it working on my own app as the translation of some things wasn't quite as smooth as expected! Nevertheless, it's now working and I'd have never got to this point without this video -- thanks!!

Hi, thanks for sharing great tips. I wonder if the duplicated User table is in sync with the original user table in case of any moditification is occured in the original table ?

hey i want to scan ISBN of book. so when I scan that ISBN, the app would show the identity of the book. how to do that?

Brilliant. Thank you for this

It would have been beneficial to see what the link to the form does!

A true example of great visuals and horrible instructions that reflect only 1% of what the topic was supposed to cover 🙄

Thanks

Thanks!

Does need to pay subscription?? for push notification

This never shows the final result. Does the slice save in a new tab in the datasheet? Does this only affect a certain view? What is a slice used for? You've only shown that a slice is a filter, essentially, but you didn't show how it's used.

What is the syntax if there are multiple conditions. In your example, i want to select user_email when user_role is "Admin" and user_dept="Sales" (assume user_dept is another column).

So i do power apps and a few other "low code" platforms for one of the worlds best known enterprises and i have to say the columns tab is nice...

How to add related inspection

genius. thank you

Hello! Excellent content! I would like to know if it is possible to create a Web Form with AppSheet so that someone else without access to the system can fill it out. A form that I take the link and forward, as well as on Google Forms.

Hi, can you tell me how I can manage the booking of a B&B, I have a room table and a reservation table with an arrival date and an exit date and I would like a view that by selecting a date shows me the free rooms. Can you help me?

Hi, please could anyone help, I have created an app (my god it isn’t easy) any how, I have 10 identical vehicles and I have created a spreadsheet for each in sheets, each vehicle having a different serial number. I have then created an app in app sheets but on some of the options I have created drop down menus e.g. different drivers, different, destinations, different jobs etc. Now rather than repeating the data input for each vehicle, can I just duplicate each app and then just change the name of the app to the serial number I want- It’s the drop-down menu inputs that I do not want to manually fill in, it will take me an age…..any help greatly received. Thanks.

What if i want only one? Based on other column condition

How did you add the Last Week or Next Week button filters?