This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - Consolidate Multiple Fields

jsnosal - Monday, August 20, 2012 5:34 PM:

I’m looking to consolidate the name field, item number and description all into one field. I’m doing this reduce the amount of columns I need in the BOM report. Does anyone have any ideas on how to go about doing this? I’m currently trying to get it work in Java but I’m having trouble getting it to work. Thank you for your help.

 

Part Number + Name + Description = New Field



aponceot - Sunday, August 26, 2012 7:49 AM:

Hi !

When I want to achieve this kind of thing, I create a server side event "OnBeforeUpdate" and consolidate the fields on this method :

for example in VB.net :

Me.setProperty("consolidated_property",Me.getProperty("part_number") & " - " & Me.getProperty("name") & ", " & Me.getProperty("description"))

 



jsnosal - Wednesday, August 29, 2012 11:45 AM:

Thank you so much. What is best way to setup the form inside ARAS? Thanks again for your help.