My company is selling 16 custom products. Every product has ~20 base fields that are the same for every product and ~10 custom fields per product. Products are sold separately, only 1 product per deal. Custom fields are only used for price calculations and aren’t really important in final database, however data still needs to be saved in case of duplicate order or order change.
It’s obvious we cannot use one database for every product sold because there would be ~200 columns in database with many columns empty.
Is there a way or work-around to aggregate sales from all databases to list only before mentioned “Base fields” to have a single report-type “All sales” sheet? Or have all of the sales from different databases in one single linked sheet for clients?
To work with aggregation on your products, all your products should be saved in one product sheet. If possible, I would suggest creating 20 “base fields” on your product sheet because it fits all your products, and a free text field or a rich text editor field to save the information of your “10 custom fields”.
Impossible, each value of custom fields is used for calculating price of product, there is various information - numbers, drop downs, free text. Saving them in one field is not an option. Creating 200 columns is not an option. Any other solutions?
Do you have data examples for us to refer to? If you wish to not share them publicly, you can submit a support ticket to allow Ragic support to help you privately via email.
You definitely need a main standard database/sheet for the 20 base fields. Then have 16 other database/sheets for the individual custom fields. And link the corresponding entries. Unfortunately, your main sheet will still have all 100 over linked fields. However, you can control what fields are shown in the subtables in the main sheet, and also hide unneeded subtables using conditional formatting (i.e. show only the relevant subtable based on the selected product).
