*Here are the links:* ⤵ Live demo: vendor-data-entry.streamlit.app/ Source Code: github.com/Sven-Bo/google-sheets-data-entry-form-with-streamlit Gsheets-connection package: github.com/streamlit/gsheets-connection

Excellent as always, a second video about login would be awesome!

@CodingIsFun

7 ай бұрын

As always, thanks a lot for your comments! I added the login feature on my "videos-to-do-list" ;)

Thank you for providing the neat demonstration, it helped me very much

@CodingIsFun

8 ай бұрын

Glad it helped! :)

I was having difficulties because an error occurred in streamlit web distribution. I was able to solve the problem by watching the video. Among the streamlit content I am studying, your video is the best. thank you. Please continue to produce good streamlit content.

@CodingIsFun

7 ай бұрын

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍

That’s very practical, thank you!

@CodingIsFun

8 ай бұрын

Glad it was helpful, Florian. Thanks for watching and your comments! 👍

This video is a treasure. Thank you so much...

@CodingIsFun

5 ай бұрын

Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️

Great video as always. I would like the video about the login to see how you can control which user can see certain info!

@CodingIsFun

5 ай бұрын

Thanks for watching. Login (authentication) is already on 'videos-to-do' list! Stay tuned! ✌️

This was very helpful thank you!

@CodingIsFun

8 ай бұрын

Glad it was helpful! Thanks for watching and leaving a comment! :)

Again an excellent informative video. Please make a 2nd video alsoa nd include also a login functionality.

@CodingIsFun

8 ай бұрын

Thanks for watching. Glad you liked this one too and your request is well noted! 👍

thank you, I really enjoyed learning this, please show me other exercises, like login session and others

@CodingIsFun

8 ай бұрын

Thanks for watching and your request is well noted! 👍

Thank you immensely for this invaluable content! Your effort is truly appreciated. 😊 Could you consider crafting another video demonstrating how to incorporate eye-catching statistics, just like Google does in their forms with pie charts, line graphs, or bar graphs? It'd be amazing to see this in action for data like gender ratios, age distribution, course preferences, and more. I'm curious if Streamlit alone can handle this or if you'd recommend building a separate admin dashboard. Could you share your insights on that process? Can't wait to see what's next! 👍

@CodingIsFun

8 ай бұрын

Thanks for watching and your suggestion! 👍

@bolokangmpoma

2 ай бұрын

@@CodingIsFun As i'm walking on implementing something similar to this, I would want to know if you have done a video on this comment. I'm enjoying this so far

Great 👏👏

@CodingIsFun

8 ай бұрын

Thanks! 💖

It is really amazing

@CodingIsFun

7 ай бұрын

Glad you liked it. Thanks for watching and taking the time to leave a comment! 👍

Thank you for the lesson. Yeah now we need authentication and also how to let user update their own details.

@CodingIsFun

8 ай бұрын

Thanks for watching. Well noted! 👍

Superb

@CodingIsFun

8 ай бұрын

Thank you!🤗

Well explained, I would love a tutorial on the security bit

@CodingIsFun

Ай бұрын

Thanks for watching. What exactly do you mean? Cheers, Sven ✌️

great i will be using this in my next project wish i am working on now i needed a database for my collected info i think i can even add tableau to this.

@CodingIsFun

6 ай бұрын

Glad it was helpful and good luck with your project! 🤞

Thanks for the all the videos. Can you do a streamlit auth video with postgres?

@CodingIsFun

8 ай бұрын

Thank you for watching the videos! I will create another video to add authentication, but I cannot promise to use a PostgreSQL database for that. Nonetheless, the steps/code will be very similar.

I always appreciate your content Sven. You would use this over google forms if the rest of your app is in streamlit correct?

@CodingIsFun

8 ай бұрын

Thank you for watching. I'm happy to hear that you like the content. I think it really depends on your use case. MS Forms is great and works right out of the box. However, if you need more customization options, the combination of Streamlit and Google Sheets could be another solution.

Thanks very much for the video. Always enjoy and learn so much from your contents. Could you please integrate the authentication to protect this application?

@CodingIsFun

8 ай бұрын

Happy to hear that you enjoyed this one as well! Yes, in the coming weeks, I will create another video to show how to add the authentication.

This is super interesting and I can already think of uses for something like this. Do you have any videos on pulling data from spreadsheets Excel or Google Sheets and using that data to fill in online forms... like reverse scraping?

Haha 😂 that woman diving into the water was so funny

@CodingIsFun

8 ай бұрын

