A transcript where one could copy the script would be helpful. The "show transcript" button that shows up does nothing but show a contents and time of elements in the video
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.
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
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?
this is the most easiest among all of the data entry form. thumbs up
Thank you for your comment and for watching
A transcript where one could copy the script would be helpful. The "show transcript" button that shows up does nothing but show a contents and time of elements in the video
Can you do a script for printing the data individually??
Is there a copy of the file, please?
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.
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.
Did you make the script? How did you do that? How to make an appropriate script?
Does this work on apps in tablets?
yes
Do you know how ow to separate data from a different date on different sheet? Thanks
Hi..How i can this same transcript in notes?
Can this still work on the other users????
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
How i can get this transcript?
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
Can we add userform ?
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?
thank you... i wanted to try but I don't have script editor... what should I do?
ah same. me too
On Google Sheets, it's now under "Extensions". It's called "Apps Script"
Thanks alot. Your are a life saver. BEST EVER!
Thanks for the comment and for watching! 😊
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.
Loved it.. That Really Works
Its work but in my sheet upadte is not work can i send on your mail can you guide me where i wrong to do
How to get timestamp for each entry along with the person who is doing the entry
thank you !! from my heart. code is working
Hi,
It is a wonderful video and very helpful. Could you please share your script if you can? It would be very helpful.
Thank you.
thanks for the comment. but unfortunately I don't have this code anymore.
I am trying not working on google sheets
my search function is not working 😢
Please, I need the codes in the test file
SAVE & CLEAR works fine but I'm stucked with the SEARCH😢 anyone cane help?
what is "i"
COPY of this SPREADSHEET AVAILABLE...to avoid re-typing.
Thanks.
I need the code now
Is there a copy of the file, please?