Share My Creation SithasoDaisy: PocketBase - Mini CRM WebApp Source Code @ $5.00

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

1691955265395.png


1685685831466.png


1685685947927.png


1685685966547.png


1685685991013.png


1685686012154.png



1685980359880.png




 

Attachments

  • 1685689918007.png
    1685689918007.png
    75 KB · Views: 250
Last edited:

Mashiane

Expert
Licensed User
Longtime User
Finding the top customers.

In pocketbase create a collection with a type of view. Use the specified query.

1708198206239.png


B4X:
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
Finding the top products.

In pocketbase, create a new collection with a type of 'view', use the specified query.

1708198287318.png


B4X:
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
 
Top