Відео

super - very nicely done and explained - thank you very much and best of luck with your great channel. Question - why did I get an email from Google saying; File upload limit reached IT - Issue Form has stopped accepting responses. This form supports file uploads and is limited to the collection of 1 GB of files. The file upload limit has been reached, so this form is no longer accepting responses

Very interesting project, thank you. You can add a search function and it will be very practical!

Amazin work! Thanks a lot for shere your skill

I want that when we select the userName, the email should automatically appear in the Email field.

Hi, I want to use this "Tamotsu" library in another spreadsheet, Kindly share me the library's script ID so that I may use this form in another spreadsheet

Is it possible to resize the text fields to fit two or three fields in one row on HTML form? Can you share your email address for further guidelines?

HOW CAN I GET THE GOOGLE SCRIPT CODE?

how if customer buy more than one varian item?

Nice work , Thank you

👋 In this video, Nice and very impressive. Request for student's admin panel. 🎓 Admin Panel for Student Information: Complete CRUD Operations we’ll dive into building an admin panel for managing student information. Our system will allow you to perform essential CRUD operations seamlessly. Let’s break it down: Create (Add) Student Records: Use the admin panel to add new student records. Collect details like Student ID, Name, and Contact Number. Optionally, upload student photos (multiple photos supported). Read (Retrieve) Student Records: View student information from the database. Search for specific students by ID or name. Update Student Records: Edit existing student details. Update contact numbers or other relevant information. Delete Student Records: Safely remove student records View and print student information. Organize students into classes. Remember, a well-designed admin panel streamlines student management, making it easier for educational institutions to keep track of their learners. 📚✨ according to your channel’s style, and happy coding! 🚀

Hi, Do you have any example of the reverse case?

Hello, I love this video however, when attempting to modify an entry automatically right after the submit button is pressed, the field that I'm trying to modify the entry doesn't show anything. How can I modify the code so that I can get the field to automatically update for me

Pls admin panel CRUD 🎉

Hi, sorry for bothering you guys. Instead of sending invoice pdf files, I want to send email marketing template, how should I change that? P/s: great project

please admin dashboard, student record program

🎉🎉🎉wow

if you want to have a dynamic list of values in a dropdown, that gets dynamically updated when new rows are added to a table that its key serves as the foreign key, do as follows: a) define the sheet as a table b) define a NameRange on the column in that sheet c) in the Options column in the Schema sheet for the table that has a foreign key to another table, set the Options value to "=join(",",NameRange)", where NameRange is the name you defined for in the referenced table

Extending a table with a new row, when there are formulas on some of the columns - I added a piece of code for that. following is the create(data) updated function: // Create a new record create(data) { const id = this.getNextId() || 1; data[this.ID_COL] = id; data["Challan No."] = id; //Get 2 dimensional Array Data from dataset const headers = this.sheet .getRange(1, 1, 1, this.sheet.getLastColumn()) .getValues()[0]; const newRow = []; for (const header of headers) { newRow.push(data[header] || ""); } this.sheet.appendRow(newRow); // Get the last row number after appending const lastRow = this.sheet.getLastRow(); const lastColumn = this.sheet.getLastColumn(); // Check if there's a row above the newly appended row if (lastRow > 2) { // Get formulas from the row above const formulasAbove = this.sheet.getRange(lastRow - 1, 1, 1, lastColumn).getFormulas()[0]; // Apply formulas to the new row, but only where formulas exist for (let col = 0; col < formulasAbove.length; col++) { if (formulasAbove[col] !== '') { let formula = formulasAbove[col]; // Adjust row references in the formula formula = formula.replace(/(\$?[A-Z])(\d+)/g, (match, column, row) => { const newRow = parseInt(row) + 1; return column + newRow; }); this.sheet.getRange(lastRow, col + 1).setFormula(formula); } } } }

🎉🎉🎉❤❤❤ you are creating wonderful content

🎉🎉🎉🎉wow nice

Can we use on excel?

Another awesome video! Thank you. Question tho what app or tool you're using for the voice over?😅

is it possible to update the dropdown list of 2nd dropdown based on selection from dropdown list 1?

Tôi hy vọng : bạn có thể tạo cột Description là dạng dropdown lựa chọn (cột A của trang tính Option của ggs) và khi chọn 1 Item nào thì cột Rate sẽ được lấy tương ứng (cột B của trang tính Option của ggs). Cột Description dạng search theo từ khóa khi gõ vào hộp thoại.

Please multi sheet web and admin sheet

❤❤❤

Please check email spam :)

Thank you for sharing this video. It would be nice, if you show how to create it step by step

Tuyệt vời

I really love watching your all amazing vedios.

❤❤❤

🎉🎉🎉🎉🎉🎉🎉

Where is the code?

Thank you for your sharing!

it doesnt work when i add vlookup function in the sheet. it will fill the cell where it doesn't have the function in it. is there any way to prevent this?

Excellent tutorial. How to prevent users of web app from editing certain fields.pls help me.

Can this be automated to update the google form whenever the google sheet is updated

How about adding edit function please

This is amazing! Thanks a lot! Can there be a upload option to upload a file insted of a link upload

This is awesome! Thank youuu. This is helful for booking system

❤❤❤❤❤❤❤❤❤

can I ask to update the link of the demo sheet thank you

anyone knows what is the purpose of "Parsed Data" SHEET ?

this is some great stuff. i am fairly new to this type of coding so was wondering if there is an option to only show certain key items from projectschema tab on the New Item form but still show them all in the web app itself?

FELICITIACIONES. ; *) sos el mejor.... 1. El video dice solo lo que tiene que decir ! Excelente 2. Acceso a un Código hemoso...! Notable 3. Funciona sin dramas... MARAVILLOSO Gongyos para ti

Cancel button doesn't work. It submits the form data just as the submit button does.

Can you do some modifications so this can match my needs. I’ll pay you for that. Thank you

Thank you so much 😎😎😎

I have a suggestion and I hope you consider it 😏. It’ll be great if you could add one parameter that customize search by adding one drop-down field contains (Equal, Start with, Ends with, Less than and grater than) and filter will be applied accordingly 👍🏼

Like always, informative. Please teach how to display the same in a webapp