Great video! I need some opinion, if let say I have an app that collect thousands of data and images daily, should I use Google Drive and Google Sheet or better for me to use private database? Saya tangah cari solution utk app sy skrg ni. total daily row added can up to 5000, image uploaded almost 10k daily. jadi nak maintain guna Google Drive agak susah sebab slow
Hello! based on your case it's best to go Enterprise, by using cloud database. Any cloudSQL , be it Google, Microsoft, MySQL or AWS and the likes of it. Bila data dah makin besar elok guna proper database sebab Excel/Spreadsheet tak sesuai. Slow processing for sure
Hi! I really apreciate your videos. Can you do some about automation of calling a script from appsheet? I need to merged the pdf files that are add in appsheet with the pdf that is generated from appsheet.
Hi Aris, very well done video. I would like to ask you what is the advantage of using MySQL database compared to googlesheet or Appsheet database? My use case is a complex app that needs 6 databases, several columns (some around 50 columns) and a total of 300,000 rows accumulated over time
Hello! Congratulations on embarking a large project for Appsheet! Well, your case would definitely depends on few factors. How beefy is the hardware (server) and underlying software limits..size limits usually can go up to terrabytes.. you can however look at cloud database options too..i've tried a few and my favourite is both BigQuery (Google) and mySQL.. Cloud db offers more speed too, spreadsheet tends to slowdown as data grows..Appsheet DB limit is 200k rows which wont fit your case eventually
@@aris_azhar I'm a complete beginner. The app is used internally and is quite simple, it is an inventory app that will have to record more than 100,000 objects and do other small things like having an accessible change log. Doing the math I should get to 300,000. Among your videos I saw the one where you talk about Supabase, I tried it but it's really difficult and many things that work with Google Sheets now, but don't with Supabase. Much easier Appsheet DB and for now I'm using it for just one app table. I wonder if you will make other videos on Supabase :) Thank you
Hi Aris, good day. I learned a lot from your videos. Big thanks. Would like to seek a little help. I have 4 tables in appsheet, all of them have a date completed column. I want all the the date completed columns to be displayed in 1 calendar view. Hope you'll notice this. Thank you!
Salam aris. TQ for all your videos. I want to ask a question. If we have 2 tabs in goggle sheet.. example tab1 active customer. Tab 2 inactive customer. How to search in both table at the same time by using appsheet?.. Tq
hello, I'm from Indonesia Permission to ask, does an appsheet with a spreadsheet database have a maximum row of 10,000 rows? I once reached 10,000 rows, the application errored and how do you get unlimited without row limits? Do you use MySQL and there are no row limits?
Thank you Brother, I was looking for this topic. very helpful.
You are most welcome dear brother! Glad it helps!
I don't know how to thank you,💪
Happy to help! Appreciate your support too!
Thanks for this video
The pleasure is all mine! Thanks for the support
Thanks 4 shared
you are most welcome sir!
Great video! I need some opinion, if let say I have an app that collect thousands of data and images daily, should I use Google Drive and Google Sheet or better for me to use private database? Saya tangah cari solution utk app sy skrg ni. total daily row added can up to 5000, image uploaded almost 10k daily. jadi nak maintain guna Google Drive agak susah sebab slow
Hello! based on your case it's best to go Enterprise, by using cloud database. Any cloudSQL , be it Google, Microsoft, MySQL or AWS and the likes of it. Bila data dah makin besar elok guna proper database sebab Excel/Spreadsheet tak sesuai. Slow processing for sure
Hi! I really apreciate your videos. Can you do some about automation of calling a script from appsheet? I need to merged the pdf files that are add in appsheet with the pdf that is generated from appsheet.
Hi Aris, very well done video. I would like to ask you what is the advantage of using MySQL database compared to googlesheet or Appsheet database? My use case is a complex app that needs 6 databases, several columns (some around 50 columns) and a total of 300,000 rows accumulated over time
Hello! Congratulations on embarking a large project for Appsheet! Well, your case would definitely depends on few factors. How beefy is the hardware (server) and underlying software limits..size limits usually can go up to terrabytes.. you can however look at cloud database options too..i've tried a few and my favourite is both BigQuery (Google) and mySQL..
Cloud db offers more speed too, spreadsheet tends to slowdown as data grows..Appsheet DB limit is 200k rows which wont fit your case eventually
What to do if rows crossed 200K ?
@@aris_azhar I'm a complete beginner. The app is used internally and is quite simple, it is an inventory app that will have to record more than 100,000 objects and do other small things like having an accessible change log. Doing the math I should get to 300,000.
Among your videos I saw the one where you talk about Supabase, I tried it but it's really difficult and many things that work with Google Sheets now, but don't with Supabase. Much easier Appsheet DB and for now I'm using it for just one app table.
I wonder if you will make other videos on Supabase :)
Thank you
Hi Aris, good day. I learned a lot from your videos. Big thanks.
Would like to seek a little help.
I have 4 tables in appsheet, all of them have a date completed column. I want all the the date completed columns to be displayed in 1 calendar view. Hope you'll notice this. Thank you!
Salam aris. TQ for all your videos.
I want to ask a question. If we have 2 tabs in goggle sheet.. example tab1 active customer. Tab 2 inactive customer.
How to search in both table at the same time by using appsheet?..
Tq
Waalaikumussalam!
One video coming right up!
hello, I'm from Indonesia Permission to ask, does an appsheet with a spreadsheet database have a maximum row of 10,000 rows? I once reached 10,000 rows, the application errored and how do you get unlimited without row limits? Do you use MySQL and there are no row limits?
Did you answer ?
Tuan mcm mn nk cri ip hosting tu dlm myphpadmin jea?
Tuan pakai hosting yang sama atau berbeza?
pakai mesra hosting tuan@@aris_azhar
dh masukkan six.mesra.my tp fail to connect to database@@aris_azhar
saya rasa perbezaan UI mungkin menjadikan isu ni berlaku. Saya kena check six mesra punya UI. Mungkin kita boleh meeting online dan semak bersama
@@aris_azhar boleh tuan. Nnt sy cntc tuan melalui telegram.
i love you :)
love received and returning my love back to you!
🥰
Thanks for this video