Thanks for the video. I was able to create one data entry form with the help of your video. However; I face a challenge that when multiple users are working on this form, data are getting collapsed which means, while one person entering the data, another person may reset his form from his end which results in clearing the first persons data as well. What is the workaround for this? Thanks .
Hi Eli. Nice video. I follow all of your example writing all of the code my self. Then I tested the code to see if it works and have to make some adjustments for the code to work. Here are my findings: First, I have to delete the var SEARCH_COL_IDX = 0 and var RETURN_COL_IDX = 0 variables at the begining of the updateData function, because they where reseting those variables before the function could use them as a reference. After that, the updateData function worked just fine. The other change has to do with the sheet names arrays. I store the array on a variable named sheets, then replace that in the code as follows: sheets.forEach(function(s) ... and again, both functions are working just fine. Finaly, an anoying thing that I could not fix is that you must exit all of the cells in order for the updateData, searchStr and submit functions to be able to safe and/or uspdate all of the fields. If the cursor is on one of the cells, that cell won't be added or updated on the sheet. Thank you so much and hope this helps to make a more robust form.
Do this to solve your 'annoying thing': After defining the variable'form' add this line of code below it: form.getRange('A1').activate(); You can activate any cell according to your convenience
Im a beginner with anything technology and I was wondering if someone could help me with what I believe is a simple question.. how can I click more than one row at the time? For example in the video when she selects cells 7c, 7d, 9c, 9d, and so on I can only select 7c and d. Help please!
Hi very good tutorial, helps a lot. I'm trying to expand it a little bit and came with the issue of preventing duplicity on submit without clearForm(). I tried some stuff, like adding an IF client==row[2] (in my case) but it just ignores it. Could you pls help me with this? Tks and tks for the tutorial!
Hello! Thanks for the tutorial. One question, can I have the data loaded into both a sheet of the same spreadsheet and a different spreadsheet? And if it can be done, how can I do it?
Hi again Eli. Also, something I would like to have more insight about is the following line: var datasheet = form.getRange("D5:D5").getValues()[0][0] It seams to me that "D5:D5" is redundant, since it is just one cell you are reference to. Wouldn't be just "D5" enough? Also using getValues()[0][0] is confusing for me because you are just taking one cell's value alone, why then load an array? Thank you so much for any input on this. Appreciate all your work.
Mrs, I kindly ask for your guidance. How do I create: A data entry application in Google Sheets (for biodata, description, and photo upload) where the results are automatically displayed in a criteria-based sheet? For example: When I fill out the data entry application in Google Sheets (form) for the health program, the data automatically gets entered into the health sheet. Similarly, if I input data for the economy program, it automatically gets entered into the economy sheet. The uploaded photo should automatically turn into a link in the spreadsheet. For the description, since it's a long text, how can I make it look tidy? Is it possible to convert long text (description) into a link, where clicking the link opens a new tab with a docx (even though the user is not uploading a docx file)? Also, there will be a dedicated sheet (like a dashboard). Please assist with this, Mrs. Thank you.
Hi, are you sure you made the purchase correctly? If yes, don't worry. Please send me your purchase information so that it can be checked and the files will be emailed to you❤🌹
Hello dear, your videos are very useful for me, and I wanna create search button in a way that which display search results every time with a next search result because in my database there are multiple same rows and I wanna display every next result with again pressing search button, please assist me in this regard.
The tutorial is good. But I am making a different data base. If you can show how you do the formula with (ID#,Name,Mobile#,Date Start and Date End. I will highly appreciate. You explain everything cleary and I learned. 😊 Except for the formula, as I have zero knowledge on this. 😅
Hi my friend, my previous channel deleted by mistake, and I lost all my fans and subscribers and also my income😞 Now I started new channel, amazing and useful tutorials are on the way🙂 I'm so sorry that I can't publish the templates for free as previous, I need financial support to continue making tutorials. I need you and fans support to grow again❤❤❤
How to update multiple product details and generate automatically unique I'd and submit according to the products in multiple rows in master database sheet
Hi Eli. This video is Good. I subscribed your channel now. I need the video in Google sheet for creation of Indiv MarkList for school. Kindly consider.
I need to collect the marks from various teachers in Google Sheet. I need to export(PDF) the summary in one sheet. I need individual mark sheet that is each students mark sheet one by one in one Google sheet. Condition from management : Summary and Individual sheet the owner(School Management) has to handle. Condi 2 The marks of other subject teachers they are not suppose to see the other subject marks. Indivi mark sheet need one small bar chart(Automatic Creation when they fill the marks) for each student marks, Indv ML(PDF) going to take print (A4) each students. Summary and Indiv ML handled by only management. English, II language, Mathematics, Science (Physics,Chemistry,Biology), Social Science(History, Economics), Computer. Then Total.
![How to Resize Rows and Columns in Google Sheets [Manually and Automatically]](http://i.ytimg.com/vi/IInK0lgeQK8/mqdefault.jpg)
![How to Resize Rows and Columns in Google Sheets [Manually and Automatically]](/img/tr.png)
உங்கள் வீடியோ எனக்கு உபயோகமாக இருந்தது. மிக்க நன்றி.
உதவியாக இருந்ததில் மகிழ்ச்சி.
Watching this for my Systems engineering assignment, thnx !
I hope it helps with your assignment!
Thanks for the video. I was able to create one data entry form with the help of your video. However; I face a challenge that when multiple users are working on this form, data are getting collapsed which means, while one person entering the data, another person may reset his form from his end which results in clearing the first persons data as well. What is the workaround for this?
Thanks .
How cute you are and very informative video. Thanks
🎉🎉🎉🎉
⚘️⚘️
This is exactly what I needed. Thank you!
Excellent class! Very well explained step by step. Congratulations !
Glad it was helpful🌹
can i categorize depending on the date? I am planning to categorize my sheet by month
I need some custom fields will you add this after my purchase?
Hi Eli. Nice video. I follow all of your example writing all of the code my self. Then I tested the code to see if it works and have to make some adjustments for the code to work. Here are my findings: First, I have to delete the var SEARCH_COL_IDX = 0 and var RETURN_COL_IDX = 0 variables at the begining of the updateData function, because they where reseting those variables before the function could use them as a reference. After that, the updateData function worked just fine. The other change has to do with the sheet names arrays. I store the array on a variable named sheets, then replace that in the code as follows: sheets.forEach(function(s) ... and again, both functions are working just fine. Finaly, an anoying thing that I could not fix is that you must exit all of the cells in order for the updateData, searchStr and submit functions to be able to safe and/or uspdate all of the fields. If the cursor is on one of the cells, that cell won't be added or updated on the sheet. Thank you so much and hope this helps to make a more robust form.
Do this to solve your 'annoying thing':
After defining the variable'form' add this line of code below it:
form.getRange('A1').activate();
You can activate any cell according to your convenience
is it possible to get this form into a web page so that the same updates could be done from the web page?
Im a beginner with anything technology and I was wondering if someone could help me with what I believe is a simple question.. how can I click more than one row at the time? For example in the video when she selects cells 7c, 7d, 9c, 9d, and so on I can only select 7c and d. Help please!
U hold control while clicking each one
Hi while I enter the data multiple times. I am not able to see the exit date and time at which I entered data in the show edit and time history.
Hi very good tutorial, helps a lot. I'm trying to expand it a little bit and came with the issue of preventing duplicity on submit without clearForm(). I tried some stuff, like adding an IF client==row[2] (in my case) but it just ignores it. Could you pls help me with this? Tks and tks for the tutorial!
Very nice and clear explanation. Thank you!
Glad it was helpful.
Can I record data through mobile
Hello! Thanks for the tutorial. One question, can I have the data loaded into both a sheet of the same spreadsheet and a different spreadsheet? And if it can be done, how can I do it?
Yes you can! I will create a video for that.
@@TechTrickswithEli2023 Thanks!
Highly impressed from this video...
What an extraordinary Video...
Thank you Sooooo Much..
Glad it was helpful❤
Hello thank you so much.
How to get code? Where to get?
Hi, use the link below
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
hi, i ordered the template through your link and i havent received it, can you help me with this
Hi again Eli. Also, something I would like to have more insight about is the following line: var datasheet = form.getRange("D5:D5").getValues()[0][0] It seams to me that "D5:D5" is redundant, since it is just one cell you are reference to. Wouldn't be just "D5" enough? Also using getValues()[0][0] is confusing for me because you are just taking one cell's value alone, why then load an array? Thank you so much for any input on this. Appreciate all your work.
hi Eli was wondering where can i download your template or myb buy it if you are selling
Hi, Our website is under construction and will be ready soon. You'll find the sheet link there shortly😍😍😍
Greaaaat 👌❤ Thank you so much Eli
Glad you like it!
Mrs, I kindly ask for your guidance.
How do I create: A data entry application in Google Sheets (for biodata, description, and photo upload) where the results are automatically displayed in a criteria-based sheet? For example:
When I fill out the data entry application in Google Sheets (form) for the health program, the data automatically gets entered into the health sheet. Similarly, if I input data for the economy program, it automatically gets entered into the economy sheet.
The uploaded photo should automatically turn into a link in the spreadsheet.
For the description, since it's a long text, how can I make it look tidy? Is it possible to convert long text (description) into a link, where clicking the link opens a new tab with a docx (even though the user is not uploading a docx file)?
Also, there will be a dedicated sheet (like a dashboard).
Please assist with this, Mrs.
Thank you.
Hey there can you get data entry from source code
Nice explanation.
Really good.
Please explain the "data entry Google sheets which consists dependent drop-down button ".
Yes, sure
From where do u create the formula
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
I've paid to get the data and cannot download the spreadsheet. Please advise where I can find it. Thanks!
Hi, are you sure you made the purchase correctly? If yes, don't worry. Please send me your purchase information so that it can be checked and the files will be emailed to you❤🌹
Hi.. the link in description cant access.. cant reach this page..are the website still active?thanks
Try now
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
good job good information by you
Glad it was helpful❤
Hello dear, your videos are very useful for me, and I wanna create search button in a way that which display search results every time with a next search result because in my database there are multiple same rows and I wanna display every next result with again pressing search button, please assist me in this regard.
Hi, I am Ariful, I very impress your tutorial. please share your script function.
Hi dear Ariful, Check description for the script.
how can i get the program from your tutorial?...
Our website is under construction and will be ready soon. You'll find the sheet link there shortly🌹
Amazing😍
Thanks
Great Content with the talking sound miaw miaw miaw🐭 I'll practice what you taught.
Hi Eli. The link to the sheet code don't works.
Check now🌹
@@TechTrickswithEli2023 Not Yet.
@@professorhugo1468 The link works correctly🌹
sheetfacts.com/checkout/
Great tutorial. *****
Glad you liked it!
how much for a copy of a working sheet
Hi, use the link below
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
The tutorial is good. But I am making a different data base. If you can show how you do the formula with (ID#,Name,Mobile#,Date Start and Date End. I will highly appreciate. You explain everything cleary and I learned. 😊 Except for the formula, as I have zero knowledge on this. 😅
Any updates on the website?
Link to the sheet and code
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
Is the script available for this yet? I love this form and would love to use it.
Our website is under construction and will be ready soon. You'll find the sheet link there shortly
Useful Video.
Glad you think so!
Sad to see you've decided on Patreon for what used to be FREE for anyone.
But, it's your channel to do as you wish. Good luck!
Hi my friend, my previous channel deleted by mistake, and I lost all my fans and subscribers and also my income😞
Now I started new channel, amazing and useful tutorials are on the way🙂 I'm so sorry that I can't publish the templates for free as previous, I need financial support to continue making tutorials.
I need you and fans support to grow again❤❤❤
Great❤
Can't open the link to the sheet and code
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
May I contact you?
How to update multiple product details and generate automatically unique I'd and submit according to the products in multiple rows in master database sheet
I will create a video for your question♥️
Hi Eli. This video is Good. I subscribed your channel now. I need the video in Google sheet for creation of Indiv MarkList for school. Kindly consider.
Yes, sure
It's the last row that's giving me an error
"Syntax error: SyntaxError: missing ) after argument list line: 42 file: Code.gs"
hi @tech please help
Please how do I create the code?
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
Nice class...mam
I want source code ....
Hi, Check description.
I need to collect the marks from various teachers in Google Sheet. I need to export(PDF) the summary in one sheet. I need individual mark sheet that is each students mark sheet one by one in one Google sheet. Condition from management : Summary and Individual sheet the owner(School Management) has to handle. Condi 2 The marks of other subject teachers they are not suppose to see the other subject marks. Indivi mark sheet need one small bar chart(Automatic Creation when they fill the marks) for each student marks, Indv ML(PDF) going to take print (A4) each students. Summary and Indiv ML handled by only management. English, II language, Mathematics, Science (Physics,Chemistry,Biology), Social Science(History, Economics), Computer. Then Total.
tôi muốn mua bản sao để học tập code thì phải làm như thế nào?
Hi, use the link in the description ⚘️
Get this error when I try to pay. "500 SERVER ERROR"
Yes, there is a problem. As soon as the problem fixed, I will send you an email with discount coupon ♥️♥️
Great Job. But you need to slow down in your demonstration.
saveData function is not supported on mobile devices.
Google forms is the correct option.
Thanks for pointing that out! I'll try to make that more clear in a new video.
hi
I would like if could help me design a form of data entry form for the expenses track i am willing to pay you
plz help me.i have some mistakes in my sheet app script file.
What is the problem?
TypeError: Cannot read properties of null (reading 'getLastRow')
Please give me Employe data form prompt or script
Use the link
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
Dear mam, please share script code, thank you
Will upload soon
I like the content, the clicking sound though is way to aggressive for me and resulted in really skipping a lot of parts of the video
hi
can you give me your code script plz
Link to the sheet and code
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
Thanks
No problem
❤❤❤Happy New Year ❤❤❤
You too!!
please share script code
Hi, Our website is under construction and will be ready soon. You'll find the sheet link there shortly🌹
thanks
Nah.. the scriot does not work on search scipt..hehehe
Link to the sheet and code
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
Delete function : deleted the design of the cell 😂😂😂😂
You speak so cute
yuma yuma yuma what this as Robot are you girl?????
Your voice is not clear.
You are going so fast and not saying what you are doing :(
Very voice is very irritating! sorry mam
Sorry for that!
Olá !!. Onde encontro o cod script ?.🥸
Link to the sheet and code
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/