Thread Details
  • State Not Answered
  • Replies 10 replies
  • Subscribers 365 subscribers
  • Views 2188 views
  • Users 0 members are here
Forum Actions

I need to

Gautam Sharma

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.

 

  • 0

    Hello,

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

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

  • 0

    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

  • 0 in reply to Jeff Bickart

    Hi 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 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

  • 0 in reply to Jeff Bickart

    Hi

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

  • 0 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 in reply to Jeff Bickart

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

  • 0 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 in reply to Gautam Sharma

    Hi , any help on above  query  ?

  • 0 Sugar Employee Badge 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