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.
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
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
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?
![How to create a data entry form in Google Sheets [with multiple databases]](http://i.ytimg.com/vi/qo743XZOU0M/mqdefault.jpg)
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.
this is the most easiest among all of the data entry form. thumbs up
Thank you for your comment and for watching
Thanks alot. Your are a life saver. BEST EVER!
Thanks for the comment and for watching! 😊
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
Thanks for this video, please put all SCRIPTS in description or in comment.
Do you know how ow to separate data from a different date on different sheet? Thanks
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
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?
Please, I need the codes in the test file
Does this work on apps in tablets?
yes