🤿💦

Does this work if multiple users input data concurrently, or does it overwrite the google sheet with the last update?

@CodingIsFun

8 ай бұрын

Thanks for watching. Multiple users could use it at the same time.

Thank you for your help, just a quick question, i am facing the following error: Spreadsheet must be specified

@CodingIsFun

6 ай бұрын

Hard to tell from a distance why you are facing an issue

Thanks for the video. Is there any limitation for using the Google API?

@CodingIsFun

6 ай бұрын

Thanks for watching. Have a look at the following Google Sheets rate limits: developers.google.com/sheets/api/limits I hope it helps! :)

Love your contents, can you do a project similar but using sharepoint api to update list ?

@CodingIsFun

6 ай бұрын

Thanks for watching! I'm happy to hear that you are enjoying my videos, and thank you for your video suggestion. I can't make any promises, but your suggestion is well noted.

Hey, thanks for the video. What color theme are you using on VSCode? Thanks.

@CodingIsFun

22 күн бұрын

Thanks for watching. I am using Cobalt3: marketplace.visualstudio.com/items?itemName=alex-pattison.theme-cobalt3 Cheers, Sven ✌️

@franklinajisogun

21 күн бұрын

@@CodingIsFun Thanks

can you please tell me what python and streamlit versions you are using in this video because i am facing a lot of compatibility issues between them and other libraries such as st-gsheets-connection

@christophoramorim3147

2 ай бұрын

Também estou com o mesmo problema, instalei apenas o python e vs code para começar e esta dando erro. Estou usando atualmente o python na versão 3.12.3

The Login screen would be super helpful, we'd need to keep the created login credentials somewhere else right?

@CodingIsFun

8 ай бұрын

Well noted! Yes, you would also need to set up a database to store/retrieve/update/delete the credentials.

can streamlit makes an option to choose time? i want to have a dropdown to select a data (can be from live or just from csv) ie Week over Week (such as last 7 days), or month over month (previous 30 days), or even a quarter (previous 90 days)? seems like i cant find the option to do so, as a dropdown

@CodingIsFun

7 ай бұрын

Thank you for watching! Unfortunately, the question you asked is not related to the video content. If you have any questions or need help, I suggest you join my Discord channel at pythonandvba.com/discord . Just make sure to read the forum rules before posting any questions.

Good. But what are benefits or advantages? Instead of entering data directly into gsheet?

@CodingIsFun

7 ай бұрын

Thanks for watching. It just an (practical) on how to connect Streamlit with Google Sheets.

This is great, but I have issue add new submission. It only update the previous submission instead of add in another new row. And is it normal for the slow run?

@CodingIsFun

3 ай бұрын

Thank you for watching. Please check out my code: github.com/Sven-Bo/google-sheets-data-entry-form-with-streamlit/blob/main/vendor_app.py You will need to append the new data to your dataframe. I hope it helps! Happy coding! Cheers, Sven ✌️

Does Streamlit connect to postgresql for a CRUD ui?

@CodingIsFun

7 ай бұрын

Thanks for watching. Yes, it does. Have a look here: docs.streamlit.io/knowledge-base/tutorials/databases/postgresql

First comment 😊

@CodingIsFun

8 ай бұрын

🚀🚀🚀

how do you retrieve the data from the spreadsheet to the streamlit?

@CodingIsFun

7 ай бұрын

Thanks for watching. Feel free to check out the code I provided on GitHub. Happy Coding!

Is it possible to delete a row? I am trying using the st.data_editor but is not working. Ty so much

@CodingIsFun

2 ай бұрын

Thanks for watching. Yes, that is possible. Have a look here: github.com/Sven-Bo/google-sheets-data-entry-form-with-streamlit/blob/main/vendor_app.py#L156 Happy Coding! Cheers, Sven ✌️

@raphaelwerneck

2 ай бұрын

@@CodingIsFun ty so much!

i want to add image upload in this form can u help?

@user-ht8hq2ce3j

4 ай бұрын

Did you get it working?

I'm also developed a similar project. But instead of Google sheets, I've used MySQL database. After successfully deploying my streamlit app in Community cloud, my app was not rendering. It was taking at least 15 min to render my web page. Could you please tell me a solution? 😢

@CodingIsFun

8 ай бұрын

Thanks for watching. Hard to tell from a distance. Sorry, that I cannot help!

@favourphilicvictor1059

8 ай бұрын

Please let me know when you finally are able to deploy a streamlit app with mysql successfuly. I am having similar challenge

