module for dental clinic

[stayfi]

hello, i want to customize my database to fit a dental clinic, any modular extension or hack? thanks.

[shalmaxb]

Hi, you don`t need to "hack" anything. Just develop your necessary entities with what espoCRM has to offer, what is a overwhelming lot. You could use some or the most of the core entities, already in the system, customize thes and think about, what you could need beyond that.
For some tasks there are extensions, as well from espoCRm itself, as from other developers.
The most profit from what espoCRM has to offer you get from starting with it, the rest will follow.

[dimyy]

The hack is to replace default fullCalendar 3 to fullCalendar 5 and use resource view

[esforim]

Cool idea, do you just replace the files? Or need to configure/compile or do some editing?

[Riad]

@eymen-elkum https://www.youtube.com/watch?v=qVQM9kbOvf0

[stayfi]

Hi, you don`t need to "hack" anything. Just develop your necessary.

thanks, i'm just a begginer with it, is it possible to create fields for name, date of treatment, type of treatment, total price, and payed money in new entity, and tutorial? thanks again

[shalmaxb]

Yes, that is all possible. You can create a lot of field types, can calculate, where necessary and lot more. If you are starting with it, try to make a simple entity first to get used to the procedure. With time you will discover lot of possible things.
The example of eymen-elkum is quite advanced though.
I think, there is no tutorial to create a complete app, but there are some videos with basic information. The best progress you will make starting.
Here in this forum you also will find lot of help.

[telecastg]

You should probably start by reading the documentation.

https://docs.espocrm.com/administration/entity-manager/

Creating new entities with their own fields and layouts is a breeze with Espo.

This system it is the closest thing to an "application generator" with the added advantage that is completely open so you can modify it exactly to your needs.

In addition to the documentation, I would also recommend checking this post by emillod https://forum.espocrm.com/forum/deve...ink-#post72712 and this wiki by esforim https://github.com/o-data/EspoCRM-Le...nd-Design/wiki

[esforim]

Link above is broken, here it is:

https://github.com/o-data/EspoCRM-Learning-and-Design/wiki

[stayfi]

Yes, that is all possible. You can create a lot of field types, can calculate, where necessary and lot more.

I'm on it now, what are the fileds to enter, total money, payed money for example? thanks again

[shalmaxb]

Hello,
it would be "currency".

Guessing from your question, I think you are missing fundamentals. I don`t know, how you will create an entity (what isn`t even a difficult part), when you do not have the knowledge, what field from the fields espoCRM is offering, to use.
Don`t get me wrong, it`s not my intention to bash you in any form. But please, try to get information about the overall concept of espoCRM first (documentation), try to get some knowledge of database creation in general (because in the end, espoCRM has a lot to do with knowledge about database).

If you not get the foundation, you will have to ask in the future any single step, which you need. And creating relationships, formulas or even script manipulation will be a nightmare for you (and us here in the forum).
Recently our fellow forum member emillod started to provide a bunch of fundamntal videos, that you will find here: https://forum.espocrm.com/forum/deve...-do-you-think-
Don´t hesitate for your own sake, to use the sources available.

[stayfi]

Hello,
it would be "currency".

Guessing from your question, I think you are missing fundamentals.

hell yes, total noob here, i did my entity right, and you were right: currency is the word to fetch in "types". i'm glad to learn, and see if i can ditch excel for good.

The problem for newbies to Crms are the terminology, lots of new words to navigate, i wish for a dictionary of crms.

i'll take it easy, thanks again.

[telecastg]

Another option if you don't have any experience and prefer a ready made solution, would be to post your project in the jobs section of the forum.

[esforim]

Very hard to ditch excel for calculation (especially complex one or repeated). For me CRM is more of making connection between different thing and visual usage structure.

I'm still looking for a self-hostable (share host supported) Excel alternative that work with PHP, everything require additional install software at the moment

[shalmaxb]

Don`t have you confused by CRM Terms. As far as I can judge from your question, you won`t use espoCRM that much as an CRM. Use core entities, that are obviously necessary, as Contacts (for your clients). Extend it, where necessary and create new entities, where the CRM is not specialized in.
For example, I would create for your client`s treatment a new entity, let`s call it treatments. In first place, this entity would bear all the possible treatments and the connection to the respective client you do with a relationship to the contact, where your client should have one record.

Try it with something easy as that and later you will get an idea, which data you put in and which entities may use the same data on various places. Don`t put everything in one entity. (One principal rule for databases is economy of data, don`t create it so, that you have to put in the same data more than once).

As for CRM terms, I think you won`t need everything provided by espoCRM. Just have a look at the sequence of CRM:

- Opportunities (these are possible customers, which later could be converted to contacts)
- Leads (these are possible sales, connected to possible opportunities)
- Contacts (customers, that already had business with you)

- Accounts (these are companies, that are necessary in your process)

This is the side of customers and suppliers of your business.

Then you have the side of products and sales, like

- products
- quotation
- sales orders
- invoice

This part in espoCRM is best possible with the Product/Invoice extension (paid), but you also may create your own entities for that.

And you have all the possibilities of treating the process, like

- Activities
- Email
- Cases
- Calendar

- Teams
- Roles
- Workflow (workflow extension, to automate the process, paid)

- Reports (paid extension), but you can use also the PDF function in any entity.

If you have a look at the whole process, you will see, that you won`t need all of it, perhaps only a few parts. What you don`t need, you may deactivate.
What you else and beyond this will need, you have to create yourself, what in fact is easy with espoCRM. It is sometimes remarkable, how well thought this app is and what is all possible.
I hope that sheds a bit of light on it.

[shalmaxb]

perhaps it could help, if you post here, what you want to achieve.

[stayfi]

Thanks shalma, I'll try to post screenshots of my excel sheets. So far I've made a good entity, the word currency is what i needed, espo is swift, i think quicker thwn suitecrm.

Have a nice weekend.

[LuckyLouie]

The hack is to replace default fullCalendar 3 to fullCalendar 5 and use resource view

dimyy Could you share more info how to replace fullCallendar 3 to 5?

[dimyy]

customize:

/client/modules/fullCalendar5/src/views/calendar/calendar.js
/client/modules/fullCalendar5/src/views/calendar/calendar-page.js
/client/modules/fullCalendar5/src/controllers/calendar.js

and necessary files

[esforim]

Surprisingly it quite hard to find installation guide from their official documentation. Look like it is on purpose.