Appsheet Episode 32: How to use LOOKUP ( ) in your app. Quick tutorial to retrieve data from a table

[@acidacesen6804]

Once again I want to say this tutorial help me I have been searching for all morning (and yesterday) for more than 6 hours on how to select specific data from a column where the condition from two different table need to be the same Thank you so much for this simple and clear tutorial

[@aris_azhar]

The pleasure is all mine! Appreciate your support i am attending to your other comments shortly..there's alot more to share on Appsheet! 😎

[@robecala]

These kind of examples are very useful... Thank You very much!!

[@aris_azhar]

It's a pleasure! I am very thankful that this helps you in a way. Thank you for supporting!

[@s2_p_2524]

Crisp and simple . Thanks 👏🏼🙂

[@aris_azhar]

Glad you liked it!

[@hermawanyulianto2645]

Thank a lot..., simple and good explanation.

[@aris_azhar]

You are most welcome Good Sir! Glad you liked it

[@mmmaxi4717]

Very good tutorial!! Thank you very much! I have a query, how do you do it for when you select the product ID allows you to search for it by keyboard and by a drop-down list? Like when you select the product ID box, "Search" appears and allows you to search by keyboard and by the drop-down list. It's something very simple but I don't know how to achieve it, please help me. Thank you very much in advance

[@MUHAMADSHAHRIZALBINABUBAKARKPM]

salam tuan, mcm mana nk look up dari data markah murid, contoh A- 100 hg 80, B- 79 hg 60, C - 59 hingga 40... sebab data markah ada markah range.. terima kasih

[@aris_azhar]

Waalaikumussalam Tuan, maaf atas kelewatan, sibuk dengan kelahiran anak baru2 ni. Anyways, pasal comment Tuan, lookup dalam case ni maksudnya mcmana tu? nak labelkan, filter atau mcmana tu ya? sebab bergantung pada situasi

[@trollwarlord15]

Hi can i ask a question, how to add a validation if product ID is not in product table you can't save from form table. PS dont know what is called THanks

[@codigonaestrada]

When you select the Product Id, how to add that search line when I click on it?

[@aris_azhar]

LOOKUP([_thisrow].[WHICH COLUMN IN THE FORM], "THE OTHER TABLE", "COMPARE WITH THE OTHER COLUMN", "WHAT TO DISPLAY") LOOKUP([_thisrow].[PRODUCT ID], "PRODUCT DATA", "Product ID", "Product Name")

[@SirLoin16oz]

Hi Aris. Thank you for this video! Love the content you create! :) I have a stupid question that I hope you can help with: - I set up your AppSheet to allow the user to select the Product Name - instead of the Product ID - via a dropdown (specifically: Enum with Valid If) - Now, the PRICE no longer shows in the app. If I remove the [_THISNOW], the PRICE reappears, but it shows only the same price no matter what PRODUCT NAME I choose. May I ask how you'd fix this? Sorry for bothering you. I have been struggling with using your model as a template the past week, and I really stuck. Would appreciate your help.

[@Theshibananda]

Hi, can you help me with a lookup function expression where I have to search the value of column 'Rate', when value of column 'Item' is what has been entered in this row and column 'Date' is the latest date with same 'Item' name basically I want to know how to use lookup function for multiple conditions.

[@brunhenk]

Hi Joe! How are you? Sir, I have a problem with my App. When I search for itens in my cart, return all itens in my stock. But, I don't want return itens with stock = 0. I wish return just itens with stock > 0. Do you undertand me? Can you help me? I'm waiting for you a thank you very much for your attencion. ***Sorry my English, I'm Brazilian***

[@aris_azhar]

Hello! I'm pretty sure i can try to assist you. Se possível, compartilhe o acesso ao seu aplicativo e deixe-me dar uma olhada

[@brunhenk]

@@aris_azhar Hi! I create a Slice. It is resolved my problem. Thank you very much for your attention.

[@RAFAELGARCIA-cy4fc]

How would I do this data extractiion if I need to extract the latest data? For example I have two sheets one is "Patients" and the other is "Appoinments". The "appointment" sheet I have a column called "appointment date" and in the "Patients" sheet I have a column called "next appointent." I want the column called "next appointment" in the patient sheet to be automatically updade with latest input from the column "appointment date" from the appointment sheet. I'm able to extra the first appointment entered in the appointment sheet, but when I enter a new appointment date the new date does not replace the previous date. In fact, it only record whatever date I enter first and the subsequence dates are not updated. Can some some point me somewhere I can read on how to do this? Thanks.

[@NIE_SriLanka]

I tried a lot to send messages to it via Appsheet to Telegram, but it was not possible. i can't see any errors. Please help me

[@aris_azhar]

In telegram did you use Group or direct message to a profile? this is only possible through group.

[@NIE_SriLanka]

@@aris_azhar now fixed it. how to send messages to selected telegram groups using bot

[@sathivenkatagangadharreddy536]

tq sooo much

[@TechSoliac]

the question is how is your Product ID column set to Text but in the form it shows a list?

[@03AAB]

Awesome

[@aris_azhar]

thank you!

[@diqueipravida1037]

Hi, thank you for your lessons. I take advantage and ask if you offer your services? I have the "pre point" database. With id of who will register. I separated the app sheet by category, (I need to insert two initial categories and within these categories I need to insert questions with answer options. These answers, when filled in until the end, must be added to obtain an evaluation grade. There are 100 questions in one category and 40 questions in another category. Some questions must be signaled by a color to alert that it is an important factor that the answer be positive. The answers must be out of the ordinary like (yes/no), there would be 3 options of alternatives to define. Concluding the answers, it is interesting to be able to send this type of 'audit' checklist by email or drive (Word, PDF style). Can you help me?

[@jeaniyolomangila3898]

Hello Aris, I need you a concern regarding the use of LOOKUP, in principle this function only uses the data in a table, but I would like to use it to extract the data from several tables for example in a school students registered in the KINDERGARTEN section , PRIMARY, and SECONDARY I used the OR function but it doesn't seem to work OR(lookup([_thisrow].[MATRICULE],"PRIMAIRE","MATRICULE","NOM"), lookup([_thisrow].[MATRICULE],"SECONDAIRE","MATRICULE","NOM"),lookup([_thisrow].[MATRICULE],"MATTERNELLE","MATRICULE","NOM"))