Видео

Big thanks to you. It was simple and easy to understand. Subscribed

Thank you!

Very cool! In real life situation, I would just do a Pivot table. But this is a good for educaiton.

Spent an hour finding out how to do this. Thank you!

Please help me. When I try to run the editrecord function, it says Error Exception: Range not found. What should I do to dataSheet.getRange("A"+parseInt(newVals[])).setvalue(newVals[]); Sir ?

wow we were so confused for 30 mins but your video changed our lives!

Thank you for the simplified guide.

I like your video

I got the following error when using this formula :-( =SPARKLINE(countif(C4:F4,true),{"chartype","bar";"max",5;"color1",G6}) Sparkline requires more data points. Expected: 2, Found: 1.

Dime esta API está obsoleta, como se puede actualizar?

Thank you for your tutorial, this is so thorough and easy to follow. I hope you're having a great week!

can you write down the code please?

I have a table that uses and array formula and a VLOOKUP to calculate and post scores in a golf tournament. I use an IMPORT HTML to obtain the field of entries and their respective scores. The first day it works perfectly. The second day the (HTML) site inserts in a row about 2/3 down “the projected cut line”. This blows up my form (#N/A results) and VLOOKUP Table. I can’t edit the HTML table to ignore the inserted row or can I? Or can I modify the range to ignore the inserted row? If so, how? Looking for any suggestions.

So helpful- thank you so much!

it's not dynamic, static.

Seriously the best Sheets training I have come across. Thank you.

this works in most cells but the QR does not show up in some cells even though the data is the same. Ideas?

Hello Sir

Out of all the tutorials I watched, you were the only person to actually explain how checkboxes work! Thank you

Thank you so much 🙏

Thank you! Very informative and easy to follow :)

Good teachers are those who explain difficult tasks to their students in an easy manner, and you are a good teacher. Thank you Sir 🙏🙏🙏

Great video. Super clear instructions. Thank you!

I want the ID to function with a format like: 23456934-K and 23345123-9 any thoughts?

Thank you, this video helped me very much! I'm new to the sheets, so I'm not as good. I didn't know how to use COUNTIF. Thank you again and take care :)

Provide code

Very very useful in understanding query context in Google Sheets

Sir, please help me. When I try to run function searchrecord, it say TypeError: Cannot read properties of undefined (reading '0'). What should I do? I follow all your code but get that error while you are not. Please help me

Exactly what I was looking for "Google sheets payslip automation no add ons" "Google sheets payslip using functions" had to go through a lot before I came here ty.

Thank you this is super helpful. Is there any way to see the total for each category as well? TIA

Hello, thank you so much for the amazing content. I tried to do it as it was explained, however, it did not pull the results as expected. Are there any errors in this formula? =QUERY(DATABASE_CALLS!$A$2:$J,"SELECT * WHERE A='"&B1&"' "&IF(B2="","","AND B='"&B2&"' ")&IF(B3="","","AND D='"&B3&"' ")&IF(D1="","","AND I='"&D1&"' ")&IF(D2="","","AND H='"&D2&"' ")&IF(D3="","","AND G='"&D3&"' ")&IF(F1="","","AND E='"&F1&"' "),1)

Thank you so much. This is exactly what I was looking to do to create a resource for my students. I've made my filter and it's working beautifully. Making this brought me so much joy. Thank you! You are a great teacher! Thank you for explaining what each new part did. I learned a lot.

Thanks 🌱🍃

Great tutorial

How are you adding Row ID in the Column E? Is this automated? I have tried using =ArrayFormula(IF(A1:A="", "", ArrayFormula(row(A1:A)))) , but this only works if there are no empty rows at the bottom.

Hi Sir, it seems you minute 42:39, it seems you have cut some steps before (cell H3). In addtion, how to get Row ID cummulative number ? thanks

I'm preparing a weekly pay slip. Can you help me to keep a running record on save to pdf and other features

Hi Sir, it seems you minute 42:39, it seems you have cut some steps before (cell H3). In addtion, how to get Row ID cummulative number ? thanks

👉🔔

i have problem @ 56;22, . it said that on line 42 has an error caused by cells is not defined...what should i do?? thanks

I found this to be very clear and extremely helpful! Thanks so much!

very nicely done - congratulations and thank you very much

Great tutorial! Very handy. Is it possible to make formula for filter or slicer to display needed data by checkboxes right in main data set, not creating additional set on right?

i couldnt run the script, like at 24.58......it says "ReferenceError: cells is not defined..addRecord @ Code.gs:15". could you explain?

Great video ! Detailed lesson and video. If I ask. Is there way where we can sync the data entry to google documents? It's like automated form. I hope you can answer my question

very nice teaching style - congratulations and thanks very much

Goodmorning Sir, my Name is Joseph Aniebor . I am An Internal Auditor from Abuja Nigeria. i would love to have a conversation with you in respect of Data entry validation a project that i have been on for over a month. I would love a personal conversation. Please how can i reach you Sir?

What if i edit that search data & want to save as new data i.e. without changing previous data

@toptechkit it still doesn't work. It skipped the cell beneath each day, but it also skipped the second week and the third week.