CalcBuilder Forum

Hi,
ok, no problem, we can send you the refund. However we'd like you to know the complex calculator you're trying to build is easy to configure using calcbuilder and the 'linked list' input type. We have created a very simple example of dependant comboboxes here:

https://demoj4.moonsoft.es/calc-builder/calculator-template

Where the 'tool' combobox changes dynamically with each selection of the 'method' input. The result can be calculated using php or an excel spreadsheet. We'd suggest to take a look first to this example, because if you think it can help, we can send you the calculator to import into your calcbuilder and check how configuration its done, then adapt it to your use case with our support if needed.

If you definetively think it won't do the work, just let us know and we'll send the refund asap.

Best regards
Silvia Martín
Moonsoft Team

Hi,
ok, per your image, not sure which cells would be the outputs, and if the user should be able to add as many lines method+tool+material...as required.

If this is the case, this can be built using the 'sections' configuration, where you add some fields to a section, and then the user can add this section many times, with buttons to add/remove line (please see demo page again)

https://demoj4.moonsoft.es/calc-builder/calculator-template

For this example the user can add some lines, and for each line, the excel calculates +3 to the result, following the spreadsheet formula.

We attach at the zip file:
- The first example with the dynamic comboboxes: here the trick is to set 'tool' field as a 'linked list' and configure the field name and options following the convention
For the field name: parentfield_name (method_tool)
For the valid options : parentvalue_value (m1_t1)

Please check the fields method and tool to check how to configure.

Another method of recovering valid options is also available, storing data at the database and recovering them with a query, let us know if you'd prefer that option.

Following this method more comboboxes can be concatenated with the values loading dynamically.

- The second example with the dynamic comboboxes AND dynamic sections: Here we have created a 'section', attached the 3 fields to it, and then sent to the excel sheet the values of each line, to recover final result at cell C17 (excel attached as well). The only difference for sending inputs to the excel is that you need to send each 'line' to a different cell, while for a single value you'd configure

variable->sheet->cell
method->0->A5

for sections, it would be

variable->sheet->cell
method->0->A5
method->0->A6
method->0->A7
...etc

Unzip the file and import any of the xml into your calcbuilder to see the example working. For the 2nd example (sections), please remember to upload the excel file to the 'spreadsheet' section as well.

Hope this helps, please let us know if you have further questions. We understand there are a big amount of configuration options, and it may seem complex at the begining, but hopefully with these examples you can focus just on the ones required for your form.

Regards
Silvia Martín
Moonsoft Team

Hi,
yes, such configuration is possible. You can start working with the first example we gave you, and you'll see the options of the second combobox (tools), change with every selection of the first one (method). Now, you can attach a new combobox (thickness), with dynamic options depending on the tools one, that way you will be chaining the dynamic options and everytime one of the intput changes, the comoboxes will reload accordingly.

If only one of the combinations method/tool must ask for the thickness, the rest of the combinations will show (empty) comobobox, or maybe you can show a text 'no required' as the option of the combobox, or even hide the entire input field if no options are available, but this would require you to enter some js code at the form to introduce this behavior.

With a default numeric input the form will be complete, and you can send all these inputs to your excel and return the result.

Let us know if you need further help with any of the steps.

In addition, please note we have a custom calculator service, if you prefer us to configure the calculator for you and send it ready to publish. In case you're interested, you only need to send the excel and details to gestion@moonsoft.es in order to get a quote.

Thanks, regards
Silvia Martín
Moonsoft Team

Hi,
the important step here to check would be the mapping of the inputs/outputs with the excel (please note the first spreadsheet tab is number 0). Then the data flow should work without problems. We can check your configuration if you share an access to your site at the 'private data' section of this ticket. Or, you can export the calculator you are trying to build, zip it together with your excel file, and attach it to the ticket. We'll load it here and let you know if there is any configuration parameter that needs to be adjusted.

Thanks, best regards
Silvia Martín
Moonsoft Team