codepeople

Hello @eberkland

I’m sorry, but I cannot answer your question by looking a screenshot only. Please provide the link to the page that contains the form and describe it.

Best regards.

Hello @ohtusabes

Yes, that’s possible. However, as the calculated fields use input tags, for long texts you should use the calculated field as an auxiliary field and display the result in another field.

For example, assuming you have the equation fieldname1+fieldname2, but you want to display the result with the format:

Hello user, you entered the values X and Y, and their sum is Z

Assuming the calculated field is the fieldname3, you can insert an “HTML Content” field in the form and enter a tag in its content similar to:

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

The data-cff-field attribute tells the plugin you want to use the fieldname3 value as the tag content.

Second, edit the equation as follows:

CONCATENATE('Hello user, you entered the values', fieldname1, ' and ', fieldname2, ' and their sum is , fieldname1+fieldname2)

Finally, as the calculated field is used as an auxiliary, you can hide it by ticking a checkbox in its settings.

Best regards.

Hello @mpmarinov

Could you please share your W3 Total Cache settings to try to replicate the issue on my side?

Best regards.

Hello @mpmarinov

The issue is related to the plugin you use to manage the website’s cache. Please visit the following link:

https://krasi-shehova.eu/bg/?cff-form=6

To prevent the cache plugin affects the forms, please insert the form shortcode with the iframe attribute set at 1.

[CP_CALCULATED_FIELDS id="6" iframe="1"]

Best regards.

Hi,

There is a feature for creating booking forms for logged in users. Check the following information: https://apphourbooking.dwbooster.com/blog/2018/11/10/logged-in-users-booking

Thank you for using the plugin!

Hello @javahat

The choices’ values are Slice Delivery, BambooHR Sync, and AR Invoices not slice or sync

Javascript, the language used by browser is case-sensitive.

Also, the and operator is the double ampersand && not &

Note that the use of return instruction makes the comparison for an interval unnecessary.

I don’t understand your equation because sometimes you check the fieldname3 values and others the fieldname1. Furthermore, the choices’ values in the fieldname3 are texts, not numbers. There is no sense comparing fieldname3 with 1.

If you want to return 0 if no Slice Delivery choice is selected or make the calculations, the equation would be:

(function(){
  if(AND(fieldname3, fieldname1)) {
   if(IN('Slice Delivery', fieldname3|r)) {
      if(fieldname1<100) return PREC(fieldname1*0.65,2);
      if(fieldname1 <250 ) return PREC(fieldname1*0.55,2);
      if(fieldname1 <500 ) return PREC(fieldname1*0.40,2);
      if(fieldname1 <750 ) return PREC(fieldname1*0.35,2);
      if(fieldname1 <1000 ) return PREC(fieldname1*0.22,2);
      if(fieldname1 <2000) return PREC(fieldname1*0.15,2);
      if(fieldname1 <3500) return PREC(fieldname1*0.08,2);
      if(fieldname1 <5000) return PREC(fieldname1*0.05,2);
      if(fieldname1 <6500) return PREC(fieldname1*0.04,2);
      return PREC(fieldname1*0.03,2);
   }
  }
  return PREC(0,2);
})();

Best regards.

Hello @javahat

Assuming you have a checkbox field fieldname1 with three choices, choice A with value 1, choice B with value 2, and choice C with value 3. By default, the plugin treats the field’s value as the sum of ticket choices. So, if the user ticks the checkbox choices A and B, the field value would be 3. However, you can use the field’s name in the equation with the |r modifier to access its raw field’s value. In this case, the plugin will manage it as an array with the values of the ticked choices. In the same case where the user selected the choices A and B, using fieldname1|r in the equation, the value would be the array [1,2], and you can use it with the “IN” operation.

Hypothetically, if you want sum 10 to the feldname1 if choice A is in the list of ticked choices, sum 15 if choice B is in the list of ticked choices, and sum 20 if choice C is in the list, you can implement the equation as follows:

(function(){
let result = fieldname1;
if(IN(1, fieldname1|r)) result = result+10;
if(IN(2, fieldname1|r)) result = result+15;
if(IN(3, fieldname1|r)) result = result+20;

return result;
})()

Or if you simply want to add 10 per each ticked choice, the equation can be implemented as follows:

fieldname1+10*fieldname1|r.length;

Best regards.