how do i set conditional logic to only accept certain values in a currency field?

  • Profile Image
    treclincolnshire
    Asked on March 19, 2016 at 05:40 AM

    I have a matrix widget with currency fields that I have successfully got it to add up values.  I would like to restrict the values that can be put in the boxes but can't work out the right conditional logic settings to stop me entering any value.

  • Profile Image
    Mike_G
    Answered on March 19, 2016 at 06:16 AM

    When you say restrict the values, are you referring to the number of digits or the amount that can be placed in each box?

    I would like to apologize, unfortunately, we cannot set a total number of digits or amount restrictions to each textbox in the matrix table.

    The only way, I believe, you can set restriction for "greater than" or "less than" a certain value through condition is if you use the Number field from the Quick Tools.

  • Profile Image
    treclincolnshire
    Answered on March 19, 2016 at 06:25 AM

    Thanks for your quick reply Mike.  It is the amount I would like to validate as even though I have a hover box explaining the fees (£12, £14 or £16) we are still getting entries with £1.  I will give the number field a go :) 

  • Profile Image
    Carina
    Answered on March 19, 2016 at 06:34 AM

    I cloned your form and changed the input type to dropdown field. Like this they can only select 12/14/16 or 8/10/12. Calculation still works normally.

    You can clone the demo form:

    https://form.jotform.com/60782811976971 

    Let us know if we can assist you further.   

  • Profile Image
    treclincolnshire
    Answered on March 19, 2016 at 06:56 AM

    Fantastic!  Thank you very much Carina :)