OK, I am not asking for the code, but more like how do I begin to this…
I want to have a data base of part numbers, then I want the user to be able to search the part number and add it to a quote request of that item along with whatever quantities they might want… of course the user would need to be able to do several searches and add several part numbers to the request. along with his information…
I can have the data in Excel, but I am not sure how to begin coding this…
What is your coding background? This sounds pretty straightforward to me.
You can store the part data in a DB if it needs to be dynamic, but for POC, it could just be a json file or a hardcoded array. Then it’s a matter or your UI offering the options - maybe a search bar and asking them how many, etc. It’s a shopping cart which is a pretty common app for beginners. This would involve some DOM manipulation so it might be easier if you learn the FCC libraries cert or something equivalent.
My background is that I started (and still watching) a few Udemy coding courses in Javascript. I was a bit familiar with html and CSS, but not Javascript.
I have coded a couple simple things with Javascript, and this is another project I want to to do later on.
The part numbers I have are in the thousands.
Where do I find information about the FCC libraries?
Yeah, you’re definitely going to need some JS to do this.
There aren’t “FCC libraries” but an FCC course on JS libraries. I’m not saying you need that specifically, but something like that would give you a lot of tools to make this easier to do.
I think to do something like this, a library/framework like React of Angular would make it easier, maybe Vue. jQuery could work too. Of course there is always vanilla DOM manipulation, but that gets messy, imho.
But you’re definitely going to at least learn some JS and then some either a modern view library or some solid vanilla DOM manipulation. You can keep the parts data in a json file to make it easier in the beginning - though for something like this you’d probably want a backend to handle that, and that’s a whole other thing.
What you are thinking of doing is probably beyond your skills at the moment - but maybe not by much. I would keep working on JS and gradually some of this things will just start to make sense.
I have been looking into this for something I want to work hopefully in the near future.
Questions:
When you say store part of the data in a DB if I need it to be dynamic… are you talking of DB as a data base such as MYSQL? If so, would I need to learn some node.js to make it work? … What does POC stand for?
I actually have access to MYSQL because of a website hosting package I have, but not sure if I have to learn something more in order to make it communicate with JavaScript…
The amount of info I would initially be working on is a few thousand lines of part numbers, but later on I want to include more…
Would a Json file be easier to work with? I still need to figure how to transfer the Excell information to make it searchable in JavaScript.
When you are talking about React, you are talking about building the user interface with React, correct?
At this point I can say I have a few fundamentals about coding, but still not so familiar with everything that is possible to do… I have 2 other little projects scratching codes here and there and watching some Udemy video references… the next bigger project would be this one to work with searchable Excel information and make it available in the web… I am very interested in learning everything related to JavaScript… and sure… Python would be next 
you could use Python to go from the excel file to a json file
All the freeCodeCamp curriculum at this point would be really useful to you, including
and this one, it is not yet a certification, but it will be soon. For now the instructions on how to go through it are in the article.
When you say store part of the data in a DB if I need it to be dynamic… are you talking of DB as a data base such as MYSQL?
Yes, that would be an example.
If so, would I need to learn some node.js to make it work?
Yeah, or something like it. You’ll need some kind of server, presumably. There might be some prepackaged solution in something like firebase, but I don’t know.
Would a Json file be easier to work with? I still need to figure how to transfer the Excell information to make it searchable in JavaScript.
It is easier to test thing out with static data rather than loading it dynamically. There are libraries and tools to convert excel to json, or whatever. There is probably a library to load your excel file directly.
When you are talking about React, you are talking about building the user interface with React, correct?
At this point I can say I have a few fundamentals about coding, but still not so familiar with everything that is possible to do
It sounds to me like you have some work to do. I think this project is beyond your abilities at this moment. It would be like trying to design an airplane engine, when you’re only one week into the introductory engineering class.
I suggest that you learn some more first. If you got through the first 6 certificates in the FCC program, then you would know how to do this, or at least what you need to figure out.
I got a few little projects inline before I can move to search part number project… of course I am gonna need to get more information before I move to that one, but I am confident I can get to it… I am looking for something similar to this: JavaScript Search Bar - YouTube or really more like this search bar here… Main Filter, Manufacturer of Industrial Hydraulic Filters - Shop Online Today! … I haven’t started on it yet, but will get there…
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.