Calculated field

Hello @borlee123

Thank you so much for using our plugin! If you have a slider field named fieldname123, for example, and you want to modify its value using code. For instance, you might want to set its value to 5725.

Insert a calculated field as an auxiliary. Configure it as hidden and exclude it from the submission by checking the corresponding boxes in its settings. Finally, enter the equation:

getField(fieldname123|n).setVal(5725);

If you want to use the minimum slider value and add another field’s value (fieldname456) to it, the equation would be:

getField(fieldname123|n).setVal(SUM(getField(fieldname123|n).min, fieldname456))

Note the use of the |n modifier with the field name fieldname123|n. The plugin replaces the field names with their values in the equation before evaluating it. The |n modifier indicates that you are referring to the field name directly rather than its value.

Best regards.

Hello @borlee123

Your solution is correct. However, I prefer to use the function structure for the equation instead of nesting multiple “IF” operations, because it is more readable and easier to maintain in the future.

(function(){
	let f8 = fieldname8;
	if(f8 <= 10) return 5985;
	if(f8 <= 21) return 11555;
	if(f8 <= 31) return 16880;
	if(f8 <= 41) return 22205;
	if(f8 <= 51) return 27530;
	if(f8 <= 61) return 34175;
	if(f8 <= 71) return 39500;
	if(f8 <= 81) return 44825;
	if(f8 <= 91) return 50150;
	if(f8 <= 101) return 55475;
	if(f8 <= 111) return 62780;
	if(f8 <= 121) return 68105;
	if(f8 <= 131) return 73430;
	if(f8 <= 141) return 78755;
	if(f8 <= 151) return 84080;
})()

Keep in mind that your equation needs multiple “if” conditional statements because there is no straightforward algorithm for your request.

For example, if your slider step is 10, and every step represents an increment of 5325 in the calculated field’s equation, and the base value is 660 (note these values are hypothetical, I’m using them based on your code values). The equation could be implemented as follows:

660+MAX(1,CEIL(fieldname8/10))*5325

The previous code is an hypothetical example for an equation that represents a specific process for value calculation.

Best regards.

Hello @borlee123

Could you please provide the URL to the page containing the form to check the field’s settings? I don’t understand your explanation.

However, if you want to increase the base number 6115 by 878 for each step over 4 in fieldname197, the equation would be as simple as:

6115+878*(MAX(fieldname197-4,0))

And that’s all. You don’t need to use conditional statements or any other complex operation. It is a simple mathematical expression.

Best regards.

Hello @borlee123

If you have been satisfied with both the plugin and our support, we would be immensely grateful if you could leave us a review on the plugin ( https://ww.wp.xz.cn/support/plugin/calculated-fields-form/reviews/ ). Your feedback will help us reach more users. 

Best regards.