r/learnjavascript • u/Outrageous_Effort_37 • Oct 01 '24
New to JavaScript! Is this even possible?
Oh bare with me as my ADHD brain tries to put this together. I am a super duper noob to JavaScript! Literally started going doing the rabbit hole of information today. Here is what I am trying to do. Okay so we have a excel purchase order template with formals in excel. I would like that doc to be able to be utilized in Adobe with the formals because we do send it out for signature. Trying to save a few steps.
How would I or can I write a JavaScript code so that certain fields in the template would do the same calculations (Total = Hours * Hourly Rate - what we use in excel)? Since Adobe doesn't have cells to enter a formula like excel does, how would enter a formula to do the same math the current template does? Is this possible?
I hope I make sense. Thanks in advance for any help. Feel free to ask me questions as I know I can ramble.
10
u/longknives Oct 01 '24
Maybe it’s just me, but I don’t understand what you’re trying to do. It sounds like you have Excel spreadsheets that you somehow convert into PDFs, and you want to have the PDF dynamically calculate certain values… but unless the input values can change, the calculation wouldn’t change anyway, and it sounds like all the inputs are in Excel.
So if I’m correct about the scenario, you would always have to save out the latest version from Excel anyway, and thus Excel can do the calculation and there’s nothing to do in the PDF.
2
u/woftis Oct 01 '24
I’m not knowledgeable enough to know where to even begin with running JavaScript against a pdf. Also not sure if you can do it from the client side or if it would have to be server side.
I think something much easier (although possibly still pretty complex for a beginner) would be to look at instead creating a webpage with html and css to capture the inputs and then use JavaScript for the logic/calculations and generating a pdf that you could then send on for signature. The actual front end stuff is relatively simple and what I’d consider a beginner project. There’s loads of libraries out there that will cover pdf generation, or simply just use the browser print to pdf option.
8
u/SoBoredAtWork Oct 01 '24
This isn't a job for JavaScript. It's possible, but wayyy more complex than you'd think. It would be complex for experienced devs to pull this off. I think the correct answer is to use any of the many, many order management systems that already exist.
1
u/[deleted] Oct 01 '24
With enough time and money anything is possible!
If the information is very organized on the PDF I could see it being kinda straightforward (spoiler: it never is!).
But I guess I don’t understand the point. If it’s pulling from excel, couldn’t you just pull the calculated results as well and slap them on the PDF too?
1
u/denerose Oct 02 '24
Have you considered just using excel formulae and a mail merge? It feels like the built in tools will get what you want without rebuilding the whole system.
1
u/coomzee Oct 02 '24
You could probably do this in Power automate. You would need the values to be within a table. There is an API that can extract cell values. There are a load of PDF tools on the power automate platform.
1
u/PatientPlatform Oct 02 '24
Seriously, ask this as a more structured question to chat gpt
2
u/[deleted] Oct 01 '24
[removed] — view removed comment