Multiline calculated field

Hello @morriscey

Responding to the first question, the process would be simpler by using dependencies. Insert an “Instruct. Text”, or “HTML Content” field with the instructions for the user, and configure this field as dependent on the checkbox field. More information about dependencies by reading the following blog post:

https://cff.dwbooster.com/blog/2020/03/01/dependencies

About your second question. If you want to generate a composed answer, you can use the CONCATENATE operation.

I’ll try to describe the process with a hypothetical example. Assuming the current equation is: fieldname1+fieldname2

You can edit it as follows:

CONCATENATE('You can get ', SUM(fieldname1,fieldname2), ' for R$', fieldname2)

If the text is too long and you prefer to use the calculated field as an auxiliary field but display the result into another field:

You can insert an “HTML Content” field with a div tag where display the result as its content: <div class="result-here"></div>

And edit the previous equation as follows:

(function(){
var result = CONCATENATE('You can get ', SUM(fieldname1,fieldname2), ' for R$', fieldname2);
jQuery('.result-here').html(result);
return result;
})()

Finally, since the calculated field is used as an auxiliary field, it is not essential for the form’s interface. So, you can hide it by ticking a checkbox in its settings.

Best regards.

OK Great thank you I have it very close.

I got it to display the message when they check the checkbox, but it displays immediately, instead of when they click calculate.

I think I’d rather have it display the text “O design possui um custo adicional. Faremos contato com você em breve para apresentar a cota??o completa.” in the concatenated text, at the end if that check box is selected.

I tried setting the value of the checkbox to the text I want, but it still displays “0” as the default value. How would I hide the zero? or properly include that text based on a checkbox?

Thank you for all your help.

Hello @morriscey

If you prefer to concatenate the text at the end of the result if the checkbox is ticked, instead of using dependencies, you can do something similar to:

(function(){
var result = CONCATENATE('You can get ', SUM(fieldname1,fieldname2), ' for R$', fieldname2);

if(fieldname8) result = CONCATENATE(result, ' O design possui um custo adicional. Faremos contato com você em breve para apresentar a cota??o completa.');
jQuery('.result-here').html(result);
return result;
})()

If you want to evaluate the previous equation only after the user enters the values into the fields fieldname1 and fieldname2, the equation can be edited as follows:

(function(){
    var result = '';

    if(AND(fieldname1, fieldname2))
    {
        result = CONCATENATE('You can get ', SUM(fieldname1,fieldname2), ' for R$', fieldname2);

        if(fieldname8) result = CONCATENATE(result, ' O design possui um custo adicional. Faremos contato com você em breve para apresentar a cota??o completa.');
    }

    jQuery('.result-here').html(result);
    return result;
})()

Best regards.