Suggestion of database with formulas behind the data entered

Using my Dolibarr
1

Hello,

I’m new to Dolibarr and I’m hoping this community can point me in the right direction.

We have an excel spreadsheet we currently use to enter data and calculate results based on simple multiplication formulas within some cells.

I’d like to move this spreadsheet to be a web based gui with a database to save the data

Does Dolibarr provide the ability for me to create a simple form for data entry and save this data into a database where the results of the data entered can be modified based on formulas for some of this data?

Thank you in advance for any advice you can provide.

2

Hi,

The ideal way is to create a separate module for your requirement mapping the correct database fields. You can use module builder to do that.

However, you need to take care of such customizations in case you upgrade Dolibarr to next version.

Alternatively, please check : https://www.youtube.com/watch?v=wTR9DMnpIck

If this works for you, then voila, just grab that from here : CustomizeForms

If this solves your requirement, kindly check “Solution” check box so that others who are searching the forum for similar requirements may find this useful.

thanks,
yesbee

3

Thanks very much for this reply. Very much appreciate your input and the link.