I have used your template but I did a little modification by adding another field for photo and added a new button to display a sidebar in Google sheet to browes and upload the image and keep it in a specific folder in google drive, which link is automatically added to the field for photo. As i added a frame where the image appear automatically in the data entry form. In addition I made multiple classes where the entry button should add the data instead of just one class
Thank you for your tutorial! I have tried using this method without the help of ai and it didnt work, so i just gave up. But when i saw your video it was so easy, you explained it clearly ! I modified it and tried it and worked perfectly! This will be a great tool. IThank you for sharing it. :)
am facing a problem that my excel, data sheet is saying PLEASE FILL IN ALL REQUIRED FIELDS when I click enter I checked all my cell to see if there are linking with my code but still its no working . help please
Thank you for the useful video. 1. What if I want to add more fields in the form in future? Will I need to make a new prompt and rewrite the code? 2. If I just edit the code wont it falter the code for buttons since the buttons will have to pushed down to make space for new fields in the form? 3. How to add image option in the form?
Hi, 1. If you copy the code to ChatGPT and ask to add code for the new fields with correct cell references, it will provide you with the exact code since you already have a code base (you can copy my code; the link is in the description). 2. The buttons are not connected to any cell; you can move them anywhere on the sheet without affecting their functionalities. 3. I haven't played with image entry. Please let me know if you do and how it goes. Thank you
if we protect the sheet and excluding the necessary fields, we can use buttons. if we use unprotected sheet, other user may delete the button. how can we set permissions to the button?
I have the Roll number in cell D5, Name on D7, Grade on D9, Gender on D11, Date of admission on D13, and Remarks on D15 on the' Input' sheet. I have the same columns on another sheet named 'Data' with the headers. I want a function that will enter these inputs into the next available row; when I click the button, I will assign the function to a button. Before sending the input, ensure all the mentioned cells have data. When the input has been entered, show a pop that says 'New data entered.' Additionally, the Input sheet has one more cell 'F3', where I have mentioned the operator name; this operator name should be entered after the Remarks column on the 'Data' sheet. After the Operator's name, there is one more column for the Date of entry; when the data is being entered the Date of entry column should record the present date. Make sure to check for the roll number does not exist on the Data sheet; if the roll number is already on the 'Data' sheet, it will show 'Roll number exists.' and it should bring all the data (Roll, Name, Gender, Date of admission, Remarks ) to the input fields accordingly.
Creating an AppScript just got SO EASY. What you NOW need to MASTER is clearly communicating WHAT YOU WANT to ChatGPT. The HARD part of writing the code...is a thing of the past. AI saves the day.
bro can you make one for me for my daily task first date then ,task1 finish time, task2 finish time ,task3 finish time task4 finish time and so on then enter and all come on other sheet
Hi, Can this be done for micro Excel too I don't know how to feed duplicate in this section.. is there any chance that I can feed multiple duplicate data
PSA: Be careful when blindly copying chatgpt code or any LLM AI code. It's much better to try and understand first what you are copying. Ask for a detailed explanation in your prompt so you can learn at the same time.
thank you for you tutorial , it was clear and helpful. but for the apps script when you need authorization and it has a disclaimer that google spreadsheet can delete etc etc. is it safe to use apps script? cause im confused , its extension from the google itself but the google hasnt verified it. or is there other way to do the macro without apps script thank you in advance
You are welcome. I am glad that you find the tutorial helpful. It is completely safe to use the Appscript. Google shows the warning because the script is not verified with them. You can verify the script with Google using OAuth client verification. Since the script can only manipulate the worksheet, there is no harm. You can see the whole script; there is no code that can harm your data. Still, if you do not want to see that warning, you can follow this guide from Google: developers.google.com/apps-script/guides/client-verification Thank you.
Hi, I have updated the video description with a link to the Google Sheet. You can copy the Google Sheet. Please consider subscribing to the channel. Thank you.
Hello Thank you to creating very useful video. I am create one data entry form follow all the instructions, But in end data is not save received an error "Google hasn’t verified this app" Can you please help how to slow the same.
Hi, you are welcome. Please check at 9:56; I have explained how to verify the script. Click on the 'Advanced' link and then select 'Go to ..... (unsafe)'. It will verify the script. Thank you.
hi, what are you doing dear. you have a latest model tank and you are using it as a pistol. google sheet is vulgor like you are using. convert it into webapp.
Hi! I get what you're saying, but this setup is for those who prefer a simple Google Sheets solution. Not everyone needs a full web app-some want an easy way to use ChatGPT within Sheets. Different strokes for different folks!
Hello, greetings. I'm looking for videos that explain how I can create a logging system, that is, I need that when a user with access to the spreadsheet as an editor makes some insertion, change or even deletes a cell from a specific range of a given tab, this information is written in another tab called: "Logs" where ifnrome the date and time of the event, the user's email and what the status of the action was, whether the content was deleted, inserted or changed. Is there any way you can help me with this?
(I modified the comment; I oversaw your comment.) It will overwrite the data when more than one person is working on the inputs simultaneously. To make it work, you need to create a separate worksheet as the database and then create multiple worksheets for people for the inputs. All of the worksheets should be connected to the data worksheet.
It will overwrite the data when more than one person simultaneously works on the inputs. To make it work, you need to create a separate worksheet as the database and then create multiple worksheets for people for the inputs. All of the worksheets should be connected to the data worksheet.
If you want to create dashboards to access from mobile, I suggest you get 'AppSheet.' This tool has a lot of cool features and integrates with Google Sheets and Drive. I use this regularly for a client.
Initially, it doesn't enter duplicate entries. However, if you add duplicate entries to the data sheet at the time of the search, it will fetch the first record it finds.
@@technologiate First of all, let me thank you for the great work and efforts that you did. Second, thanks for responding to my question. In my case, I am doing a citizens complaints management system that some users do entries from different service offices in this system. I am not expecting a duplicate entries, but expect that some information would be similar. For instance, if I search for complaints related to water services, I should expect more than one entriy, in which case, I should be able to have all related entries for further action (update, edit, delete). Thanks again.
Hi Mohammed, You are welcome. The way it works, as shown in the video, is it has a unique key for the record; for a student, the roll number is the unique value, and for employees, employee ID is the unique value. And the search works with the unique value only. But you can create your dashboard with the method you need.
Hello, Thanks for the clarification. I tried to follow the steps, but when I select the Apps Script from Extensions menue, it gives me Bad Request Error 400. Any thoughts about that? Thanks.
Do you have multiple Google accounts signed in? It could be a possible error. You have the Appscript with an account, and when you open it, it tries to load the page with the other account. What I do is create multiple Google Chrome profiles for each Google account.
To be precise i need add delete modify data for multiple sheets which is present in 1 single spreadsheet . How to select the respective sheet for respective entry
Hi, Could you please send me an email(find it on the channel about page) with the requirements you have thought about? I will try to help you. Thank you.
*Create a Custom Trained Automated Customer Support Email bot (Power Automate + OpenAI Assistant):* ua-cam.com/video/fotKqjc6Y8k/v-deo.html
I have used your template but I did a little modification by adding another field for photo and added a new button to display a sidebar in Google sheet to browes and upload the image and keep it in a specific folder in google drive, which link is automatically added to the field for photo. As i added a frame where the image appear automatically in the data entry form. In addition I made multiple classes where the entry button should add the data instead of just one class
Thank you for your tutorial!
I have tried using this method without the help of ai and it didnt work, so i just gave up. But when i saw your video it was so easy, you explained it clearly !
I modified it and tried it and worked perfectly! This will be a great tool. IThank you for sharing it. :)
I'm so glad to hear that the tutorial helped you! Thanks for sharing your success, and I appreciate your kind words!
This really worked. Thank you for this, no need to learn how to create a script.
Thank you.
am facing a problem that my excel, data sheet is saying PLEASE FILL IN ALL REQUIRED FIELDS when I click enter
I checked all my cell to see if there are linking with my code but still its no working . help please
Thanks this was well done. Simple to the point, and easy to correct or change for my needs to start. Look forward to more complex sheets.
Thank you for the useful video.
1. What if I want to add more fields in the form in future? Will I need to make a new prompt and rewrite the code?
2. If I just edit the code wont it falter the code for buttons since the buttons will have to pushed down to make space for new fields in the form?
3. How to add image option in the form?
Hi,
1. If you copy the code to ChatGPT and ask to add code for the new fields with correct cell references, it will provide you with the exact code since you already have a code base (you can copy my code; the link is in the description).
2. The buttons are not connected to any cell; you can move them anywhere on the sheet without affecting their functionalities.
3. I haven't played with image entry. Please let me know if you do and how it goes.
Thank you
I am trying. But did not work properly. Always shows "Roll number exists. Data has been brought to input fields."?
if we protect the sheet and excluding the necessary fields, we can use buttons. if we use unprotected sheet, other user may delete the button. how can we set permissions to the button?
I have the Roll number in cell D5, Name on D7, Grade on D9, Gender on D11, Date of admission on D13, and Remarks on D15 on the' Input' sheet. I have the same columns on another sheet named 'Data' with the headers.
I want a function that will enter these inputs into the next available row; when I click the button, I will assign the function to a button. Before sending the input, ensure all the mentioned cells have data. When the input has been entered, show a pop that says 'New data entered.'
Additionally, the Input sheet has one more cell 'F3', where I have mentioned the operator name; this operator name should be entered after the Remarks column on the 'Data' sheet. After the Operator's name, there is one more column for the Date of entry; when the data is being entered the Date of entry column should record the present date.
Make sure to check for the roll number does not exist on the Data sheet; if the roll number is already on the 'Data' sheet, it will show 'Roll number exists.' and it should bring all the data (Roll, Name, Gender, Date of admission, Remarks ) to the input fields accordingly.
you're the GOAT say no more.
Creating an AppScript just got SO EASY.
What you NOW need to MASTER is clearly communicating WHAT YOU WANT to ChatGPT.
The HARD part of writing the code...is a thing of the past.
AI saves the day.
Thanks for the videos.
how about I want to lock the data part and only the admin can unlock it and see the updated data?
sir no need this option(please ensure all input fields have data) how to remove?
bro can you make one for me for my daily task
first date then ,task1 finish time, task2 finish time ,task3 finish time task4 finish time and so on then enter and all come on other sheet
Hi, Can this be done for micro Excel too I don't know how to feed duplicate in this section.. is there any chance that I can feed multiple duplicate data
Its working good thanks for the tutorials
PSA: Be careful when blindly copying chatgpt code or any LLM AI code. It's much better to try and understand first what you are copying. Ask for a detailed explanation in your prompt so you can learn at the same time.
TypeError: sheet.getRange(...).getValue(...).trim is not a function can you help with this error?
thank you for you tutorial , it was clear and helpful. but for the apps script when you need authorization and it has a disclaimer that google spreadsheet can delete etc etc.
is it safe to use apps script? cause im confused , its extension from the google itself but the google hasnt verified it. or is there other way to do the macro without apps script
thank you in advance
You are welcome.
I am glad that you find the tutorial helpful.
It is completely safe to use the Appscript. Google shows the warning because the script is not verified with them. You can verify the script with Google using OAuth client verification.
Since the script can only manipulate the worksheet, there is no harm. You can see the whole script; there is no code that can harm your data.
Still, if you do not want to see that warning, you can follow this guide from Google: developers.google.com/apps-script/guides/client-verification
Thank you.
Parabéns pelo conteúdo. Você poderia disponibilizar o código app script para fins didáticos ?.
Hi, I have updated the video description with a link to the Google Sheet. You can copy the Google Sheet. Please consider subscribing to the channel. Thank you.
@@technologiate Ok. Já escreví-me. Obbrigado.
Thank you so much for this it worked so well
You are welcome
How to get timestamp for each entry along with the gmail of the person who has done the entry
Can it work if multiple user enter their data at a time ? I think it is not so.
i don't think either. it will changed when other user/browser open the same form sheet. is it?
How to make different quotations by clicking by button
batter you create a google form so that any one can use from mobile as well
Hello Thank you to creating very useful video. I am create one data entry form follow all the instructions, But in end data is not save received an error "Google hasn’t verified this app" Can you please help how to slow the same.
Hi, you are welcome.
Please check at 9:56; I have explained how to verify the script. Click on the 'Advanced' link and then select 'Go to ..... (unsafe)'. It will verify the script.
Thank you.
Is there a possibility where the sl. no. will rearrange itself in descending order in the data sheet?
It should be possible by using another script which will automatically sort the data whenever there is an update.
Is it possible that each students you enter will be on separate sheets?
Hi, it is possible; you need to generate a new code using AI asking your requirements.
Is there a possibility where the sl. no. will rearrange itself in descending order?
Is there a possibility where the sl. no. will rearrange itself in descending order in the data sheet?
When you share the sheet with others to collaborate on, will the script still work or not?
Yes, it will work. They need to authorize the script for the first time.
i looking for this one from along time
🥰
Thank you so much 🎉🎉
You’re welcome 😊
hi, what are you doing dear. you have a latest model tank and you are using it as a pistol. google sheet is vulgor like you are using. convert it into webapp.
Hi! I get what you're saying, but this setup is for those who prefer a simple Google Sheets solution. Not everyone needs a full web app-some want an easy way to use ChatGPT within Sheets. Different strokes for different folks!
thanks so much this is amazing !
Hello, greetings.
I'm looking for videos that explain how I can create a logging system, that is, I need that when a user with access to the spreadsheet as an editor makes some insertion, change or even deletes a cell from a specific range of a given tab, this information is written in another tab called: "Logs" where ifnrome the date and time of the event, the user's email and what the status of the action was, whether the content was deleted, inserted or changed.
Is there any way you can help me with this?
Hi, By default, Google Sheets keeps the logs of the changes.
There are other Google services that can do it. What is your use case?
Is it solved?
I need some help
Thank you
I need write in a sheet the events that happens in one determinade range.
Could you please send an email with the requirements? The complete workflow you need. We can design that for you.
@@technologiate Ty bro.
I sent you an email
Bro, Is that possible to make it password protected so that the operators will automatically registrar there instead of manual change.
Yes, it is possible to grab the operator's name from the user entering the data. It will require additional code.
what if 2 people or more using the form input, will the data overwrite each other?
(I modified the comment; I oversaw your comment.)
It will overwrite the data when more than one person is working on the inputs simultaneously.
To make it work, you need to create a separate worksheet as the database and then create multiple worksheets for people for the inputs. All of the worksheets should be connected to the data worksheet.
@@technologiate i mean, when 2 people doing input, they will overwrite each other. can u solve this?
It will overwrite the data when more than one person simultaneously works on the inputs.
To make it work, you need to create a separate worksheet as the database and then create multiple worksheets for people for the inputs. All of the worksheets should be connected to the data worksheet.
Great 👍
pls share above script
Hi,
You can copy the Google Sheet with the script; the link is in the video description. Thanks
Is there a way for me to access the form from my mobile phone?
If you want to create dashboards to access from mobile, I suggest you get 'AppSheet.' This tool has a lot of cool features and integrates with Google Sheets and Drive.
I use this regularly for a client.
Hello sir multiple user cannot entry data at a same time, how can i solved it
In that case, you need to create a sheet for the database and separate data entry sheets for each person.
@@technologiate how to connect different sheet with database sheet
thanks bro
How the search works if more than one record meet the search criteria?
Initially, it doesn't enter duplicate entries.
However, if you add duplicate entries to the data sheet at the time of the search, it will fetch the first record it finds.
@@technologiate First of all, let me thank you for the great work and efforts that you did. Second, thanks for responding to my question.
In my case, I am doing a citizens complaints management system that some users do entries from different service offices in this system. I am not expecting a duplicate entries, but expect that some information would be similar. For instance, if I search for complaints related to water services, I should expect more than one entriy, in which case, I should be able to have all related entries for further action (update, edit, delete).
Thanks again.
Hi Mohammed,
You are welcome.
The way it works, as shown in the video, is it has a unique key for the record; for a student, the roll number is the unique value, and for employees, employee ID is the unique value. And the search works with the unique value only.
But you can create your dashboard with the method you need.
Hello,
Thanks for the clarification.
I tried to follow the steps, but when I select the Apps Script from Extensions menue, it gives me Bad Request Error 400. Any thoughts about that?
Thanks.
Do you have multiple Google accounts signed in? It could be a possible error.
You have the Appscript with an account, and when you open it, it tries to load the page with the other account.
What I do is create multiple Google Chrome profiles for each Google account.
How to do this for multiple spreadsheets
To be precise i need add delete modify data for multiple sheets which is present in 1 single spreadsheet . How to select the respective sheet for respective entry
Thanks!
Button not working on mobile. Please help.
How to add picture??
How to" fix reading get last row"
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
Hi,
Could you please send me an email(find it on the channel about page) with the requirements you have thought about?
I will try to help you.
Thank you.
*Generate & Send PDF Invoices using Google Google Sheet Data:* ua-cam.com/video/kJnaAvYV1Xw/v-deo.html
'Promosm' 💥
Thanks!