Thanks for the video. I am a newbie when it comes to the app script. I have managed to make an alert in my spreadsheet. But do you have a video showing what I need to write in the script to get the alert to show up whenever anybody f.ex. adds a new row to the spreadsheet?

It is shown "REF" error code when input the SUMIFS formula and the amount of the stock if following the order of the Product Sheet, It is not following the what we Sort.

Nice

Hi thank you for this wonderful video, may i ask how can i make the sequence number like 3 digits? example: i want it to be 001 002 003.... instead of 1 2 3... is it possible? Hoping for your response thank you

Awesome video. However, is there a way to show users from another domains? If everyone shows as Anonymous, it beats the purpose.

for me it is not populating EditURLLink at all. What to do?

how to make drop-down that only one section or no need to click next

Good info. What if I want the comments to keep inline with the data even updated and not being cleared?

Do you have another video that explains how to have several different numbers in a single cell, and I only want some to increase while others are supposed to stay the same..? Sheets basically only increases the last number, automatically, and keeps anything before that same - no matter how many or what formats.

Eg.. (A1 to A500 column) is blank.. And my clickbox is in C1.. When i clik C1 clikbox , it automaticaly fill A1 with "X" And when i click it again , it went down to A2 with "X" Pls help me Thank you for your time ..🙏🏻

Thank you🙏🏻

Hello my friend.. Can i have your email.. I want to ask about.. How to make a clickbox (oneedit) that when i click it.. automaticaly insert (alphabet/number) on certain column and when i click again it went down 1 column and insert that (alphabet/number) .. and so on.. and so on..

Scripting was so confusing for me, though you explained it very well. Thank you for posting this!

Thank you very much. I knew this was possible but I was lost in the many menus

Why my data base on ref in the stock sheet gettin double, when I input new stock of the same product

Thanks for sharing !

Awesome

How can i get the template?

Can you create a search feature from the form page and if so how?

thanks sir

Could you explain why I'm getting this error? No matches found in filter evaluation?

Will something like this work if the next section of questions depends on the previous section's answers?

hello @practicalsheets for some reasons a get an error which state that "the starting row of the range is too small when i declare the variable responsible. any idea why?

if only they'd support indirect...

shared the file as well but still showing you don't have permission to access the spreadsheet.

You got this wrong again. In each line there is a date. And not all of the items are purchased or sold in one date, its in different dates. Yet you assigned the Total Purchases(in units) and Total Sales(units) in each line. This resulted in the whole FIFO cost flow being WRONG because it did not follow the Item's TRANSACTION HISTORY. The Mastodon T-Shirt for example only had 2 inputs on 7/15 yet you assigned the total of all inputs for that item in that same date which was 7 even though the 5 (7-2) inputs happened in 9/1 which was a later date. Please FIX this. The viewers thought it was all correct and they probably ended up applying it wrong too in their work.

Awesome👍👍👍👍

Is it possible to make a sequence that gets 1 larger every time (maybe with a nested sequence in a sequence?): 0.1, | 0.1, 0.2, | 0.1, 0.2, 0.3, | 0.1, 0.2, 0.3, 0.4 | etc. (i just put | for readability). It seems useful. So far I have been using ROW for sequences with steps of 1 (1, 2, 3, 4, ...) but I struggled to figure out how to do things by for example 2 steps at once (1, 3, 5 ,6, or 1, 1, 2, 2, 3, 3....). Seems like I can at least use this for those cases.

Lifesaver! Thank you so much.

VERY USEFUL ...

Thank you very much .

Hey I've got a question. How would I go about creating a code you mentioned at 9:48 ? I would like to import a .txt file into a select sheet within my spreadsheet using the import via upload feature.

how can i do the next scenario: when selecting a value from model column, the value selected, to be deleted from the initial list (drop down list) so you can see wich value is remaining for selection. thanks

Thank you for the video please let me know if I want a query for a single product and multiple documents and colors ?

Can you make a toturial for making a shoping cart for online store in google site using google sheet as products, price, thumbnail and description which will inject to google site.

Excelente video, tengo una pregunta es posible deshabilitar el boton cerrar del modal para que el usuario no pueda cerrarlo, lo pregunto porque se puede poner un formulario para que se registre la informacion sin tocar sheets directamentr

I've got 5 mins into this video but my requirement code has started using a time format? Not sure where I have gone wrong here

Iam using two sheets from two separate workbooks of my account only and both I am the owner , still its not provide access to other sheet. Cannot understand why. If you can help me to solve this.

Unfortunately Google API is not working anymore You can try any of these 3 alternatives ="api.qrserver.com/v1/create-qr-code/?data="&B11 ="qrcode.tec-it.com/API/QRCode?data="&B11 ="quickchart.io/qr?text="B11 Kind Regards

how can I contact with you if I have a query

Is anyone else still unable to get a QR code?

super

What if i have a save csv file that will be added to the folder, and i want it to grab the next one and adding it in? Example: cities01.csv, cities02.csv, cities03.csv So 1st of the month it will run to grab the previous month report and compile it in the sheet

Syntax error: SyntaxError: Unexpected end of input line: 7 file: Code.gs

This is SO HELPFUL! I love this video but I am coming up with an error. I have multiple columns that need multiple selection and it started to work but after a few rows one of the columns doesnt work anymore. The rest do but one broke. Do you know why?

You're a legend. That's exactly what I was looking for. Thanks!

why it pop up this when i try to save Syntax error: SyntaxError: Unexpected identifier 'myFunction' line: 1 file: Code.gs

This has helped me so much. Thank you for taking the to put such a detailed video out for us. Wonderful

Would like to see an output for this and as well if you can implement in a form a name of who have taken items out would be good as well

16:17 you reference the next video... is there a next video? Can't seem to find a next video. in my case would want to use letters from the name in combination with current date/time. for example johnSmith might become johnsm20240828_20:14 or johnsm20240828_20-14. This would truly create a uid and some indication of who the uid refer's to. Thanks.