Learning Studio and adding custom field to layouts

[clarkdsp]

Hello, I am learning to customize this system to our needs and I would like to add a custom field called Acorn to our Accounts ... view, edit and list version under Advanced Search (which I have never been able to expand open within Studio layout) with a corresponding checkbox.

This field would allow us to easily track those customers which have bought a development system and may become production customers ... hence the title Acorn.

I have played around with this and am getting nowhere. I have a text label field called Acorn in two of the layouts, but cannot tell if they are actually attached to the checkbox or not (which I grabbed from the Sugar Fields list).

Also, since I have attempted to create and then deleted so many versions of this custom field --- which by the way, never lands into my Staging Area after creating a new custom field, I have no idea which one is working and which is not.

Along with that, the labels list has about 5 versions of custom fields that have been created and deleted ... yet the labels still exist.

This Studio setup does not seem to be an intuitive as I would hope ... and it is getting very frustrating.

Can anyone point me to more and/or better documentation without getting me down into the mysql tables ... I'd really like to be able to stay in the backend.

TIA,

L Clark

[clarkdsp]

Not a single response?

Wow ... so now how do I move forward?

[Jimbo]

HI- I run into the same issue with 4.5b PHP 5.1.2.

I noticed when I modify the custom/modules/yourmodulename/language/en_us.lang.php

and make sure things are mapped like they say they are in the "View custom fields" area of studio

things show up again!

Hope that helps!

[ghillis]

There is a table in Sugar 4.5 called fields_meta_data that tracks the structure of the custom fields. In addition to removing them from the custom/modules/yourmodulename/language/en_us.lang.php you need to delete the table entry as well. This can be accomplished by running the Repair Custom Fields tool under Admin->Studio->Edit A Module-><Module Name>->Edit Custom Fields->Repair Custom FIelds (I think). If this does not work you may have to use phpmyadmin to remove the deleted custom field entry.