Google Sheets Web App kzbin.info/aero/PLv9Pf9aNgemt82hBENyneRyHnD-zORB3l Google Sheets Sidebar Userform kzbin.info/aero/PLv9Pf9aNgemuzTNWeHd8HziGVNzSlWACh Google Sheets CRUD Userform kzbin.info/aero/PLv9Pf9aNgemvM36efLpaHxbkZTGp2pfhx
@SanjeetKumar-tc5gt2 жыл бұрын
please send the code
@Capinyon2 жыл бұрын
sir i got right my first level of data thank you very much appreciated your help
I copied everything in your script but run button is not available and it says error.
@ppklsakti2 ай бұрын
fieldRange.map is not a function
@kerinahrgang30872 ай бұрын
I love when you "make mistakes" since we then get to see how you fix them! I have been able to automate quite a few spreadsheets and workbooks thanks to your lessons!!!!
@larryflores38492 жыл бұрын
Thank you for the time and effort you put into all your videos, you have helped me impress many of my coworkers
@ExcelGoogleSheets2 жыл бұрын
Appreciate that!
@jenni80752 жыл бұрын
Thank you thank you thank you!! I've been watching your video for at least two weeks because I work long hours and I watched it over and over and I finally paid the patreon membership and was able to complete our new form. I was doing something wrong some how but I just copied and pasted everything in the end and modified it to our form's needs. lol. Keep up the great work!! Looking forward to your other videos.
@ExcelGoogleSheets2 жыл бұрын
Thanks for supporting on Patreon!
@codesheet9441Ай бұрын
Just extraordinary explanation. You explained everything according to necessity. First problem then the solution.❤❤❤
@rybaxs Жыл бұрын
This will help small-time businesses that don't have enough budget for a system.
@invisible.spectra5809 Жыл бұрын
Or people like me in a large business looking to simplify their job. Honestly at this point though I’ve gotten good enough at manual entry it might not be too much faster
@blockwest23792 жыл бұрын
Always a pleasure to watch your tut´s. Espacially the ones from Apps Script. Thank you, sir!
@ExcelGoogleSheets2 жыл бұрын
Thank You!
@user-li3dc9zm6u2 жыл бұрын
@@ExcelGoogleSheets ยินดีต้อนรับยังคง
@johncherish76102 жыл бұрын
I am so glad I found your video, very informative easy to understand and the logic you present behind the scripting very helpful. I watched the video to do this following it step by step and came out with a better understanding that when I started,. I have subscribed to your videos and am excited to learn more
@eddadams59562 жыл бұрын
Thank you. I used this to right my first Script. Works great
@ExcelGoogleSheets2 жыл бұрын
Excellent!
@IRuinEvrything2 жыл бұрын
thank you so much for this video in particular. With this and a few rabbit hole references to chase down the other functionality I need, I've been able to get a new RMA system up and running in three days with nothing but a spreadsheet and some fancy JavaScript, even importing the old data from the previous system on a dying XP box. I appreciate this.
@ExcelGoogleSheets2 жыл бұрын
👍
@88omarz Жыл бұрын
Dude I had to stop watching, you're really good with how you explain!
@ManojGuptahome2 жыл бұрын
Your series of videos are extremely useful. They are so simple and properly explained that the tips given by you can be used at other places. Questions: How can the user jump from one field to next without much hastle or using tab. How do you ensure that entry to a field is completed before a script is executed.
@ExcelGoogleSheets2 жыл бұрын
@How can the user jump from one field to next without much hastle or using tab. Don't really have a good solution for this. @How do you ensure that entry to a field is completed before a script is executed. You would need to validate everything in the script itself before actually making any changes to the spreadsheet.
@josephayo77592 жыл бұрын
@@ExcelGoogleSheets what if you protect unused cells and disable clicking on same, i think this will jump protected cells and go directly to enabled once
@donjuangyn Жыл бұрын
I am really grateful for this video . I could apply all these tips in a new form in my job. Thank you
@ExcelGoogleSheets Жыл бұрын
👍
@Wellingtonasjr2 жыл бұрын
Great video, as always. I wish we had the same functionality as Excel, when you protect one cell and set it in a way that the user cannot select it. This way the user could navigate only through the fields of the form. I've built great forms in Excel like this. When I try to do the same in Google Sheets, it just looks terrible...
@josephayo77592 жыл бұрын
same here too
@Bluegoespewpewpew2 жыл бұрын
Your videos are the greatest, always so insightful. Thank you
@ExcelGoogleSheets2 жыл бұрын
Thanks!
@treasureakpabio4427Ай бұрын
Thank you, this was helpful.
@rajiv6089 Жыл бұрын
Iam Almost a Layman in scripts, Buy Enjoyed what we can do with them , THANKS A LOT !
@jozsefolasz87022 жыл бұрын
I am doing something similar, but in a much more complicated way, with arrays. This is simple and clean code, thank you very much.
@ExcelGoogleSheets2 жыл бұрын
:)
@anthonymaina5572 жыл бұрын
Very informative, wish you included a wa of creating PDF's of the data recorded to serve as invoicing system.
@romainalonso44392 жыл бұрын
Such an amazing video. Thanks a lot for sharing your knowledge!
@ivanurbina24227 ай бұрын
This was AWESOME!!!!! THANK YOU SO MUCH!!! You have made my day!!!!
@John-jt3dn Жыл бұрын
I learned so much from you. Thank you. I am building a production output database and this is exactly what i need. Where can i reach this file to make a copy?
@uzomasochukwuuchechukwu-ag55252 жыл бұрын
You are my hero in google scripts
@ExcelGoogleSheets2 жыл бұрын
:)
@EliPatinoAve2 ай бұрын
WOW! This is fantastic. Thank you!
@vishaleee4042 жыл бұрын
You are doing very great work bro. love from india. i like your all videos.
@ExcelGoogleSheets2 жыл бұрын
Thank you 😀
@pitmahayag7923 Жыл бұрын
@edumunoz77602 жыл бұрын
This was an amazing video, if i could like this a thousand times i definitely would
@ExcelGoogleSheets2 жыл бұрын
:)
@punicaaafps10 ай бұрын
This was really helpful! Thank you!
@Sci-TechOffice3 күн бұрын
Thank you!! But I'm trying to figure out when editing existing data, if I want to let if(id == "A:A") (which means compare to all the values in A:A, if not then create a new record), what should I do?
@osvaldodsj2 жыл бұрын
Aprendo muito com seus vídeos, muito obrigado por compartilhar seus conhecimentos de forma brilhante e didática. Continue assim.
@learnbehappy Жыл бұрын
Could you pls make update record button, Navigation buttons, and print button on form. or already have pls suggest a video.. your videos are BEST!!!
@giedresutkaityte9263 Жыл бұрын
This tutorial was super useful. Thank you very much for sharing. Is there any chance that you could advise how can we adjust clearing content while leaving formulas in certain cells? It clears everything including formulas..
@NahidHasan-xp1cl Жыл бұрын
Wow it's Great Tutorial. Thank You So much
@key76442 жыл бұрын
Exactly what I was looking for, Thank you man
@ExcelGoogleSheets2 жыл бұрын
:)
@johanndaveldebeer9532 Жыл бұрын
Thank you sir, i applied this to a database with 90 data points per row divided in 9 categories and searchable by each. but without your example i would have struggles allot longer
@elizabethdebelen34752 жыл бұрын
Thank you for sharing. I learned so much🥰.
@ExcelGoogleSheets2 жыл бұрын
:)
@amazea50982 жыл бұрын
Verry helpfull for beginer like me, thanks for share
@ExcelGoogleSheets2 жыл бұрын
😊
@hvmlovecomayforever5 ай бұрын
thanks for your informative video
@jcheng19812 жыл бұрын
aht I just need, now i need to figure out how to make a data entry for intructors scheduling, and that will be anble to tell me which date and time my instructor is available to assign the class to him/her
@ExcelGoogleSheets2 жыл бұрын
:)
@rangarao9869 Жыл бұрын
Very Helpful, Thank you
@spicy.banana11 ай бұрын
Super helpful, thank you!! 🙏
@fariady2 жыл бұрын
Thank you very much, I'm trying to incorporate this form in my spreadsheet, but I don't have the ID column in the data, can I use a second column with formula to create some sort of id for each row or maybe I can use the same search column as ID for the saveRecord? thank you
@hinnproject11 ай бұрын
Very helpful! Thank you!!
@superbhatnagars2 жыл бұрын
Dude Just have one last question - I had put up a formula which sums a total amount when I click on the submit button it clears the formula, Can you please suggest a solution for this.
@RahulSharma-uj7cr2 жыл бұрын
Great Video wonderful. More such type of real life example videos especially on google sheet.Thanks Sir
@pvv_live22262 жыл бұрын
Great video, as always. Please, make more tut´s about Apps Script!
@DanielaNavarro-pj3us Жыл бұрын
Hi, thank you for all your tutorials; I´ve started coding with your help, still a beginner but I´m so thankful for all your guidance. I have a question: will this entry form be something that any user that the google sheets has been shared with can use? Also, do you have any tutorials on how to automate getting the last row from a database to fill a google docs?
@yadavpooja79602 жыл бұрын
Great tutorials, thank you.... Can you please make a video on How script and set triggers work in a copied spreadsheet
@PavelLukashevsky9 ай бұрын
Great job!!
@norbaitiak96574 ай бұрын
Hi. Tq for the tutorial. I just have a tiny problem with the script. The error I got was on the onEdit script. It said that the e.range was not defined
@formerly-outdoor-cats8 ай бұрын
Excellent and helpful video. Thanks!
@mcdjohn9128Ай бұрын
can we add some options of manual entries also please? For example id my marketing team member has to fill this they would have the fixed product listed by=ut i they have to mentioned but it one has to fill prices manually it was sold for for multiple product. Please if you could help on this?
@agathekonnerski47532 жыл бұрын
Thanks for your tutorials! Its perfect! 🍺👍🙏
@ExcelGoogleSheets2 жыл бұрын
Glad you like it!
@gasparlam4267 Жыл бұрын
Your tutorial is awesome! I follow this guide and adjusted according to my needs. It works like a charm. For the onEdit(), I have to make it an installable trigger instead of simple trigger in order to make openbyID() to work. BTW, how can 2 or 3 users use the same Page to enter record at the same time? Make 3 duplicated data entry pages and each of them use different page? will it work? Thank you so much for your great work
@marcelcharest76622 жыл бұрын
Thank you so much! You're the best
@pmim9766 Жыл бұрын
Hi, thank you for the helpful video! I was wondering if you could help me figure out how I can automatically add a timestamp as well to the Data sheet when saving a record.
@jinyoungwest108 Жыл бұрын
This is great! Thank you :)
@5j652283 Жыл бұрын
Thank you! It is a great lesson for me, But this is enter data one by one, can it enter several duplicate data one time?
@jeanaimegakwerere859111 ай бұрын
Thank you for your insights. And I would like to know how this APP Script can work on Mobile phone or Tablets?
@makimilder22849 ай бұрын
damn, my brain is overloading now...
@nnchandna25982 жыл бұрын
This is wonderful learning from the video. Is it possible to download the script and try myself?
@surajjadhav36652 жыл бұрын
Hi .... 🙋♂🙋♂ thank you for sharing the valuable Edu. video for us. I learn lots from that video. but I have one quotation, if the file share with another person and i want to only he update the data but not delete or edit after save the changes then how I can do, its possible ??
@Someday-pl9tc Жыл бұрын
Great instructions. I have a question..... How do you amend the Search Function to allow for multiple responses, getting the Form to move from each response to the next? I am trying to use this for a database, for inventory, where it is possible that the search (text box with 80 characters) will return multiple records. I need a way to move from one response to the next.
@onintv27353 күн бұрын
hello i have a problem i want to use search in other cell but onEdit script is can be use in 1 function only how can i add another search in 1 form
@marros1445 Жыл бұрын
Wow what a great tutorial! It was just the thing I was looking for to help with a data entry solution for our staff at a non for profit organization. :-) I'm seriously stuck though and was wondering if you or anyone here had some ideas, as there are a couple of issues I'm wondering if there are solutions for? (1) I've created a button in the sheet via drawing and attached a script, but it's behavior is not like a regular UI button, there is no hover highlight or any feedback that it is working until the script processing message dialog pops up. The issue here is that I found myself clicking multiple times and executing multiple script calls :-( Is there a way to prevent multiple clicks - maybe present a dialog box saying the action was successful? Some workaround, maybe not using a button but some kind of dialog box or other trigger to "submit"/(call the script) the entry. 2) Also, it all works okay (except the multiple clicks) for ME, but this is for people in the organization to do their own data entry, and when I try the sheet from a share link, I get an error message after the script tries to run and stalls? Are there special permissions I need to setup for the worksheets, I'm not sure why it's happening? Here's the link: docs.google.com/spreadsheets/d/1tNBxkRFfuOhSycgZNX3Cv2xvUZOo4xadYfg457wS1x8/edit?usp=sharing Thanks in advance for taking a quick look!
@solaris4152 жыл бұрын
Hi there! Thanks for the useful videos! Question: what if we have more than 4 cells to read? A column of 50 for example. And we need to store that data in a row (transpose)?
@digigoliath2 жыл бұрын
Awesome!! TQVM!
@brianhibben4556 Жыл бұрын
Thanks
@ExcelGoogleSheets Жыл бұрын
Thank You!
@excelx86032 жыл бұрын
thank you so much for saving our time. i'm having an issue while writing onEdit. it says e is undefined. pl guide
@user-gf2tg8bj9q Жыл бұрын
Thank you so much for your great tutorials. May I know how can my data entry be converted to all capitals when it enters the database? Thanks in advance, keep up the great work.
@goldenart_melaka2 жыл бұрын
SIR YOUR VIDEO SO MUCH HELPFUL FOR ME WHO DOESNT KNOW ANYTHING REGARDING THIS..TQ SO MUCH..BUT CAN I ASK U SIR?..HOW CAN WE USE SAME SCRIPT AND SAME SHEET BUT ACCESSED BY MULTIPLE USER IN A TIME..?
@LuciMikTechTalk Жыл бұрын
excellent !! thank you very much!
@cecillejustinbayonito88719 ай бұрын
I have troubles on the onEdit Script. Type error says cannot read properties of undefined (reading 'range') Pertaining to e."range".getA1an.....
@kennethforbin56042 жыл бұрын
Great video again. Anyway to do a form approval process from sheet?
@mateobustamante6688 Жыл бұрын
Hello! Excellent video! I would like to set some required fields, how would you do that? Thank you very much!
@MND222 жыл бұрын
IFNA would’ve been better than an iferror for your search function in sheet 3, fundamentally they work the same since you have data validation but just figured I’d let you know
@ExcelGoogleSheets2 жыл бұрын
Not sure I understand why it would be better, but sure, you could use IFNA.
@MND222 жыл бұрын
You would still want to get an error if you saved without including one of the date fields, such as the first, last, state, or age, IFNA would be better suited if the rows were empty, and not missing just one piece of info. You could use an iferror aswell in that cell to give a bool, and use a script to take that book and not allow the user to leave one field blank on the form
@MND222 жыл бұрын
If it’s not clear, message me personally, or share a copy of the google sheet with me and I’ll show you what I mean
@ming.manangan17 күн бұрын
for the last entry, if the user forgot to click to a different cell, the data wont be captured
@ibrahimbek28042 жыл бұрын
Thank you very much
@harkelin2 жыл бұрын
Hi! Thank you for all of your amazing videos. With your help I've been able to build a system for keeping track of my entire brewing schedule! Now I am looking for a solution to automate and simplify the inpu of data in that same system and this is almost it! Instead of doing a form and populating the data with the push of a Save button, is there a way of doing it with an onEdit function? I am thinking of having a row for inputs at the top of a sheet and then when the last cell in the input-row is edited it sends all the data to another sheet and clears the cells used for the input. Maybe even to send the cursor back to the first cell for a new set of data inputs? If the onEdit triggers on the clear function that might set of a loop, but if it doesn't trigger this would be perfect for my system since I am trying to erase the need to use the mouse to click the button and at the same time speed up the inputs. I know this is a lot to ask from someone who has no obligation to help a stranger more than he has allready done by uploading the plethora of videos you've uploaded in the last couple of years but I thought it was worth a shot. And if nothing else I also got to thank you for your hard work! Best regards!
@petersu56557 ай бұрын
Dear Sir, I am trying to follow your video, but when I am using the Goggle Sheet that I have, I do not have some of the features that you have. May I know what version are you using? Thanks
@academicopifle2 жыл бұрын
Hi there! Thank you so much for this tutorial! Is there a way to also add a picture to the form?
@joannafranky48162 жыл бұрын
Hi, thanks for the wonderful information you share here, I follow you step by step on a google sheet that I want to key in and store data on. and the when I reach to the console.log part, The Info there show [Function], what do this mean?
@fieq_3077 ай бұрын
Hi, if you read my comments, can you help me how I can create the "ID" like UPR 0001 (then become UPR 0002, UPR 0003 and so on) instead of just single number? Thank you so very much in advance for help and this knowledge.
@IntrepidFox2 жыл бұрын
Awesome! Many thanks!
@ExcelGoogleSheets2 жыл бұрын
:)
@temyraverdana64212 жыл бұрын
Thanks a lot, very useful for me
@ExcelGoogleSheets2 жыл бұрын
Glad to hear that
@MP-eq8ih2 жыл бұрын
Until your video I didn't know what a script was. Fantastic and easy to understand. But, like always a question. My data sheet contains 8 columns including currency, numbers and dates. When I feed info in, all are ok, numbers with 2 decimal points, amounts with $ symbol and correct decimal places however, my dates show on my data sheet as "month/day/year". No matter what I format or what I enter the format is always the same. Help!
@HaroldHorsman2 жыл бұрын
Your videos are very educational and have raised my awareness and skills tremendously! Thank you for that. My question: do you also share the code that you create during the video? Where can we find your sample code? It would help in learning even more.
@ExcelGoogleSheets2 жыл бұрын
on patreon
@HaroldHorsman2 жыл бұрын
@@ExcelGoogleSheets I’m not familiar with Patreon. Do you have a link?
@spandanabellamkonda35162 жыл бұрын
@@HaroldHorsman I see the link in the description above, there also is a link for some code snippets.
@zacthetalkingcat52202 жыл бұрын
I too would like a copy of the code so I can follow along with the video and once I have a working example I can edit to fit my needs. I don’t see a copy of the code in any of the links I clicked on. Is there another way to get it besides watching the video … stopping every few mins and writing it down?
@santosahernandezmendoza71472 жыл бұрын
bare and in the mouth! check in the video itself
@terragrub197 Жыл бұрын
I love your tutorials! In trying to modify an existing dataset, I have run into a bit of an issue I don't understand. The Form is simple ID Search Serial Number Brand Location Model Version Asset Tag Comment In the Inventory data their is a field Brand that is using a RegexMatch to autofill this field. If I search to find a record, then modify say location and save, the form is filling in this value from the querried valued. How can I skip that field on the saveRecord function. The Brand is determined by the starting 3 characters of the Serial Number.
@edwardtsinigo12862 жыл бұрын
Thanks so much for this great tutorial. I have a data entry form with several cells. When I use the cost getRange = [""], the command enters the next line due to the several cells in the data entry form. Which command can I use to make the command run as one line without breaking? Thanks
@greenlightforce2 жыл бұрын
This shows data entry form for text. How can we use the same form to include uploading one or more documents or photos? More importantly, how can all entries go through an approval by a manager before it can be officially part of the database?
@corky6087 ай бұрын
Hello I built a Data Form following your videos, I'm not sure if it was this one or a search one, but you had a code within it - =QUERY(Data!A1:J,"SELECT * WHERE LOWER(E)= LOWER("""&B2&""")", 1) - what do I need to change if the column holds numerical answers as well as alphabetical, where the answer is definitely a numerical one and not a alphabetical one. favourtie TV series etc, 24 not Twenty Four :D
@ThePhotographer01 Жыл бұрын
Is there a way to add data to a spcific column using a pull down to pick what column it goes in?
@bigriver67282 жыл бұрын
Thank you
@les.matematika.online10 ай бұрын
what if the form sheet is separated in another spreadsheet, do you have a video about that? I'm very grateful if you have
@learnbehappy Жыл бұрын
Not able to search first record and fetch it on form. for my project
@ynurhalimi94212 ай бұрын
thank for the video, but,..in 30:29 when i use "data.filter " then message error : "typeError : data.filer is not function", please help me,..thank's
@outdoorlessons39622 жыл бұрын
Hi, Thank you for the many videos. Do you have any videos on updating multiple data records from Web Apps to Google Spreadsheets? > I have a Google sheet data with just Ids and Name - (only 2 columns) > I have extracted the data to the Web App in a table format using the CRUD codes and include about 4 Checkboxes for each record in the Web App table using create table array methods. (using only one HTML page) > the objective is to easily see the rows of records and tick the appropriate Checkboxes. User may tick different Checkboxes for each row. > How do we get these multiple Checkboxes Boolean values from the different records and place these values into the Google Sheets and append to the new columns? I understand from your video the update is to edit for individual record. But my data just require checkboxes only to update Boolean values to the data and thus the use table format. Really appreciate if you do have such videos. Sorry for my long request. I'm just a beginner! And thank you again for all the videos.
@ambed47112 жыл бұрын
Thanks for making this great tutorial. Just wondering if I can get the link to scripts please?
@vishagrajendra45912 жыл бұрын
Hi, Thanks for doing this. Can this Also be Done On Google Forms via App Scripts?