philjay86

Hi,

The JS did actually work strangely i just left it then noticed it worked on a particular cell (Calculation 1). Great thanks!

So with it working it has thrown up a new problem. It won’t adjust the formulas relating to the other cells.

So (calculation 1) has number of cell that then lead to its answer. After the (Calculation 1) cell is part of a calculation of other cells Budget and Manufacturing (h) hours look at the pics.

https://we.tl/t-WkS2bbF5Mm

Pic ‘1’ arrive on page you can see cell is a different colour.
Pic ‘2’ Type in cell or use arrows
Pic ‘3’ it doesn’t adjust ‘Manufacturing (h)’ or ‘Budget’ cells it just bounce back to original calculation.

Is it possible to make it stick and live update?

Do you think the new code will act differently?

Sorry about this i know its a tricky one!

Kind regards

Phil

Hi Jonathan,

Is it possible to change this with CSS rather JS?

I look forward to your answers.

Kind regards

Phil

Hi Jonathan,

It does work perfectly. But as default it seems the opacity is set to something as the colour is lighter than it should be, is it possible to set it to what i would like?

So whats the CSS to change the opacity? For both text and cell.

Kind regards

Phil

I like it works perfectly.

How do i change the cell colour?

Kind regards

Phil

Hi

I have had a go with the JS Code can’t seem to get it to work. It doesn’t seem to change anything I have several fields on my actual form that all are calculations. So instead of “#calculation-1-field” do i need to point it all of them? Also do i need to point it at an actual form name in this code?

https://we.tl/t-hWSFysm7Jg Download

Try this simplified form. i noticed the other one was actually working.

So as above

“Budget type 10000
>
Holy rate type 20
>
Then you get the answer in the hours Calculation cell.

Is it possible to make that adjustable? or client can just type what they want in there? So the calculation is just a place holder.

Or get the answer of the calculation cell to be a placeholder in the number cell below? then the client could type in want they want?”

Kind regards

Phil

Hi Jonathan,

Thanks for the reply.

I will try this out and see if I have any questions.

Kind regards

Phil

Hi Jonathan,

I will have a play and get to you see if it does what I’m expecting. Thanks for the quick reply.

If you could leave it open for now. incase i got a couple more queries on it.

Cheers

Phil

Hi Patrick,

Ultimately the form i have made is relatively simple but the the calculations i have worked out have taken me ages and don’t want some one to just come along and grab it all. I’m not saying someone would but you understand what i mean right?

I understand it would have to be on the fronted to make it all work.

Do you have an idea on how you could hide this information?

If not i might just lookout copyrighting it some how.

Kind regards

Phil

Hi Patrick,

So i have made a similar version wetransfer file.

https://we.tl/t-oq7cjRCLYe

Basically

Budget type 10000
>
Holy rate type 20
>
Then you get the answer in the hours Calculation cell.

Is it possible to make that adjustable? or client can just type what they want in there? So the calculation is just a place holder.

Or get the answer of the calculation cell to be a placeholder in the number cell below? then the client could type in want they want?

Kind regards

Phil