Formula Question

Hello @helloplanetat

Thank you very much for using our plugin. I don’t know the values you want to sum in “Then add the two values together”. But if you are referring to summing the min_value/2+max_value

Assuming the input fields in your form are:

Elevation gain, fieldname1
Distance, fieldname2

And the equation in the calculated field:

(function(){
let v1 = fieldname1/300,
v2 = fieldname2/3;

return MIN(v1,v2)/2+MAX(v1,v2);
})()

However, if you are referring to min_value/2+min_value, the equation would be:

MIN(fieldname1/300,fieldname2/3)*1.5

Best regards.

Thanks that worked perfectly ??

One more question: How can i change the font family of the form?

All the best,

Daniel

And is there a way do display max. 2 decimals in the “calculated field”? Thx ??

Hello @helloplanetat

The “Customize Form Design” attribute in the “Form Settings” tab is a CSS editor with syntax highlighting and errors check. It allows you to customize the form and fields’ appearance. For example, if you want to modify the form font-family, you can enter the style definition below (or similar) through the “Customize Form Design”:

#fbuilder *{font-family: Arial, Helvetica, sans-serif !important;}

Learn more about the form and fields customization by reading the following blog post:

https://cff.dwbooster.com/blog/2020/01/12/form-design

Best regards.

Hello @helloplanetat

You can use the PREC operation as the outermost operation in the equation:

PREC(X, Y) round the number X with Y decimals:

Ex.

PREC(MIN(fieldname1/300,fieldname2/3)*1.5, 2)

or

(function(){
let v1 = fieldname1/300,
v2 = fieldname2/3;

return PREC(MIN(v1,v2)/2+MAX(v1,v2), 2);
})()

Best regards.

Thanks for the awesome support!

One last question: Is there any way to display a Number as a time. So f.ex. 3,75 becomes 3:45?

thank you so very much for this awesome plugin <3

Hello @helloplanetat

Please look at the DECIMALTOTIME operation in the plugin documentation:

https://cff.dwbooster.com/documentation#datetime-module

But please note you must enter valid decimal values (3.75 not 3,75):

DECIMALTOTIME( 3.75, 'h', 'hh:ii' )

Best regards.