How do I limit the result of calculated value from another field so it only displays what I want?

  • bsobot
    Asked on March 21, 2019 at 10:42 AM

    how do I limit the result of calculated value from another field so it only displays what I want? 

    Here is an example of what I am doing.

     

    please see explanation in the video below. Thanks.

    Page URL: https://www.useloom.com/share/cd1f76a9e9a2460187fba0a789808c08
  • jherwin
    Replied on March 21, 2019 at 11:42 AM

    Thanks for the screencast, it clearly showed us what you want to achieve. So to meet your requirements, we need to overwrite the value using contains condition.

    For example, if the color field contains a maroon word, then insert the Maroon word in that field to overwrite the text.
    1553182790contains Screenshot 10

    Guide: How to Insert Text or Calculation into a Field Using Conditional Logic

    Screencast of results for Maroon option:
    1553182922testtest Screenshot 21

  • bsobot
    Replied on March 21, 2019 at 11:53 AM

    I think the problem is that I have define this for every single color that the item is available for sale. that is why I only used the option to just capture what was selected from the radio button. 

  • jherwin
    Replied on March 21, 2019 at 12:01 PM

    Yes, you only need to create a contains condition for all the color options you have.

    Here is my complete demo form: https://form.jotform.com/90794803584973

    Please check and test if that meets your needs. You can also clone it to know how it was done: How to Clone an Existing Form from a URL.

  • bsobot
    Replied on March 21, 2019 at 12:20 PM

    1553185195how to get values from this fi Screenshot 10

    How do you get values from this field into calculated values, when the quantity is not defined. 

    Thanks.


  • Victoria_K
    Replied on March 21, 2019 at 1:34 PM

    Your new question seems to be related to different field type, we will answer it here: https://www.jotform.com/answers/1768062