Hide calculated field form using dependencies when rule is valid

  • Resolved thecab

    (@thecab)


    4 years, 6 months ago

    Plz, I have two calculated field forms named
    Fieldname4 and Fieldname5

    Fieldname4 is solving this equation – (fieldname1*fieldname2)*(fieldname3/100)
    while fieldname5 was hidden with fieldname4 dependencies.

    Fieldname5 will come up with a static figure when the result of fieldname4 is greater than 1000.

    Now how do i hide fieldname4 when fieldname5 is visible????

    The page I need help with: [log in to see the link]

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

    (@codepeople)

    Hello @thecab

    No, you cannot define the fieldname4 field dependent on the fieldname5, and the fieldname5 field dependent on the fieldname4 because you would be defining an infinite loop. If the fielname4 field is disabled, its value would be zero, and in this case, the dependency rule fails, and the fieldname5 field would be disabled too.

    So, you should use a different alternative.

    Best regards.

    Thread Starter thecab

    (@thecab)

    Ah! pls can you help me with an idea. I am creating a pricing calculator that the result is capped at 1000. So the result must not be greater than 1000 no matter the values entered. ??

    Plugin Author codepeople

    (@codepeople)

    Hello @thecab

    The process is simpler, you only should use the MIN operation in the equation associated to the fieldname4 field (you don’t need the fieldname5)

    The equation would be similar to:

    
MIN(1000, fieldname1*fieldname2*fieldname3/100)

    Best regards.

    Thread Starter thecab

    (@thecab)

    Wow! This solved it. Thanks very much.
    Pls is there documentation that covers most of these problems?

    Plugin Author codepeople

    (@codepeople)

    Hello @thecab

    The documentation of the operations is available in the plugin’s website:

    https://cff.dwbooster.com/documentation#modules

    Furthermore, every time you insert the operations in the equation, the plugin displays some hints directly in the equations’ editor.

    Best regards.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Hide calculated field form using dependencies when rule is valid’ is closed to new replies.