[Plugin: Jazzy Forms] How IF condition is working?

Hi.

My apologies for not coming up with a reasonable documentation yet.

First of all: please don’t use IDs that start with numbers, that will result in invalid formulas. Valid IDs would be “value_1st”, “first” or “value1”.

Now, about the IF function. You can expect Jazzy Form’s functions to behave at least similar to those in popular spreadsheets programs. I.e.: IF(condition, value_if_condition_met, value_otherwise)

I’m not sure whether it were 2 separate examples or they belong together. Here is the joint expression, as two nested IFs:

IF(value1>10, value1*value2, IF(radio=1, value3*value4, 0))

In words: If value1 is greater than 10 then result is value1*value2, otherwise if the radio button is set to yes then the result is value3*value4, otherwise it’s zero.

I hope this makes it a bit clearer.

Nested IFs seem to cause a certain degree of confusion. I’ll try to clarify it here, but you can as well google for any spreadsheet tutorial on this topic.

IF(condition_1, value_if_condition_1_met, IF(condition_2, value_if_condition_2_met, IF(condition_3, value_if_condition_3_met, value_otherwise)))

It is evaluated like this BASIC pseudo-code:

IF condition_1 THEN
	RETURN value_if_condition_1_met
ELSE
	IF condition_2 THEN
		RETURN value_if_condition_2_met
	ELSE
		IF condition_3 THEN
			RETURN value_if_condition_3_met
		ELSE
			RETURN value_otherwise
		END IF
	END IF
END IF

It’s commonly called nested, because it is an IF function within the “then” or “else” part of another IF. One inside another like Matryoshka dolls.

sopedro, hiding/showing elements based on conditions is not there yet (as . But it’s definitely on my to-do list. I’m tracking it at https://github.com/l90r/jazzy-forms-dev/issues/15