I need to

Hello,

Would you like to hire a developer to implement the use case with custom coding ? 

In Studio; you can add a Dependency to only show the field when your criteria are met.

The formula would have the following as one of your criteria

greaterThan(count("cases"), 0)

Hi Jeff Bickart It didn't work out.

greaterThan(count("add_address"),0)  [add_address = Address Module]

also tried this as well :

greaterThan(count("cases"),0) [cases = Cases Module]

greaterThan(count("<<module name>>"),0) -> Is my understanding is correct ? Any other way ?

Can we write some kind of  Database Sugar Query in Dependency on studio studio? 

You need to know the relationship name to your "Address Module". Since this is not an OOTB module. It will not be as simple as the OOTB names. 

and(greaterThan(count("cases"),0), greaterThan(count("RELATIONSHIP NAME GOES HERE"),0))

Hi Jeff Bickart

please refer above screenshots for the reference if i am missing something , still  it's not working .

The name of the relationship is not what appears on that screen. You have to look at the custom code that is generated.

Or you can use your browser developer tools to find the name on the subpanel in the code

If I use the Formula in Calculated Value like below , it is working but if I put the same formula in Dependent/Visible filed , it will not work. 

<<In case the name of relationship is not correct, the formula should not work for other calculated field but it is working which means name of relationship is correct>>

Hi , any help on above  query  ?

Hi there

You might want to try and remove the "ifElse" portion of your formula since the  "greaterThan" returns a boolean already.

Hope it helps