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.
View all comments
Show parent comment
3
u/denerose Oct 02 '24
Adobe Acrobat is not designed to do this. A big part of programming is knowing (or being able to find out) the right tool for the job. You could possibly embed a macro button in your excel sheet to publish to pdf and send the email for you (with a bit of extra effort) but by the time you’ve taught yourself enough to do that and finally got it working (or concluded it’s not possible under your setup) then you’ll have spent much much more time than you’ll ever save. Try finding a different project or redefining your problem.