AnsweredAssumed Answered

Issue with database that broke apart field names by catagory and now need to combine

Question asked by kondor on Dec 11, 2017
Latest reply on Dec 14, 2017 by kondor

I inherited a database that instead of creating a field called category, they created field names that had the category associated to the field name. So instead of Part_Number they created A_Part_Number and B_Part_Number, A_Qty and B_Qty and so on.

 

Using export and import I was able to get everything static to specific field names, Part_Number, Description, etc.. My problem is that QTY changes daily and I need that field to be updated as the original A_QTY, B_QTY, and so on gets changed.

 

I would be happy with a script, but I was hoping to have QTY be a calculation or triggered in a way where it was updated.

 

Thoughts?

Outcomes