I need to

I have an Use Case where :

1. There is one checkbox in Account Module which should get enable or visible only when :

a. Account Inofrmation is saved successfully without any error and this account should have atleat one Address and atleast one case linked to it.

........................................................................................................................................................................................

What I have done so far :

1.Created a checkbox in Account module through studio.

2.Added In Record View.

Please suggest some solution.

Parents

0 Jeff Bickart over 4 years ago
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

Fullscreen
1
greaterThan(count("cases"), 0)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
greaterThan(count("cases"), 0)
0 Gautam Sharma over 4 years ago in reply to Jeff Bickart

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?
0 Jeff Bickart over 4 years ago in reply to Gautam Sharma
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.

Fullscreen
1
and(greaterThan(count("cases"),0), greaterThan(count("RELATIONSHIP NAME GOES HERE"),0))
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
and(greaterThan(count("cases"),0), greaterThan(count("RELATIONSHIP NAME GOES HERE"),0))
0 Gautam Sharma over 4 years ago in reply to Jeff Bickart

Hi Jeff Bickart

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

Reply

0 Gautam Sharma over 4 years ago in reply to Jeff Bickart

Hi Jeff Bickart

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

Children

0 Jeff Bickart over 4 years ago in reply to Gautam Sharma

The name of the relationship is not what appears on that screen. You have to look at the custom code that is generated.
0 Jeff Bickart over 4 years ago in reply to Jeff Bickart

Or you can use your browser developer tools to find the name on the subpanel in the code
0 Gautam Sharma over 4 years ago in reply to Jeff Bickart

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>>
0 Gautam Sharma over 4 years ago in reply to Gautam Sharma

Hi , any help on above query ?
0 Hector Rios over 4 years ago in reply to Gautam Sharma

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