Ben you have such a friendly and pleasant demeanor I am really enjoying making my way through the on demand trainings. Thank you not only for your knowledge but also your ability to make the topics accessible and un-intimidating! all the best to you!
@@AppSheetTraining of course! I hope to collaborate with you guys in the near future. I've been plowing away at your on demand courses and once I develop some road blocks I'll get back in contact to do some coaching or something!
Thank you for these amazing videos! Just as a suggestion. It would be good that you tried the function to see how it translates into a real action and not just see the formulas. Again, thank you for the content; it's really useful.
Thanks for a great video! It's this a snippet from another longer video? It's the full video uploaded somewhere? What are the differences between Lookup, Select and Filter? I'm still a bit lost. I'm trying to read Steve's articles, but, honestly, if you don't already have a programming background, they are hard to understand (e.g. when you don't know what Syntax or Arguments mean). Also, what if you have multiple conditions? Column 1 = Country, Column 2 = Occupation, Column 3 = Seniority and Column 4 = Rate. App use choose their Country, Occupation and Senority. What expression to use so the chooses the correct hourly rate?
great questions! lookup: returns any column value from one record select: returns any column value from a list of records filter: returns only the key from a list of records SELECT(Table[Column], AND( [Column 1] = Country, [Column 2] = Occupation, [Column 3] = Seniority, [Column 4] = Rate), FALSE) the AND() nest in the SELECT ()’s filter condition will only include records where all those conditions are true. -Cam
Hi! I'm brazilian so sorry for my bad english. I want to know if I can see the expressions I write like in the video (Colorful and with the row number in the left side). If I can, how I do that?
If you are using Chrome for your web browser then you absolutely can! We created a chrome extension that you can find here: chrome.google.com/webstore/detail/qrew-tools/hklmffdokpefcfabkmkpjnkoakehigjg?hl=en-US Following this link and installing the extension will change how your expressions show up in the expression assistant.
It sounds like you are wanting a grouped action! The sub actions would be Data: add a new row to another table using values from this row and then followed by Data: delete this row!
Select and References may take some time to fully sink in. Keep trying to use it, and in a few days of practice the concepts should start to make sense.
Ben you have such a friendly and pleasant demeanor I am really enjoying making my way through the on demand trainings. Thank you not only for your knowledge but also your ability to make the topics accessible and un-intimidating! all the best to you!
Thanks, glad you like them!
Ben wants you to know that he really appreciated the kind words.
@@AppSheetTraining of course! I hope to collaborate with you guys in the near future. I've been plowing away at your on demand courses and once I develop some road blocks I'll get back in contact to do some coaching or something!
Thank you for these amazing videos! Just as a suggestion. It would be good that you tried the function to see how it translates into a real action and not just see the formulas. Again, thank you for the content; it's really useful.
great video btw.
wondaful explanation
Good prasentation
Ben can you show how to make custom email body using info from row and also attach images?
Hi @vvdd903. This week's webinar on automations will cover this topic! You can register for the webinar here: bit.ly/AST-Register
Thanks for a great video! It's this a snippet from another longer video? It's the full video uploaded somewhere?
What are the differences between Lookup, Select and Filter? I'm still a bit lost. I'm trying to read Steve's articles, but, honestly, if you don't already have a programming background, they are hard to understand (e.g. when you don't know what Syntax or Arguments mean).
Also, what if you have multiple conditions? Column 1 = Country, Column 2 = Occupation, Column 3 = Seniority and Column 4 = Rate. App use choose their Country, Occupation and Senority. What expression to use so the chooses the correct hourly rate?
great questions!
lookup: returns any column value from one record
select: returns any column value from a list of records
filter: returns only the key from a list of records
SELECT(Table[Column],
AND(
[Column 1] = Country,
[Column 2] = Occupation,
[Column 3] = Seniority,
[Column 4] = Rate),
FALSE)
the AND() nest in the SELECT ()’s filter condition will only include records where all those conditions are true.
-Cam
Hi Sir,
In appsheets "App Fomular", I want to use SUMIFS amount from another sheets by id, but I can't do.
Please help me sir
Sum(Select(table name [column name], filter condition))
Stefan,
Do you or your company take on small AppSheet design projects on fees?
I think for sure.
Hi! I'm brazilian so sorry for my bad english.
I want to know if I can see the expressions I write like in the video (Colorful and with the row number in the left side).
If I can, how I do that?
If you are using Chrome for your web browser then you absolutely can! We created a chrome extension that you can find here: chrome.google.com/webstore/detail/qrew-tools/hklmffdokpefcfabkmkpjnkoakehigjg?hl=en-US
Following this link and installing the extension will change how your expressions show up in the expression assistant.
@@AppSheetTraining thx for answer, It's helps a lot
how can I copy data from another table and add additional columns ... Where when the data is taken then the data will be deleted in the data table ??
It sounds like you are wanting a grouped action! The sub actions would be Data: add a new row to another table using values from this row and then followed by Data: delete this row!
Can you do a video about this? It could be very usefull.
I don't understand anything. the select() function is very difficult
Select and References may take some time to fully sink in. Keep trying to use it, and in a few days of practice the concepts should start to make sense.