Help me brainstorm?

Glenn Plunkett
Kilo Contributor

‎11-02-2023 12:53 PM

Hi all,

 

I have a requirement to provide a custom component which aids in performing a cost analysis.  One of the components of that analysis is a traditional Bill of Materials (BOM).

 

A BOM is like a recipe of the raw materials and/or subassemblies which are required to make a finished product.  So each entry in the BOM has an item number, a name, and a cost.  The main issue I'm wrestling with is the number of lines on the BOM (the number of items in the "recipe").  This isn't consistent from item to item - it's a many-to-one relationship.  

 

Any thoughts on how to implement this?  Specifically, how do I allow for an unknown number of inputs on my form, each with the above three pieces of data?  I'm thinking a related list of a custom data type is probably the way to go, but this poses some challenges with some of the other requirements of the project.  Am I missing another way of doing it?

0 Helpfuls
  • 368 Views
1 REPLY 1

Dan O Connor
ServiceNow Employee
ServiceNow Employee

‎11-17-2023 05:28 AM - edited ‎11-17-2023 05:28 AM

@Glenn Plunkett I would agree with you that my first thought it also creating another table to store the items, which is related back to a BOM record. 

 

What challenges are presented to you? I'd imagine you will have things like calculations and stuff to store on the BOM record, but you could achieve this still be having the related table. Important part is having a relationship between the records, which then lets you achieve whatever you need in terms of maybe calculations etc. 

 

I would make sure the line items records have a defined structure, and then its just different information going into each record, feeding back up to its parent BOM 

0 Helpfuls