Create Custom HTML Forms With DynamicForm

2 years agoNo comment, be the first!
Great news! Creating HTML forms for your websites/apps just got easier with CalcFusion’s newest feature, DynamicForm.

With DynamicForm, users can create their form definition in Excel, upload it in CalcFusion, and the DynamicForm will generate a code that can users can copy and paste in order to embed into their website or app.

How can the DynamicForm help you?

The DynamicForm gives end-users the capability to implement CalcFusion without any necessary programming. With this new feature, CalcFusion is able to reduce (in some cases, eliminate) programming both on the back-end and front-end.

On the back-end side, defining formulas and some parameters on Excel means that there is no need to code the business rules or create small tables in the database for parameters. This is especially useful for managing multiple cases and exceptional cases.

On the front-end side, defining the form in Excel means that you are able to create an interface for your input fields and results without any programming. From the form definition created in Excel, the DynamicForm generates a code that you can copy and paste into your HTML page.

If all input fields are to be filled up by your users, then there is no need for additional programming. On the other hand, if you plan to use data from your enterprise software’s database as dynamic input, then you will have to setup CalcFusion web services to send and receive data between your software and CalcFusion.

How to use DynamicForm

DynamicForms can be integrated into Java and PHP website/apps and can also be integrated within your Salesforce.com Org.

1. Start with your Excel file which includes all the formulas that you would like to implement. From this, create a new tab FormDef (form definition).​

You will need to identify the input fields which will be the form, and the output fields which will be the result.
You can download a template here, and customize it as you want.

2. In CalcFusion, create a computation and upload your Excel file. Click on the DynamicForm icon. This will open a pop-up containing the form and the code that you can copy paste into your code.

3. For Salesforce, CalcFusion can be integrated by using Salesforce’s native App Setup function. Users can create a new Connected App, and just copy and paste the Callback URL that was generated by the DynamicForm. Salesforce will provide a Consumer Secret which you will have to input on the Dynamic Form. Finally, you can add the App you created into the Salesforce layout where you want it to be visible.

Download full instructions here.

Try it yourself

We have prepared a couple of use cases on CalcFusion wherein you can download the Excel file used for the computation and form definition, and see the codes that’s generated by the Dynamic Form.

  • Sales Commission
  • Selling Price
  • Currency Converter
  • Delivery Date
  • Shipping Price

Simply register for a Trial or Free account, and then login to access these use cases.

With your Trial or Free account, you can also create your own computations and use the Dynamic Form to embed your form/calculator within your own website/app.

If you are interested to know more about CalcFusion and the DynamicForm, drop us an email at sales@calcfusion.com. We’ll happy to provide free consultation and assistance on your first implementation.

Be the first to comment

Post a comment

START AUTOMATING YOUR EXCEL WORKFLOW TODAY NO CREDIT CARD NEEDED