Adding fields

Hello,

Assuming that the names of number fields are: fieldname1, fieldname2, and fieldname3, you simply should select the calculated field an enter the following piece of code through the “Set equation” attribute:

fieldname1+fieldname2+fieldname3

If you need additional help implementing your project, I can offer you a custom coding service from my private website:

https://cff.dwbooster.com/customization

Best regards.

Thanks for the response.

I did change the field names so not sure if that might be the issue?
It shows up at “fieldname1(Advertising & Marketing)” in the drop down list.

when I select that it still gives me fieldname1. Should I change it to fieldname1(Advertising & Marketing)+fieldname2(Employer Branding)?

and is it normal it doens’t show up in Preview?

Hello,

You should use the in the equation the names of fields in your form. Could you send me the link to the webpage where the form is inserted for checking the equation in action, please?

Best regards.

Here you go,

https://www.incruitx.com/wp/calculator

Hello,

I’ve checked your form, and all the equations are incorrect.

– The equation associated to the fieldname10 field. In javascript if you want to use plain texts in the operations, you should close them between single or double quotes, so, the equation would be:

'Advertising & Marketing'+'Employer Branding'+'Consulting & Agency Fees'+'Selection Procedures'+'Travel Expenses'+'IT-Infrastructure'

– The equation associated to the fieldname15 field. If you want sum the fields: fieldname11, fieldname12, fieldname13 and fieldname14, the equation would be:

fieldname11+fieldname12+fieldname13+fieldname14

– The equation associated to the fieldname17 field would be similar to the previous one:

fieldname10+fieldname15

– The equation associated to the fieldname17 field. You should use only the names of fields (without any other text), furthermore, I recommend you check if the value of fieldname18 is zero or not to avoid mathematical errors:

IF(fieldname18, fieldname17/fieldname18, '')

I recommend you read any of free javascript tutorials available in the web.

If you need additional help to implement the equations, I can offer you a custom coding service through my private website:

https://cff.dwbooster.com/customizatio

Best regards.

Ok sorry for bugging you again.
I have looked at the simple operations example
then I checked my own calculator.
Instead of Number fields, I’ve used Currency fields.
The calculated field however does not add things up when I enter them.
That’s my “frustration”.

It’s all the same as your examples and these are the equations.
What might be the issue then?

Field 10= (External Cost Total)
fieldname27+fieldname28+fieldname29+fieldname30+fieldname31+fieldname32

Field 15= (Internal Cost Total)
fieldname33+fieldname34+fieldname35+fieldname36

Field 17= (Sum)
fieldname10+fieldname15

Field 18= (Number of positions)
Number field set to required between 1 and 10000000000

Field 21= (Cost-per-Hire)

Hello,

The issue is simple, you have unticked the “Eval dynamically the equations associated to the calculated fields” checkbox, in the “Form Settings” tab (https://cff.dwbooster.com/documentation#form-title-design). So, you should tick this checkbox again to evaluate the equations dynamically, or insert a calculate button in the form (a button field with the “Calculate” option selected for the button’s type)

Best regards.

Thank you so much!
That’s exactly what it needed!

You really helped me!
Thank you.

One more question for you.
In this version, is it possible to ask those who want to use the calculator to enter their contact info / email address to receive an email with the full spreadsheet results instead of showing the last field on the main page?

If so, how would I do that if I may ask :-).

Hello,

The fields include the checkbox: “Required”, if you tick them the form cannot be submitted if the required fields are empty (so, you can configure the email, and the other contact info fields as required). Furthermore, in the calculated fields you can tick the checkbox: “Hide Field From Public Page”, in whose case the calculated fields won’t be visible in the public form, but their results would be sent in the notification emails.

Best regards.

Question regarding the above. I have ticked the required boxes, and hide field from public page etc. Now when I go to the site, it does allow me to put the info in etc. but there’s no where where I can hit “sent” in order to get the outcome emailed to the email address that’s been uploaded.

And secondly, is there a place where I can store the information that’s been inputted by people using the calculator? Or would I need to upload that in a database myself?

Thanks so much for your help already!

Hello @willincruitx,

If you are using the free version of the plugin all server side processing should be implemented by yourself, however, the professional version will store the submitted data in the plugin’s database, and will redirect the user to the thank you page (whose URL is entered through the form’s settings), after submit the form and send the notification emails.

Note: If you want store the submitted data in your own database, would be required the Developer or Platinum versions of the plugin and edit the “cp_calculatedfieldsf_insert_in_database.php” file. More information in the followin link:

https://cff.dwbooster.com/documentation#third-party-database

Best regards.

Thanks.
I did purchase the Professional version.
Now, in order to install it, I’m being told to delete the free version first and then upload the zip files under plugins?

How does this make that I won’t lose the already created calculator in the free version? Or is there something else I need to do or is there an easy fix to upgrade from free to professional?

Hello @willincruitx,

You simply should follow the steps described in the following link:

https://cff.dwbooster.com/documentation#installation

The process does not affect the forms created with the free version of the plugin because does not modifies the rows in the database.

Best regards.

Hi,

I’m trying to change the color of the submit button in the calculated fields form but really am lost. Can you please tell me how I do this?