• Resolved 120filter

    (@120filter)


    Struggling with this.
    I have a calculated field [fieldname4 x fieldname5]
    I then have a list of dependencies that show fieldnames [single line text] depending on the result.

    eg:
    calculated result is 66
    66 is greater than 3 = fieldname 19
    66 is less than 187 = fieldname 19

    ok
    next eg
    result is 193
    193 is greater than 187 = fieldname 20
    193 is less than 375 = fieldname 20

    ok

    but it also shows fieldname 19
    i think, because it’s greater than 3
    but the is less than 187 should stop fieldname 19 appearing???

    onwards and up wards so the greater the number the smaller results also appear along with the correct one

    what am i doing wrong?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @120filter

    The solution would be:

    – Click on the “Edit rule manually” link in the dependencies section of he calculated field for entering more complex conditions, in your case:

    
    3<value && value<187
    

    and then, select the fieldname19 field through the attribute: “If rule is valid show”

    The same for the other dependency rules.

    Best regards.

    Thread Starter 120filter

    (@120filter)

    excellent
    it works
    i’ve been struggling for ages on that
    thanks

    Plugin Author codepeople

    (@codepeople)

    Hello @120filter

    It has been a pleasure.

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘dependencies’ is closed to new replies.