Create a data entry form in Google Sheets

  Рет қаралды 41,953

hay kel

hay kel

Күн бұрын

Пікірлер: 35
@CaptivatedHope
@CaptivatedHope 8 ай бұрын
this is the most easiest among all of the data entry form. thumbs up
@hay_kel
@hay_kel 8 ай бұрын
Thank you for your comment and for watching
@Caddyman68
@Caddyman68 Ай бұрын
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
@jaiswalamit
@jaiswalamit 7 ай бұрын
Thanks for this video, please put all SCRIPTS in description or in comment.
@MahdyAlizadeh
@MahdyAlizadeh 9 ай бұрын
Thanks alot. Your are a life saver. BEST EVER!
@hay_kel
@hay_kel 9 ай бұрын
Thanks for the comment and for watching! 😊
@darumawan1
@darumawan1 7 ай бұрын
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.
@aghamubasher904
@aghamubasher904 4 ай бұрын
Loved it.. That Really Works
@dcjohnson7615
@dcjohnson7615 2 ай бұрын
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
@Summersolstice1826
@Summersolstice1826 3 ай бұрын
Did you make the script? How did you do that? How to make an appropriate script?
@aonexcreation6402
@aonexcreation6402 Ай бұрын
thank you !! from my heart. code is working
@alati33
@alati33 4 ай бұрын
Is there a copy of the file, please?
@tinageorge6183
@tinageorge6183 7 ай бұрын
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
@irlmariesaavedra7888
@irlmariesaavedra7888 7 ай бұрын
Do you know how ow to separate data from a different date on different sheet? Thanks
@eduardopraciano4143
@eduardopraciano4143 7 ай бұрын
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?
@serbonkers4130
@serbonkers4130 6 ай бұрын
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
@JeremyBanks-e5x
@JeremyBanks-e5x 4 ай бұрын
Can this still work on the other users????
@valerievanessamajadas2447
@valerievanessamajadas2447 4 ай бұрын
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.
@jeieya667
@jeieya667 Ай бұрын
Can you do a script for printing the data individually??
@adilmajid06
@adilmajid06 2 ай бұрын
Can we add userform ?
@ShamusDiaries
@ShamusDiaries Ай бұрын
Hi..How i can this same transcript in notes?
@_TurboRider
@_TurboRider 4 ай бұрын
my search function is not working 😢
@zainworld266
@zainworld266 Ай бұрын
How i can get this transcript?
@min-chengliu3191
@min-chengliu3191 9 ай бұрын
Does this work on apps in tablets?
@hay_kel
@hay_kel 8 ай бұрын
yes
@weanaortil6459
@weanaortil6459 4 ай бұрын
thank you... i wanted to try but I don't have script editor... what should I do?
@intannovia5056
@intannovia5056 22 күн бұрын
ah same. me too
@janetteolvera8916
@janetteolvera8916 19 күн бұрын
On Google Sheets, it's now under "Extensions". It's called "Apps Script"
@subhajitdutta8386
@subhajitdutta8386 Ай бұрын
How to get timestamp for each entry along with the person who is doing the entry
@Kk923.1
@Kk923.1 2 ай бұрын
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
@rezarohoman6201
@rezarohoman6201 2 ай бұрын
I am trying not working on google sheets
@beno0070ahmed
@beno0070ahmed 7 ай бұрын
Please, I need the codes in the test file
@romeowhiskey1146
@romeowhiskey1146 5 ай бұрын
COPY of this SPREADSHEET AVAILABLE...to avoid re-typing. Thanks.
@anggakhayyuriyadi4454
@anggakhayyuriyadi4454 2 ай бұрын
I need the code now
@alati33
@alati33 4 ай бұрын
Is there a copy of the file, please?
Draw with the CHAR function of Google Sheets
2:33
hay kel
Рет қаралды 1,8 М.
Create a Button that works in mobile in Google Sheets
13:38
Practical Sheets
Рет қаралды 39 М.
Don’t Choose The Wrong Box 😱
00:41
Topper Guild
Рет қаралды 35 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 892 М.
How to create a data entry form in Google Sheets [with multiple databases]
14:52
Form in Google Sheets | Data Entry Form
13:35
raksrahul
Рет қаралды 14 М.
How to Easily Create an Data Entry Form in Excel | No VBA
22:30
Jopa Excel
Рет қаралды 49 М.
Creating a Powerful Advanced Search Box in Google Sheets - Step by Step
7:04
Tech Tricks with Eli
Рет қаралды 11 М.
✨ Google Sheets Introduces Tables
7:27
Dan Leeman
Рет қаралды 46 М.