Formula Help

Hello @dvirhamami,

Actually you don’t need any additional field, only implement the equation using conditional statements.

I’ll try to describe the process with a hypothetical example, using random fields’ names and values, however if you need that I implement your project, you can request a custom coding service from my private website:

https://cff.dwbooster.com/customization

The project:

– Assuming your form includes a DropDown field called fieldname1, with 4 choices, whose texts are the different weight groups, and their corresponding values are the numbers from 1 to 4

– Another DropDown field, called fieldname2, with 5 choices, whose texts are the condition level, and their corresponding values are the numbers from 1 to 5

Now, you simply should insert a calculated field to determine the dosage, with an equation similar to:

(function(){
	var weight = fieldname1, level = fieldname2;
	if(weight == 1 && level == 1) return 11;
	if(weight == 1 && level == 2) return 12;
	if(weight == 1 && level == 3) return 13;
	if(weight == 1 && level == 4) return 14;
	if(weight == 1 && level == 5) return 15;
	if(weight == 2 && level == 1) return 21;
	if(weight == 2 && level == 2) return 22;
	if(weight == 2 && level == 3) return 23;
	if(weight == 2 && level == 4) return 24;
	if(weight == 2 && level == 5) return 25;
	if(weight == 3 && level == 1) return 31;
	if(weight == 3 && level == 2) return 32;
	if(weight == 3 && level == 3) return 33;
	if(weight == 3 && level == 4) return 34;
	if(weight == 3 && level == 5) return 35;
	if(weight == 4 && level == 1) return 41;
	if(weight == 4 && level == 2) return 42;
	if(weight == 4 && level == 3) return 43;
	if(weight == 4 && level == 4) return 44;
	if(weight == 4 && level == 5) return 45;
})()

Even, the equation can be optimized, nesting “switch” conditional operations:

(function(){
	var weight = fieldname1, level = fieldname2;
	switch(weight)
	{
		case 1:
			switch(level)
			{
				case 1: return 11;
				case 2: return 12;
				case 3: return 13;
				case 4: return 14;
				case 5: return 15;
			}
		case 2:
			switch(level)
			{
				case 1: return 21;
				case 2: return 22;
				case 3: return 23;
				case 4: return 24;
				case 5: return 25;
			}
		case 3:
			switch(level)
			{
				case 1: return 31;
				case 2: return 32;
				case 3: return 33;
				case 4: return 34;
				case 5: return 35;
			}
		case 4:
			switch(level)
			{
				case 1: return 41;
				case 2: return 42;
				case 3: return 43;
				case 4: return 44;
				case 5: return 45;
			}
	}
})()

or much better, you can define a plain object, as database with the weight and condition levels, and use it from the equations.

Best regards.

Hello @dvirhamami,

If the results are not numbers, you should return them enclosed between single or double quotes, as follows:

if(weight == 1 && level == 1) return '2mg-4mg+ Of CBD';

Now you should edit all your results.

Best regards.