How to create a new field in a bean from module Notes?

I am using a module called notes to keep track of emails so that I can view both emails and notes in the sugar portal.  Right now the portal is only set up to view the notes associated with a case and not emails. Our work around to this is going to be to create a new note whenever there is an existing case and an email is sent.

I need to know if I can create a new field in a notes bean.  I know that I can create variables to use in a bean on the fly but when I did a save I don't see it in the database as a new column.

How do I use a bean to create a new column in the database?

Parents Reply Children
  • So I populate the note bean from the email bean in a before save hook in the email module. I wanted to make some more fields in the bean and also save those to the db to try to mimic the email bean.  The reason for this is that the portal only supports notes and some others but not emails. We need to have the ability to put emails into the portal.

    Our team here wanted to do this because we thought this would be more upgrade safe than making an api call and manipulating the javascript to get the result that we wanted in the sugarCRM portal.

    Thoughts?