Create a data entry form in Google Sheets

In this video, we will see how to create a data entry form in Google Sheets
This form allows you to add, update and delete records in a Google sheet

[skynfnd]

this is the most easiest among all of the data entry form. thumbs up

[jaiswalamit]

Thanks for this video, please put all SCRIPTS in description or in comment.

[darumawan]

Thank you for the video, this helps me so much! Anyway I was wondering if it's possible to change the "save" function so then it will be added into a specific row instead of the last row.

[rvuurdb]

Thanks alot. Your are a life saver. BEST EVER!

[Summersolstice]

Did you make the script? How did you do that? How to make an appropriate script?

[weanaortil]

thank you... i wanted to try but I don't have script editor... what should I do?

[tinageorge]

Thank you so much for your video. I used your exact code for the Update function and when I test it out, I get an error "You do not have access to perform that action. Please ask the owner of the item to grant access." - this is my file entirely. I removed all sheet protections and i made the file available to anyone with a link, editor access - what am I missing? Also, I noticed that the Search or clear function doesn't work every time - i have to click the button a few times or refresh the screen for it to maybe show the result

[irlmariesaavedra]

Do you know how ow to separate data from a different date on different sheet? Thanks

[serbonkers]

WHAT IF I ALREADY HAVE A RAW SHEETS WITH A BUNCH OF DATA. HOW CAN I MAKE IT THAT THE NEW ENTRIES WOULD BE ADDED AND THE OLD ONES CAN STILL BE READ WHEN SEARCHED

[valerievanessamajadas]

The save does not work..the search only finds the first record..can you send the gsheet link..thank you in advance for your response.

[JeremyBanks-ex]

Can this still work on the other users????

[eduardopraciano]

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?

[benoahmed]

Please, I need the codes in the test file

[romeowhiskey]

COPY of this SPREADSHEET AVAILABLE...to avoid re-typing.
Thanks.