Conditional text to show based on value of another field

Hello @fooey

That’s possible with the free plugin distribution, and the solution is very simple.

I’ll try to describe the process with a hypothetical example.

Assuming you have a calculated field (I’ll call it fieldname1) whose equation is fieldname2+fieldname3, however, if the sum is lower than 500, you can display the text “the value is lower than expected”

The simplest solution would be to include a conditional operation in the equation:

IF(fieldname2+fieldname3<500, 'the value is lower than expected', fieldname2+fieldname3)

Or if you prefer to implement the equation by using the function structure and the “if” conditional statement:

(function(){
let value = fieldname2+fieldname3;
if(value<500) return 'the value is lower than expected';
return value;
})()

If the text is longer than the input box of the calculated field, you can use it as an auxiliary field, only for calculation, but display the result in another field that doesn’t use an input box.

In this case, you can configure the calculated field as hidden (remember it is use as an auxiliary for calculations) by ticking a checkbox in its settings, and insert an “HTML Content” field in the form and enter a DIV tag in its content (or any other HTML tag) with the data-cff-field attribute indicating the name of the field whose value you want to display in the tag. In this example, the data-cff-field contains the calculated field’s name:

<div data-cff-field="fieldname1"></div>

Another alternative is to use the SHOWFIELD and HIDEFIELD operations included in the “Managing Fields Operations” module (https://cff.dwbooster.com/documentation#managing-fields-module)

In this case, you can insert an “HTML Content” field in the form (I will call it fieldname4) with the text directly in its content:

the value is lower than expected

And then, you can edit the equation in the calculated field as follows:

(function(){
let value = fieldname2+fieldname3;

HIDEFIELD(fieldname4|n);
if(value<500) SHOWFIELD(fieldname4|n);

return value;
})()

Note that the fieldname4 in the equation includes the |n suffix or modifier. The plugin replaces the field names in the equations by their corresponding values before evaluating them. The |n modifier tells the plugin you are referring directly to the field’s name instead of its value.

Learn more about the different modifiers by reading the text in the yellow frame, visiting the following link to the plugin documentation:

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

Best regards.

Hello @fooey

Ok, please follow the steps below:

1. Insert an HTML Content field in the form and enter the text you prefer in its content.

2. In the “Advanced Settings” tab of the “HTML Content” field, tick the checkbox to hide the field to hide it by default.

For the next step, I will assume the HTML Content field’s name is fieldname123 (please use the correct field’s name in your form).

3. Finally, edit your current equation as follows:

(function(){
  let divider = {1:15650, 2:21150, 3:26650, 4:32150, 5:37650, 6:43150, 7:48650, 8:54150}; 
  let result = fieldname2/divider[fieldname3]*100;
  
  HIDEFIELD(fieldname123|n);
  if(result < 500) SHOWFIELD(fieldname123|n);

  return PREC(result,2);
})();

Please note that I edited your equation for optimization purposes. I reduced the number of “if” conditional statements and the volume of code.