Google Sheet Multi-user Data Entry Dashboard | Data Entry Form | No Coding Knowledge

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.

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:

Follow and engage on social media:

#dataentry #googlesheets #appscript

[mirothedjmusic]

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.

[heyitspyu]

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. :)

[keizerrave]

This really worked. Thank you for this, no need to learn how to create a script.

[SalAbraham]

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

[SianDoherty]

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.

[ArvindKumar-Vendor]

Its working good thanks for the tutorials

[widzomugband]

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

[RidgewayChronicle]

Thank you so much for this it worked so well

[popjasakeuangan]

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

[romeowhiskey]

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.

[AadarshRajput-qjcr]

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

[shubhambhojgarhia]

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?

[dapcubalangir]

Can it work if multiple user enter their data at a time ? I think it is not so.

[anupomshidhukubi]

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?

[graceinfotech]

TypeError: is not a function can you help with this error?

[VinothVino-vyhl]

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?

[marcizarmagsino]

Is it possible that each students you enter will be on separate sheets?

[gilmargilmar]

Parabéns pelo conteúdo. Você poderia disponibilizar o código app script para fins didáticos ?.

[AG-Investment]

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.

[RafiqulIslam-vdie]

I am trying. But did not work properly. Always shows "Roll number exists. Data has been brought to input fields."?