thank you for this great tutorial! helped me a lot!

@TechTrickswithEli2023

Ай бұрын

You're welcome!

Great tutorial. Keep this up. I love the way you simplify the process

@TechTrickswithEli2023

9 ай бұрын

Glad it was helpful❤

It took me for a day to work my sheet properly. Thank you so much for the instructions!❤

@TechTrickswithEli2023

4 ай бұрын

❤❤❤

Thanks its working great 🎉

it worked perfectly! i have a question, i added a dropdown instead of a blank box, but i want to add another dropdown with different words, how can i add the other one to the formula? :(

Thank you!!! Very good video. You solved my problem!

@TechTrickswithEli2023

7 ай бұрын

Glad it was helpful❤

Eli you did very well, very good presentation,I love it

@TechTrickswithEli2023

9 ай бұрын

Glad it was helpful ❤

great . i saw your both google sheet and this video. excellent

@jalalkia-gi8vl

9 ай бұрын

What's difference between crud and Google apps script

Very good Eli, your video is clear enough 👌❤️

@TechTrickswithEli2023

10 ай бұрын

Thank you 🤗

Thanks for your help

@TechTrickswithEli2023

6 ай бұрын

Happy to help

very useful and superb explanation.

@TechTrickswithEli2023

9 ай бұрын

Glad it was helpful❤

Thanks a million

@TechTrickswithEli2023

8 ай бұрын

🌹🌹🌹

Usefull, thanks

@TechTrickswithEli2023

9 ай бұрын

Glad it was helpful!

thx

@TechTrickswithEli2023

9 ай бұрын

Your welcome🌹

Hi Eli, appreciate the work. Try to make a video on creating HTML form with dynamic drop-down fields for inventory booking. Fields 1. DATE 2. PO Number 3. INV/DN number 4 item Group. 5. Item code, 6.Item Description 7. PO Qty 8. Received Qty till date 9. Receiving qty 10. Balance Deliverable 11. BATCH 12. User Remarks. All quantities except point 9 can be output only gray fields.🎉

@AlphaVox

8 ай бұрын

There will be a PO master sheet in the hiding to pull relevant data. 3 sheets total. 1. Form 2. DATASHEET 3. PO Master. So po idea is when the user select a PO, except point 3,9 and 12 should be picked from the PO master and give the user only those option thats available under the PO selected

@AlphaVox

8 ай бұрын

Any previous records of receipt of items with the same PO should be calculated and presented under points 7,8 and 10

@AlphaVox

8 ай бұрын

Hope I have covered the specifics

How do you make this to grow with a sheet? Do i need to keep changing the columns range? I want to do this for a datasheet that has a growing addressbook on it.

thanks for this great tutorial! i´ve got one problem, when looking for specific data - i´m looking for climbing routes in my database - for example 7a - but i receive 7a and 7a+ - how can i find 7a only? thanks!

Hi Can you help me How can i make it different work book

the formula works, but I have an issue, I have a lot of columns with data with some blank rows, for example from A to L i have data, but L to Z no data at all, then from Z to AZ I do have data, I have to move the sheet for a long time with other rows that go up to HZ, I would only like to display the data, not the blank cells, something like an autoamtic adjustment of the columns how can I fix that? in the same formula? or is there an option in google sheets?

Please give a link google form projects where has a advance search option

My formula getting error

@Abstractmindzent

6 ай бұрын

mine too, it would only show the first entry on a2 and not other ones.

This only works if there are no blank cell in the data range.

Hello. What is the formula for searching more than one database (sheet)?

@TechTrickswithEli2023

7 ай бұрын

I will make a video for your question

Can I have the link to the spreadsheet please?

@TechTrickswithEli2023

Ай бұрын

Hi check the description❤

What if I have 2 sheets of data?

It doesn't work for me.... its an ERROR......

@TechTrickswithEli2023

6 ай бұрын

Please Explain your error more

It's not work for me It's ERROR