Title: Calculated Field problem
Last modified: December 15, 2018

---

# Calculated Field problem

 *  Resolved [wpdia](https://wordpress.org/support/users/wpdia/)
 * (@wpdia)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/calculated-field-problem-2/)
 * I created a Calculated Field name is : fieldname56
 * The Set Equation data as below:
 *     ```
       (function(){
       return 'Unit 10854 Balby Carr bank DONCASTER, United Kingdom';
       })()
       ```
   
 * and i created other Calculated Field name is : fieldname57
 * The Set Equation data as below:
 *     ```
       (function(){
       var address=fieldname56;
       jQuery('.display-here').html(
       "<div class='col' data-label='Address:'>"+address+"</div>"
       );
       })()
       ```
   
 * The problem is only show the number “10854” . The English letters disappeared.
   
   What should i do ?

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/calculated-field-problem-2/#post-10991466)
 * Hello [@wpdia](https://wordpress.org/support/users/wpdia/),
 * Please, modifies the equation as follows:
 *     ```
       (function(){
       var address=fieldname56|r;
       jQuery('.display-here').html(
       "<div class='col' data-label='Address:'>"+address+"</div>"
       );
       })()
       ```
   
 * Pay attention to the modifier |r in the piece of code: `var address=fieldname56
   |r;`
 * It means, give me the raw value of the field without pre-process it.
 * Best regards.
 *  Thread Starter [wpdia](https://wordpress.org/support/users/wpdia/)
 * (@wpdia)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/calculated-field-problem-2/#post-10991648)
 * [@codepeople](https://wordpress.org/support/users/codepeople/) Many Thanks . 
   Resolved
 *  [badmax69](https://wordpress.org/support/users/badmax69/)
 * (@badmax69)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/calculated-field-problem-2/#post-11012773)
 * I have the same topic with Checkboxes DS. How can I solve it here that the complete
   name and not only the number is output?
 * For Example:
 * (SELECT ‘<%fieldname51%>’ as text, REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(
   paypal_post, ‘fieldname19’, -1), ‘;’, 2), ‘:’, -1), ‘”‘, ”) as value FROM {wpdb.
   prefix}cp_calculated_fields_form_posts WHERE formid=10 order by id desc limit
   1) UNION (SELECT ‘<%fieldname235%>’ as text, REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(
   SUBSTRING_INDEX(paypal_post, ‘fieldname19’, -1), ‘;’, 2), ‘:’, -1), ‘”‘, ”) as
   value FROM {wpdb.prefix}cp_calculated_fields_form_posts WHERE formid=11 order
   by id desc limit 1)
 * The fieldname235 contains the result of a Calculated field equation and consists
   of text and number.
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/calculated-field-problem-2/#post-11012977)
 * Hello [@badmax69](https://wordpress.org/support/users/badmax69/),
 * In the current version of the plugin the tags with the structure `<%fieldname51%
   >` in the queries associated to the DS fields are replaced by their pre-processed
   values. So, with the current version of the plugin, if you value in the calculated
   fields have the structure: xyz123, I recommend you to edit the query, including
   the text directly in the query:
 * `SELECT xyz<%fieldname51%> as text,`
 * Note: For the next update of the plugin, I’ll implement the possibility to use
   the tags with the structure: `<%fieldname51|r%>` into the queries.
 * Best regards.
    -  This reply was modified 7 years, 5 months ago by [codepeople](https://wordpress.org/support/users/codepeople/).

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Calculated Field problem’ is closed to new replies.

 * ![](https://ps.w.org/calculated-fields-form/assets/icon-256x256.jpg?rev=1734377)
 * [Calculated Fields Form](https://wordpress.org/plugins/calculated-fields-form/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/calculated-fields-form/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/calculated-fields-form/)
 * [Active Topics](https://wordpress.org/support/plugin/calculated-fields-form/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/calculated-fields-form/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/calculated-fields-form/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [codepeople](https://wordpress.org/support/users/codepeople/)
 * Last activity: [7 years, 5 months ago](https://wordpress.org/support/topic/calculated-field-problem-2/#post-11012977)
 * Status: resolved