User Based Logic: Definition
7:09
User Based Logic: Introduction
4:34
Goal Tracker App | Use Case
4:00
2 жыл бұрын
AppSheet Pricing Explained! [2021]
4:31
AppSheet XY() Expression
0:47
3 жыл бұрын
AppSheet LATLONG() Expression
1:07
3 жыл бұрын
Пікірлер
@ashivns
@ashivns 23 сағат бұрын
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.
@radjivcurial1170
@radjivcurial1170 Күн бұрын
Hey Camron, could you please provide the link of this app? I want to try to rebuild it.
@radjivcurial1170
@radjivcurial1170 Күн бұрын
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.
@DustmanDiagnostics2
@DustmanDiagnostics2 2 күн бұрын
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.
@AppSheetTraining
@AppSheetTraining 2 күн бұрын
Copy the app here: www.appsheet.com/template/appdef?quickStart=False&appId=1f177368-3613-4cf4-9a6b-f059a3e68276&appName=QREWCRMAug1-Template-672988#Manage.Author.TeamWork
@emmanuelg.adzaworlu6295
@emmanuelg.adzaworlu6295 5 күн бұрын
Help me set-up a SQL database
@bounsanongvongphachanh823
@bounsanongvongphachanh823 6 күн бұрын
What about limit 2500 row meaning in plans.
@MrSandipcpatel
@MrSandipcpatel 6 күн бұрын
i have in sheet male 1 female 2 and Transgender 1 how can i sum this
@andirifan8034
@andirifan8034 8 күн бұрын
make speed to 1.25, it helps for me
@AppSheetTraining
@AppSheetTraining 6 күн бұрын
For sure! As a native English speaker I speed up tons of videos, but I want our videos to be as accessible as possible for AppSheet's non-native english speaking audiences.
@syedimranSC
@syedimranSC 8 күн бұрын
The naming should be QR code Scanners rather than Barcode Scanners. Thanks.
@elliotdingus
@elliotdingus 9 күн бұрын
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!!
@AppSheetTraining
@AppSheetTraining 9 күн бұрын
Thanks for this comment, glad it's clicking now!
@minhxuanho3878
@minhxuanho3878 16 күн бұрын
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 ?
@AppSheetTraining
@AppSheetTraining 15 күн бұрын
Interesting thought, I'm not sure and honestly I'm not sure what my assumption would be either if it have to sync before pushing the changes from table to table or not. Might have to look into this next week, let me know if you beat me to it .
@user-hh9xj8zw1b
@user-hh9xj8zw1b 20 күн бұрын
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?
@patrickpuma
@patrickpuma 24 күн бұрын
Brilliant. Thank you for this
@IndaloRobotics
@IndaloRobotics 29 күн бұрын
It would have been beneficial to see what the link to the form does!
@IndaloRobotics
@IndaloRobotics 29 күн бұрын
i would have liked
@steve293
@steve293 Ай бұрын
A true example of great visuals and horrible instructions that reflect only 1% of what the topic was supposed to cover 🙄
@CristianLopez-qd3qb
@CristianLopez-qd3qb Ай бұрын
Thanks
@Cithulu1
@Cithulu1 Ай бұрын
Thanks!
@matenggroup3821
@matenggroup3821 Ай бұрын
Does need to pay subscription?? for push notification
@dgrolfe
@dgrolfe Ай бұрын
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.
@TheSrinikaranam
@TheSrinikaranam Ай бұрын
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).
@AppSheetTraining
@AppSheetTraining Ай бұрын
You would nest an AND function inside of the second parameter of the SELECT function. In the AND function just separate your logical statements by a comma. Like: SELECT(Users[Emails], AND([user_role]=“Admin”,[user_dept]=“Sales”))
@pappy101
@pappy101 Ай бұрын
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...
@c-04-poojaavhad47
@c-04-poojaavhad47 2 ай бұрын
How to add related inspection
@omanogafanhoto
@omanogafanhoto 2 ай бұрын
genius. thank you
@edilsonqueirozdeoliveira2855
@edilsonqueirozdeoliveira2855 2 ай бұрын
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.
@mondo_telematico
@mondo_telematico 2 ай бұрын
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?
@BettySwollocks13
@BettySwollocks13 2 ай бұрын
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.
@mamathadayala50
@mamathadayala50 2 ай бұрын
What if i want only one? Based on other column condition
@simondalgas9702
@simondalgas9702 2 ай бұрын
How did you add the Last Week or Next Week button filters?
@user-fv4fm9tq9f
@user-fv4fm9tq9f 2 ай бұрын
What is the formula to subtract one data point from the previous data point, if they are both in the same column but separated into rows by date?
@richneeet
@richneeet 2 ай бұрын
Gracias por el tiempo
@malihazaman9944
@malihazaman9944 2 ай бұрын
Thanks for these helpful videos. I'm trying to set a date range (example: if we want to check payment received in the last 30/ 60 days, I'm trying to set a date rage filter so management can check cash inflows from their phones for a particular period). Could you please help me on this?
@MIS-sv1qj
@MIS-sv1qj 2 ай бұрын
Dear Appsheet Man, i want to create some function in my appsheet app. do you give your valuable hint for achive my goal.
@AppSheetTraining
@AppSheetTraining 2 ай бұрын
What are you wanting to implement?
@dheepannair4232
@dheepannair4232 2 ай бұрын
If a simple app can be deployed for free as long as its user count is 10 and below and it only uses basic functions, what’s the purpose of buying or purchasing a starter plan?
@antruongdiep9595
@antruongdiep9595 2 ай бұрын
Can you tell me the differences between this and the security filter where I use the same line of code?
@AppSheetTraining
@AppSheetTraining 2 ай бұрын
For sure, I'll use a 'Users' table as an example: - A Slice, what I used here, creates a filtered instance of a a table with a separate name that you query in an expression and use to power views. This means the original table goes unaltered and contains all of the other users. - A Security Filter, rather filters what records are synced into the app. This expression applied to the Users table's Security Filters would make it where the only record in the User table is the 'current user'. Conclusion: If you want a user to have the ability to see other users you'd go for the Slice route, but if you want no users' records to be brought into the app other than the current user's you would put it in the security filter. Let me know if you have anymore clarifying questions? Pinning this question because it is a natural stream of thought from the idea of this video, thanks for asking.
@ashivns
@ashivns 2 ай бұрын
Will AppSheet send notifications only to app owner if is prototype
@AppSheetTraining
@AppSheetTraining 2 ай бұрын
Yes, that is correct.
@AllRoundGhana
@AllRoundGhana 3 ай бұрын
How can I save the OCRText () results in another column after generating results with a virtual column?
@juandiegoorozco5531
@juandiegoorozco5531 3 ай бұрын
You are a genius, thank you for so such a valuable information. some times the little and simple things that really matters are the hardest to find, but here you are, offering them in a short video straight to the point, thank you very much.
@AppSheetTraining
@AppSheetTraining 3 ай бұрын
Glad you found it helpful! Think it might have started as a bug, but has turn into more as a feature. Nonetheless, glad AppSheet has kept it in
@melchorjosephdelrosarioirr9188
@melchorjosephdelrosarioirr9188 3 ай бұрын
can we make the ID to be sequencial? not random generated values?
@ibrahimosama9300
@ibrahimosama9300 3 ай бұрын
thanks for the video guys i have a question and i'm pretty sure it's not possible but just making sure can i make an action in a child table that gives me an input pop up to directly edit a value in the parent table?
@wandsfc
@wandsfc 3 ай бұрын
Very good, already waiting for more :)
@AppSheetTraining
@AppSheetTraining 3 ай бұрын
Thanks a ton! Working on another video now! -Cam
@robgevw
@robgevw 3 ай бұрын
The tutorial cannot be followed after time 20:33. As others have mentioned, when following your steps exactly there is nothing showing after the "Order Description" form field: the section beginning with the text "Line items entries that reference this entry in the Order ID column" and the "New" button that follows are not present. You must have performed some steps offscreen that were not covered in the tutorial. Very frustrating for new users.
@akjohn31
@akjohn31 3 ай бұрын
Great video
@AppSheetTraining
@AppSheetTraining 3 ай бұрын
Thanks KOJO
@robgevw
@robgevw 3 ай бұрын
Thanks for this. Wish you would have started at the beginning of App Creation (you had some things already set up) and remove your head bubble so we could see the breadcrumbs for View and Table at the bottom of the preview, as well as seeing where you clicked. Great that you shared the app so we can reverse engineer some things, but frustrating when we can't follow along exactly.
@AppSheetTraining
@AppSheetTraining 3 ай бұрын
Thanks for the feedback, never have received feedback about us covering the Table/View Hyper Links (Breadcrumbs). Surprised, because that seems like a useful info for tutorials. We'll keep that in mind moving forward.
@SamHalesJr
@SamHalesJr 3 ай бұрын
This is becoming pretty exciting
@AppSheetTraining
@AppSheetTraining 3 ай бұрын
Agreed! AI is going to be most accessible and consumable when it gets integrated into NCLC environments like AppSheet.
@davidsoulsby1102
@davidsoulsby1102 3 ай бұрын
Since when did calling yourself an expert become a thing? Just wondering as it used to be seen as narcissism and bragging.
@akjohn31
@akjohn31 3 ай бұрын
Because they earned it through hard work which most people dont go through
@AppSheetTraining
@AppSheetTraining 3 ай бұрын
We are members of the 'Google Developer Experts' program, Google runs the program and qualifies members. QREW has 6 of the 8 AppSheet GDEs in North America. It's not a self given title, but one from Google for them recognizing our Proficiency in the Product and Building a Community around the product(This KZbin Channel). Here's a link to the GDE Site: developers.google.com/community/experts If you review the Expert directory you'll find Stefan's name as well as 5 other of QREW's developers.
@tanjidahmedjony4667
@tanjidahmedjony4667 3 ай бұрын
It's Not bad But It works better. { INPUT("Project",[Project]) }
@DustmanDiagnostics2
@DustmanDiagnostics2 3 ай бұрын
I have been finding more and more uses for the INPUT function, it is a very powerful tool. Thanks for the breakdown on the non-beta application. Will the old beta function continue to work or should I change them all over? Thanks again
@kailsati
@kailsati 3 ай бұрын
Fabulous 🤗
@TanjidAhmedJoni
@TanjidAhmedJoni 3 ай бұрын
Is it possible to base64 an image column type image using Ai?