Thread Details
  • State Not Answered
  • Replies 3 replies
  • Subscribers 355 subscribers
  • Views 821 views
  • Users 0 members are here
Forum Actions
Related

How to create a Related Field that automatically takes the value of another field and uses that to query the related Module?

Keaton Gibb

For example, i have this table of data in Module 1:

Module 1

Main Field Related Field
example 1 example 1 (linked to item in related module)
example 2 example 2 (linked to item in related module)

Module 2

Main Field other other 
example 1 ex1 other ex1 other
example 2 ex2 other ex2 other


As you can maybe see, i am trying to describe what the title is saying. I have Data imported into Module 1, and want the Related Field in Module 1 to automatically link to Module 2, using the value of Module 1's Main Field. Is there a way to do this? I tried to import the data directly from Main Field into the Related Field but it was messy and i now have many duplicates.

Parents
  • 0

    Hi

    Some rules which are part of the core and default behavior of SugarCRM application:

    • A module which has a field related to another module has the link in the field <relationship>_name, for example module2_name.
    • The value displayed in the field module2_name is the name field itself in Module 2.

    I'm not sure you want to render in the relate field the value of a field other than the name itself of the Module 2.

    Can you kindly clarify it a little more?

    André Lopes
    Lampada Global
    Skype: andre.lampada
Reply
  • 0

    Hi

    Some rules which are part of the core and default behavior of SugarCRM application:

    • A module which has a field related to another module has the link in the field <relationship>_name, for example module2_name.
    • The value displayed in the field module2_name is the name field itself in Module 2.

    I'm not sure you want to render in the relate field the value of a field other than the name itself of the Module 2.

    Can you kindly clarify it a little more?

    André Lopes
    Lampada Global
    Skype: andre.lampada
Children