Google Sheet Multi-user Data Entry Dashboard | Data Entry Form | No Coding Knowledge
HTML-код
- Опубликовано: 15 июл 2024
- In this video, you will see how to create a multi-user data entry form on Google Sheets. This data entry form can be used for single users and multi-users.
You can share the same Google sheet with other users to work simultaneously. This is not just a data entry form; it also works as a data entry dashboard. This means you can search for already entered data and edit existing data.
I have used the Google Sheet app script to make the data entry dashboard work.
Appscript requires coding knowledge to design an interactive dashboard. But in this video, I have shown the method to create the data entry form without having coding knowledge.
Link for the Google Sheet: docs.google.com/spreadsheets/...
Get the prompts here: docs.google.com/document/d/1k...
In this step-by-step video tutorial, you will see:
✏️ How to design a simple yet effective data entry form with standard fields like name, grade, gender, date of admission, etc. Useful features like dropdowns and date pickers are added to streamline data entry.
🔍 How to effectively leverage ChatGPT prompts to generate Google Apps Script code for the form. Functions are created for Enter 📥, Search 🔎, Edit ✏️ and Clear 🗑️ buttons to make the form interactive.
📥 The Enter button takes data entered in the form and adds it to the data sheet with the date and operator details. A duplicate check is also implemented.
🔎 Search button fetches existing student data based on the roll number entered for editing.
✏️ The Edit button saves any changes made to the student data.
🗑️ Clear button conveniently clears the form fields.
👥 How to share the Sheet with other users so they can also enter data through the same form by selecting their name from the operator dropdown.
📆 The sheet records the operator name and timestamp along with each entry's details.
🔮 How to use claud AI as an alternative to ChatGPT if you don't have access to it.
Tips on authorizing the Apps Script functions when using the form for the first time.
This is an incredibly simple yet powerful way to create a web form on Google Sheets without knowing how to write code! The video shows how to implement it step-by-step, making creating a multi-user data entry form easy. Let me know if you need any clarification!
Timestamps:
0:00 Google Sheet Multi-user Data Entry Form Into
2:03 Create and design the Google Sheet
3:13 Create Drop-downs & Date Picker
4:56 Create Buttons on Google Sheet
5:44 Create a Worksheet to store the data
6:31 Google Appscript to add the new functions
7:01 Create the scripts using ChatGPT
9:06 Add the functions to the Google App script
9:40 Assign a function to the button
10:05 Authorize the script to the Google sheet
11:45 Create Edit, Search, and Clear fields functions
15:37 Share the Multi-user data entry dashboard with other users
Subscribe to the channel:
/ @technologiate
Follow and engage on social media:
Facebook: / technologiate
Instagram: / technologiate
#dataentry #googlesheets #appscript 
Наука
thanks so much this is amazing !
Thanks!
Thank you
Great 👍
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!
Thank you so much 🎉🎉
You’re welcome 😊
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?
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
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?
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
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.
How to make different quotations by clicking by button
I need some help
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.
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.
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?
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.
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?
Button not working on mobile. Please help.
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.
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.
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
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.
How to add picture??
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
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
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.
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.
How to" fix reading get last row"
'Promosm' 💥