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Күн бұрын
Hey Camron, could you please provide the link of this app? I want to try to rebuild it.
@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.
@DustmanDiagnostics22 күн бұрын
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.
@AppSheetTraining2 күн бұрын
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.adzaworlu62955 күн бұрын
Help me set-up a SQL database
@bounsanongvongphachanh8236 күн бұрын
What about limit 2500 row meaning in plans.
@MrSandipcpatel6 күн бұрын
i have in sheet male 1 female 2 and Transgender 1 how can i sum this
@andirifan80348 күн бұрын
make speed to 1.25, it helps for me
@AppSheetTraining6 күн бұрын
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.
@syedimranSC8 күн бұрын
The naming should be QR code Scanners rather than Barcode Scanners. Thanks.
@elliotdingus9 күн бұрын
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!!
@AppSheetTraining9 күн бұрын
Thanks for this comment, glad it's clicking now!
@minhxuanho387816 күн бұрын
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 ?
@AppSheetTraining15 күн бұрын
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-hh9xj8zw1b20 күн бұрын
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?
@patrickpuma24 күн бұрын
Brilliant. Thank you for this
@IndaloRobotics29 күн бұрын
It would have been beneficial to see what the link to the form does!
@IndaloRobotics29 күн бұрын
i would have liked
@steve293Ай бұрын
A true example of great visuals and horrible instructions that reflect only 1% of what the topic was supposed to cover 🙄
@CristianLopez-qd3qbАй бұрын
Thanks
@Cithulu1Ай бұрын
Thanks!
@matenggroup3821Ай бұрын
Does need to pay subscription?? for push notification
@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Ай бұрын
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Ай бұрын
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Ай бұрын
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-poojaavhad472 ай бұрын
How to add related inspection
@omanogafanhoto2 ай бұрын
genius. thank you
@edilsonqueirozdeoliveira28552 ай бұрын
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_telematico2 ай бұрын
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?
@BettySwollocks132 ай бұрын
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.
@mamathadayala502 ай бұрын
What if i want only one? Based on other column condition
@simondalgas97022 ай бұрын
How did you add the Last Week or Next Week button filters?
@user-fv4fm9tq9f2 ай бұрын
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?
@richneeet2 ай бұрын
Gracias por el tiempo
@malihazaman99442 ай бұрын
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-sv1qj2 ай бұрын
Dear Appsheet Man, i want to create some function in my appsheet app. do you give your valuable hint for achive my goal.
@AppSheetTraining2 ай бұрын
What are you wanting to implement?
@dheepannair42322 ай бұрын
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?
@antruongdiep95952 ай бұрын
Can you tell me the differences between this and the security filter where I use the same line of code?
@AppSheetTraining2 ай бұрын
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.
@ashivns2 ай бұрын
Will AppSheet send notifications only to app owner if is prototype
@AppSheetTraining2 ай бұрын
Yes, that is correct.
@AllRoundGhana3 ай бұрын
How can I save the OCRText () results in another column after generating results with a virtual column?
@juandiegoorozco55313 ай бұрын
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.
@AppSheetTraining3 ай бұрын
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
@melchorjosephdelrosarioirr91883 ай бұрын
can we make the ID to be sequencial? not random generated values?
@ibrahimosama93003 ай бұрын
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?
@wandsfc3 ай бұрын
Very good, already waiting for more :)
@AppSheetTraining3 ай бұрын
Thanks a ton! Working on another video now! -Cam
@robgevw3 ай бұрын
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.
@akjohn313 ай бұрын
Great video
@AppSheetTraining3 ай бұрын
Thanks KOJO
@robgevw3 ай бұрын
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.
@AppSheetTraining3 ай бұрын
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.
@SamHalesJr3 ай бұрын
This is becoming pretty exciting
@AppSheetTraining3 ай бұрын
Agreed! AI is going to be most accessible and consumable when it gets integrated into NCLC environments like AppSheet.
@davidsoulsby11023 ай бұрын
Since when did calling yourself an expert become a thing? Just wondering as it used to be seen as narcissism and bragging.
@akjohn313 ай бұрын
Because they earned it through hard work which most people dont go through
@AppSheetTraining3 ай бұрын
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.
@tanjidahmedjony46673 ай бұрын
It's Not bad But It works better. { INPUT("Project",[Project]) }
@DustmanDiagnostics23 ай бұрын
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
@kailsati3 ай бұрын
Fabulous 🤗
@TanjidAhmedJoni3 ай бұрын
Is it possible to base64 an image column type image using Ai?