Need help learning Sugar structure

[jim.thornton]

I would like to modify the contacts module. I would like the ability to add in multiple addresses, so that I can use it for past, current and alternate. But I would like each contact to just like the different addresses.

If I were coding it in PHP/MySQL myself, I would want to create a table just for addresses and assign a user ID to each address that I add to the table.

How do I do this in Sugar. I basically want to have a field edit spot for number, street, street type, city, state, country, postal code along with an "add address" button.

When you add an address it will add to a list of addresses for that contact.

Please advise.
________
JEYCY.BIGASS

[andopes]

Hi, jim.thornton

It is a very hard task.
You should have to:
create a new module containing the address fields;
modify the view.edit.php for Contacts, to show that button and add a new address information,
create a relationship between Contacts and this new module: Addresses
define a logic hook before save to save all new address for that contact.

It certainly will take a lot of time.
I suggest you to create a couple of fields of Address type and modify the view.edit.php to show them when clicked to same button you just cited.
To add the type and number into Address you have to create these custom fields, one for each address type and extend the Address field definition (include/SugarFields/Fields/Address).
You have to modify its layout and behavior to work with the new fields.

Cheers

[SugarDev.net]

Take your inspiration from the EmailAdresses modules that is in place. It's essentially the same, but for emailadresses instead of adresses.

In fact, I hope that Sugar will implement this feature. More and more clients want to be able to administer old adresses, different locations, etc. all in one account.

[andopes]

Him SugarDev.net

I just submitted a bug feature asking for that.
#21882

Have a nice weekend, Sugar aholic.

[SugarDev.net]

Him SugarDev.net

I just submitted a bug feature asking for that.
#21882

Have a nice weekend, Sugar aholic.

Thnx, let's hope that the Sugar Team responds to the feature request.

Sugar-A-Holic? I like Diabetes type III better .

[jim.thornton]

Hi, jim.thornton

You should have to:
create a new module containing the address fields;

Thanks for the response. So, by creating a module, that is how I create a table in the database?

So, can I just think of modules as tables then?
________
WELLBUTRIN LAWYER

[SugarDev.net]

Almost. Modules consist of fields. Those fields are either:

- Fields in the module's table
- Fields from another module's (related) table
- Calculated, concatenated, constant, or 'made up' fields. You can do put much anything in these fields.

[jim.thornton]

Are there any tutorials that I can see this?

I've been searching and searching but I can't find anything. I would have figured with such a large community that there would be something.

Jim
________
GLASS WEED PIPE

[DragonflyMaster]

Are there any tutorials that I can see this?

I've been searching and searching but I can't find anything. I would have figured with such a large community that there would be something.

Jim

Welcome to SugarCRM....
Sugar it's a great CRM, it just lacks a bit of technical documentation...
Mostly, you can learn Sugar from this forum, from the Developer Wiki, from the "manuals", from the developers page.
Enjoy!

[jim.thornton]

Okay... I've been pretty busy lately, so I had to put it on hold for a bit. But... I have now done the following:

1. I've created a new package called Miscellaneous: I figure I can put any odd-ball modules in here.

2. I've created a new module called addresses (basic type).

3. Ive created a bunch of fields:
- addr_status - dropdown with selections of current/previous
- addr_unit - textfield upto 6 characters (apartment #)
- addr_num - textfield upto 6 characters (house number)
- addr_street_name - textfield upto 50 characters
- addr_street_type - dropdown to select road/street/court/etc.
- addr_street_dir - dropdown to select N/E/S/W/NE/SE/SW/NW

I want to add another field, but I don't know how to. I need to now link/relate it to the client number so that the appropriate addresses only show up for each client. But how?

Also... I changed the layout and fields of the contacts module that is built in. would it be better for me to completely build my own clients module or just continue using the contacts module??
________
WATER BONGS