Repeating rows in a module

[robertmarkbram]

Hi All,

I have a module that collects some demographic information about a person, that includes their affiliation with multiple organisations - this latter part looks like I need repeating rows in a module, where each row includes a RELATE field.

Example:
- name
- address
- blah blah
- RELATE-to-organisation-1, role-in-org1, start-date, end-date
- RELATE-to-organisation-2, role-in-org2, start-date, end-date
- RELATE-to-organisation-3, role-in-org3, start-date, end-date

Is there a way to do this?

Thanks for any advice!

Rob

[robertmarkbram]

Sorry, I meant to put this in the Developer Help section...

[kbrill]

This is only a 60 second brainstorming session with not alot of data to go on but what I would do is this

1. Create a new tab-less module that has a relationship to organisations and a start and end date
2. relate that module to your Person module (Contacts, whatever)

Then you can add as many organisation as you want with dates and all in a neat little subpanel.

You will probably have to use SugarLogic or a logic hook to transfer the Organisation name to the 'Name' field as name is required and there is no use typing in the Organisation name twice. Then you can hide the 'Name' field on the Edit and Detail views and only show it on the Subpanels where it will provide a link back to the module.

[robertmarkbram]

Thank you for the feedback Kenneth - I will experiment with this.

Is SugarLogic easy? Is it available to Community edition?

Rob

[kbrill]

To the best of my knowledge sugarlogic is in CE it is just not exposed, I might be wrong on that.

I would go with a simple logic hook though for this. Thats defiantly in CE and is well documented at http://developers.sugarcrm.com

[jmertic]

Sugar Logic is currently not in CE, only PRO and above.