Python Web App using INTERACTIVE AGGRID Table connected to GOOGLE SHEET |JavaScript Injection |

Hi everyone ! Here's another video on Streamlit- AgGrid Implementation with usage of Button Renderer within AgGrid tables. Additionally, also show-casing the automation with Google Sheets as it's Database.
Thank you for all the feedbacks and comments in my previous two videos - which helped me to create this demo app and the video.

📺 Suggested video to watch before hand for a quick start:

📔 Resources to read :

--------------------------------------------------------------------------------
Creating content and investing time was only possible because of the constant support and feedbacks from you all. Grateful for that !

🔴 Don't forget to subsribe to my channel if you like my videos ! ✨

🔥 By becoming a patron, you'll get access to exclusive content, codes, or videos beforehand, one-to-one web app development / relevant discussion, live-chat with me on specific videos and other perks. ( FYI : Basic Tier is 50% cheaper than ChatGPT/monthly with benefits which an AI can't help with 😉 ):

And of course, I will check your feedbacks and would definitely love to cover those as well, so please feel free to leave your comments and suggestions 🤗

#streamlit #aggrid #python #googlesheets #webdevelopment #webapp #pythonforbeginners #pythonprogramming #googlesheet #pythonprogramming #pythonprogramming #dataanalytics #uidevelopment

Video Segments
0:00 Introduction about the video and Web App
5:25 Workflow : Writing the App
6:30 Installation and working with packages
9:50 Implementing a basic AgGrid table
11:01 Render Buttons within AgGrid Table
18:03 Adding Function to the rendered button
22:42 Wrapping within a Submit Button for ease of use
24:33 Automate Streamlit Plots
26:21 Download the AgGrid data
27:28 Quick recap untill now what we did
28:34 Connect AgGrid with Database (Google Sheet)
33:20 Summarize the app
34:26 Wrap up

Looking forward to hear from you all ! 🤗
Ta-Da ! 🐱
————————————
A gentle reminder , times are difficult for all of us lately . With an ongoing pandemic and a tragic war, feeling overwhelmed and mentally exhausted is very common . Let’s try not to be harsh on ourselves and take good care of our physical and mental well being for the brighter tomorrow. Love and strength ❤️
—————————————

[Avra_b]

Hey guys ! I hope you enjoyed this video 🥳
Also don't forget to start with the first two part of the Streamlit-AgGrid videos for better understanding ⤵

Let me know any feedbacks or AgGrid - feature suggestions you would love to add in your app in the comment section below. Stay in touch, cheers! 🤗

[ficciones]

Your video is even better than I expected 🤯 So complete! Thanks so much!!!!

[littlecoder]

Great stuff Avra! Liked the fact you highlighted the comment that drove this video theme.

[alexhahn]

You're so awesome!!! Thank you for sharing your knowledge. This video helps me a lot. 😁👍👍👍

[kirankrisnan]

Great video! Is there any way to view the entire contents of a cell in Ag grid like the way in streamlit dataframe. Streamlit dataframe shows entire cell data when we click on it. Data in my cells are very lengthy. It's not practical to scroll the column or rows all the way to view the entire cell contents.

It will be great if you find a solution to this.

[xnns_]

thank you for video!! cat's are so cuteeee

[hayatt]

Amazing implementation of concept. Really Useful. I treied your repo but That green background and Add text in 2:33 s not appearing for me also lock_position param is not chaning location. Can you exactly list version of streamlit and ag grid. ? I tried the one on requirements.txt already.

[sathyahisto]

Excellent video i have watched it multiple times....is it possible to add st.multiselect in each row?? Example: cricket teams in first column and multiselect column as worldcup Winning years( India, [1981, 2011])

[ibaha]

@Avra_b how can you make that add row button to have delete row functionality, as well? Also, how can you add a button to move a selected row up or down?

[hanwoonlow]

Thanks for the video. I am building a web application to extract database from a Microsoft Spreadsheet in iCloud (or alternatively OneDrive) to a Ag-grid table. After converting to data frame and displayed in the Ag-grid table, the "Date" column is shown as "2000-01-01T00:00:00" format. Anyway to display it as yyyy-mm-dd in the table (Tried on value formatter without success)? After all the updating of data in the Ag-grid table, I would like to update all the changes back to the Microsoft Spreadsheet in iCloud or OneDrive. Is there any references that you can guide me to resolve the above issues?

[jaggyjut]

Is it possible to add a dropdown list to the agGrid?

[assavinkengkart]

HI..Avra
Could you share that code?
Thank you

[manuelorellana]

How can you add some dropdown or select items in the grid? Using javascript as well?

[jbivisual]

Avra, why pre_selected_row not functioning, when option i set (0, 2), the system always respon first row an second row, but i want to select first row and third row?

[lqtube]

great video! if i want to customize the whole spreadsheet like width, style and etc is it only through the cellstyle_jscode, where can i find a complete list of things that i can customize?

[谷哥-th]

I'm going crazy!
when I use streamlit + aggrid, the aggrid always reload! It make the page too slow!
select a row in aggrid, the aggrid reload;
change any streamlit widget, the aggrid reload;
add @st.cache before the grid_build function, the grid began to disappear!