Відео

Really good teacher. Thank you🙂

How do i create a two different pdf report one from the main table and another one from the slice table

thanks for the video. I think you should split values by " , " not like this " ,"

This video is so good and straightforward! I really appreciate the clarity you bring to each step - it’s super helpful. Please keep going; looking forward to more content like this!

I love the way you explained everything. Very easy to understand. Thanks for sharing.

Wow. Thanks a lot.

hello gus, help, how if have start number and end number , how to implentasion using loops for create separate row. thanks

nice work brother I've tried to seperate rows with action using loop and another way is loop with bot but nothing can surpass the power of script lightning fast and not a single records missing

Very informative tutorial and presented very good. Thank you!

Great! Thank you!

Your contact number

Thankyou, you are an excellent teacher, please, keep doing this kind of material

How u build this app make project videos asnu sent before ❤

Very helpful for creating more diverse menus and depth to each section! Thank you!

Great video! Pls give a pointer how to adapt the app to products with sub categories. Like bike spare parts, car spare parts. Just a pointer

Just found this video liked it and saved it, I'll be back to it soon after completing my app to apply UI/UX from this. Keep up G

Thanks a lot, I'm waiting part 2

When you upload next video, already like your video and waiting for next part

I have a question, how are you logged in with your microsoft account and can use scripts? If I login to appsheet with google, I can use the scripts but not when I login with my ms account.

Thank You So Muchhh

How did Evva end up having a membership account at Accra Academy?🥰

i´m from brazil. I really like your videos...congratulations

Hi! How can i get the Name for example and not de id from the record to show on the google sheet? because in the app it shows the name but in the sheet it shows the id. Thanks for the video!

thanks can you share google sheet or make an appsheet app as public?

Brother this works pefectly, but my question is how can I delete rows when I delete the parent , I mean I want to delete all automatically created rows when I delete the parent record

Brother How can I reach you? I need your help with Project+task management app I am building which is similar to the video you created.

Thank you very cool video. Could you please explain the example with several columns? Enumlist that would be great

Hope you don't mind, but I copied the function test to prove it, and here it is so anybody can use it too function newrows() { let url = "URL OF YOUR GOOGLE SHEETS" let spreadsheet = SpreadsheetApp.openByUrl(url); let sheet = spreadsheet.getSheetByName("NAME OF THE WORKBOOK SHEET") let lastRow = sheet.getLastRow(); let idCell = "A"+lastRow //estas son todas fijas y se repiten tal cual let dataCell = "B"+lastRow //estas son todas fijas y se repiten tal cual let courseCell = "C"+lastRow //estas son todas fijas y se repiten tal cual let studentIdCell = "D"+lastRow //esta es la celda que tiene muchos enumlist seleccionados let selectedstudents = sheet.getRange(studentIdCell).getValue(); let arrayOfStudents = selectedstudents.split(','); let numOfStudents = arrayOfStudents.length; for (i= 1;i<=numOfStudents;i++){ let nxtRow = lastRow + i let nxtidCell = "A"+nxtRow let nxtdataCell = "B"+nxtRow let nxtcourseCell = "C"+nxtRow let nxtstudentIdCell = "D"+nxtRow sheet.getRange(nxtidCell).setValue(sheet.getrange(idCell).getvalue()+i); sheet.getRange(nxtdataCell).setValue(sheet.getrange(dataCell).getvalue()); sheet.getRange(nxtcourseCell).setValue(sheet.getrange(courseCell).getvalue()); sheet.getRange(nxtstudentIdCell).setValue(arrayOfStudents[i]); } sheet.getRange(studentIdCell).setValue(arrayOfStudents[0]); }

Excellent solution. Congratulations!

Thanks for such a wonderful tutorial. What happens, if i update the existing record to have few more enumlist values selected. I tested it, but it is not inserting new rows. It is just looping and updating the first row to have only 1 value. So ultimately, New update is not stored anywhere in the database. Here is my observation on this issue: Instead of start inserting new rows from the bottom, it is trying to recreate new rows from the same old (middle of the table) row number. Please advise

This was very educative. Looking forward to your next video

Insightful🙏🏾