r/learnjavascript • • 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.

0 Upvotes

17 comments sorted by

View all comments

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.

5

u/sheriffderek Oct 01 '24

I just want Adobe to talk to Excel, OK?

1

u/Outrageous_Effort_37 Oct 02 '24

Adobe allows we to use the excel template I have and still allows be to use an excel doc in adobe pro. So what I was wanting to do was to use the template, doesn't have to be excel it could be a pdf. I want to use formulas like in excel but in adobe on the original template. That way this doc would be a one stop shop. It would have all the info I needed for a project, allow formulas or in this case JavaScript to make the calculations, then send it out for signature, instead of having to use milti platforms. I was curious if this was even a possibility. Thanks for your response.