Is there a way that 2 people can work on it at once? Say one person is putting in a new entry and another is searching and editing on the same document/sheet/cell etc
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.
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
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
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?
this is the most easiest among all of the data entry form. thumbs up
Thank you for your comment and for watching
Is there a way that 2 people can work on it at once? Say one person is putting in a new entry and another is searching and editing on the same document/sheet/cell etc
Thanks for this video, please put all SCRIPTS in description or in comment.
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.
Loved it.. That Really Works
Thanks alot. Your are a life saver. BEST EVER!
Thanks for the comment and for watching! 😊
Did you make the script? How did you do that? How to make an appropriate script?
thank you... i wanted to try but I don't have script editor... what should I do?
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
Is there a copy of the file, please?
Do you know how ow to separate data from a different date on different sheet? Thanks
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
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.
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?
my search function is not working 😢
Can this still work on the other users????
Does this work on apps in tablets?
yes
COPY of this SPREADSHEET AVAILABLE...to avoid re-typing.
Thanks.
Please, I need the codes in the test file
Is there a copy of the file, please?