Dear Sven! I am still getting this error when i try to st.dataframe(existing_data) I have done everything what you said in your last video, however still stuck with it. Please help me out

@CodingIsFun

8 ай бұрын

The error message would be helpful

@merekissagalyev5994

8 ай бұрын

@@CodingIsFun I have attached the screenshot on ds

@merekissagalyev5994

8 ай бұрын

@@CodingIsFun Traceback: ValueError("Spreadsheet must be specified")

Thanks a lot sir but i m encountering with an error My app is working well when i locally host my app and it is even appending the data in my sheets but when i deploy it i m getting this as error ModuleNotFoundError: This app has encountered an error. The original error message is redacted to prevent data leaks. Full error details have been recorded in the logs (if you're on Streamlit Cloud, click on 'Manage app' in the lower right of your app). Traceback: File "/home/adminuser/venv/lib/python3.9/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 534, in _run_script exec(code, module.__dict__) File "/mount/src/appointments/appointments.py", line 4, in from streamlit_gsheets import GSheetsConnection

@CodingIsFun

7 ай бұрын

Thanks for watching. Have you included in the requirements.txt file in your GitHub repo?

Hello sir, i have the problem when using input worksheet as mine, and the problem is "ValueError: Spreadsheet must be specified" and my error in coding was "existing_data = conn.read(worksheet="Data", usecols=list(range(6)), ttl=5)" Do u know how to fix it? Thanks a lot

@CodingIsFun

4 ай бұрын

Thanks for watching. Did you share the technical user email address in Google Sheets as shown in the video? Cheers, Sven ✌️

Hello, thank you for the video, I get the following errors when deploying my app: streamlit.runtime.caching.storage.cache_storage_protocol.CacheStorageKeyNotFoundError: Key not found in mem cache, & streamlit.runtime.caching.storage.cache_storage_protocol.CacheStorageKeyNotFoundError: Local disk cache storage is disabled (persist=None)

@CodingIsFun

6 ай бұрын

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

really would like to see how to make authentication with firebase.

@CodingIsFun

8 ай бұрын

Thanks for watching and your suggestion! 👍

Dear Sir, I cannot create .streamlit folder in my mac. so I got this error "ValueError: Spreadsheet must be specified"

@CodingIsFun

2 ай бұрын

Please have a look here: chat.openai.com/share/b587e0d4-aa17-43eb-acd7-ccc7278e98b0 I hope it helps! Happy Coding! Cheers, Sven ✌️

Hi I followed all The output scren is showng ValueError: Spreadsheet must be specified

@CodingIsFun

2 ай бұрын

Thanks for watching. Did you share your technical email address with the spreadsheet as shown in the video? Cheers, Sven ✌️

@rajchandra6913

2 ай бұрын

@@CodingIsFun my bad I wrote the forlder name without ' . ' before streamlit It's working fine now

Dear Sven, thanks a lot for this video, this really helps for a project I need to implement. when following your steps, I got an error when testing the dataframe with st.dataframe(existing_data) at 6min.40 in the video. it returns the error "Spreadsheet must be specified" whereas you explicitly said it was not required. Do you know what I'm doing wrong ? thanks a lot Julien

@CameLinis

7 ай бұрын

Check your secrets.toml if named correctly

@CodingIsFun

7 ай бұрын

Hi Julien. Thanks for watching. Kindly double check if you have set up the secrets.toml file correctly.

Hi! i follow your step. but, i found an error while installing gsheets-connection like this note: This error originates from a subprocess, and is likely not a problem with pip. ERROR: Failed building wheel for pandas Failed to build pandas ERROR: Could not build wheels for pandas, which is required to install pyproject.toml-based projects I've already search on the internet to solve, but its still the same.

@CodingIsFun

4 ай бұрын

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

where is the entry_form file sheet ?

@CodingIsFun

4 ай бұрын

Thanks for watching. You can easily create the spreadsheet yourself. I just used it as an example. And since it is private (as shown in the video), you will not have permission to access the sheet. Happy Coding! Cheers, Sven ✌

Can i share it to whatsapp?

@CodingIsFun

2 ай бұрын

I don't know what you mean

Auto ML UI

data = worksheet.spreadsheet.values_get( AttributeError: 'Worksheet' object has no attribute 'spreadsheet' this the error i get, but this isnt even in my python script, it worked fine before for like a week and now suddenly i get this error.

@CodingIsFun

5 ай бұрын

Intersting. When I check my live demo app it still works as expected: vendor-data-entry.streamlit.app/