Jun 2, 2023 Replies: 48 Hi there NB: Download and run PocketBase and set up an admin account there first. Here is the link Demo hosted on Vercel. Disclaimer: The back-end (PocketBase) for this demo is hosted on PocketHost.IO (SAAS Company), which is not optimal for production usage. Ceveat: WebApp Slow in accessing data from DB. This is different when you host / run your own version of PocketBase locally. This MiniCRM has functionality for Customers Emails Email Templates Reminders Communication Appointments Tasks Documents and more PocketBase - Open Source backend in 1 file Open Source backend in 1 file with realtime database, authentication, file storage and admin dashboard pocketbase.io Pay SITHASO HOLDINGS (PTY) LTD using PayPal.Me Go to paypal.me/anelembanga and type in the amount. Since it’s PayPal, it's easy and secure. Don’t have a PayPal account? No worries. paypal.me Attachments 1685689918007.png 75 KB · Views: 729 Last edited: Aug 13, 2023 Click to expand...
Hi there NB: Download and run PocketBase and set up an admin account there first. Here is the link Demo hosted on Vercel. Disclaimer: The back-end (PocketBase) for this demo is hosted on PocketHost.IO (SAAS Company), which is not optimal for production usage. Ceveat: WebApp Slow in accessing data from DB. This is different when you host / run your own version of PocketBase locally. This MiniCRM has functionality for Customers Emails Email Templates Reminders Communication Appointments Tasks Documents and more PocketBase - Open Source backend in 1 file Open Source backend in 1 file with realtime database, authentication, file storage and admin dashboard pocketbase.io Pay SITHASO HOLDINGS (PTY) LTD using PayPal.Me Go to paypal.me/anelembanga and type in the amount. Since it’s PayPal, it's easy and secure. Don’t have a PayPal account? No worries. paypal.me
Mashiane Expert Licensed User Longtime User Aug 11, 2023 #41 Drill Down by using the "Sales" column to see all sales for that product from the Products Listing
Mashiane Expert Licensed User Longtime User Aug 13, 2023 #46 Demo on Vercel Updated: SithasoDaisy Mini CRM - PocketBase Sithaso Daisy Design System sithaso-daisy-mini-crm.vercel.app
Demo on Vercel Updated: SithasoDaisy Mini CRM - PocketBase Sithaso Daisy Design System sithaso-daisy-mini-crm.vercel.app
Mashiane Expert Licensed User Longtime User Aug 14, 2023 #47 Hi Should you need customization of this app to meet your needs, do not hesitate to DM me and we can talk. No further development will happen on this project anymore. It has been an amazing, challenging and fullfilling piece of art. Stay blessed and take care.
Hi Should you need customization of this app to meet your needs, do not hesitate to DM me and we can talk. No further development will happen on this project anymore. It has been an amazing, challenging and fullfilling piece of art. Stay blessed and take care.
Mashiane Expert Licensed User Longtime User Feb 17, 2024 #48 Finding the top customers. In pocketbase create a collection with a type of view. Use the specified query. Code: select minicrm_sales.id, count(minicrm_sales.quantity) as totalqty, sum(minicrm_sales.totalprice) as totalsales, minicrm_sales.customerid from minicrm_sales group by minicrm_sales.customerid order by totalsales DESC
Finding the top customers. In pocketbase create a collection with a type of view. Use the specified query. Code: select minicrm_sales.id, count(minicrm_sales.quantity) as totalqty, sum(minicrm_sales.totalprice) as totalsales, minicrm_sales.customerid from minicrm_sales group by minicrm_sales.customerid order by totalsales DESC
Mashiane Expert Licensed User Longtime User Feb 17, 2024 #49 Finding the top products. In pocketbase, create a new collection with a type of 'view', use the specified query. Code: select minicrm_sales.id, count(minicrm_sales.quantity) as totalqty, sum(minicrm_sales.totalprice) as totalsales, minicrm_sales.productid from minicrm_sales group by minicrm_sales.productid order by totalsales DESC
Finding the top products. In pocketbase, create a new collection with a type of 'view', use the specified query. Code: select minicrm_sales.id, count(minicrm_sales.quantity) as totalqty, sum(minicrm_sales.totalprice) as totalsales, minicrm_sales.productid from minicrm_sales group by minicrm_sales.productid order by totalsales DESC