Calculation script |
Post Reply | Page <12 |
Author | |
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6195 |
Post Options
Thanks(0)
|
If you plan to use different factors depending on the drop list selection, there are other changes to do
|
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6195 |
Post Options
Thanks(0)
|
Just in case my assumption is good Change the value of each selection in the drop list Click to select => 0 Bonding Plaster Primer => 3.6 etc Then use the following code:
Edited by Hobby001 - Nov 26 2020 at 9:04am |
|
sevens
Newbie Joined: Nov 25 2020 Location: Namibia Status: Offline Points: 8 |
Post Options
Thanks(0)
|
Invaluable assistance, thank you very much. I would have been totally lost in the dark.
Off the calculation script topic, I cannot seem to get the dropdown list element to have the same height as the text input fields height, it thus looks a bit odd on the page. The next headache would be to be able to save the selected & entered values by date and time to a database that can be navigated, and as it is navigated, re calculated...
|
|
Riaan S
|
|
sevens
Newbie Joined: Nov 25 2020 Location: Namibia Status: Offline Points: 8 |
Post Options
Thanks(0)
|
Yes, your assumption is spot on, the "paint spreadrate" differ by paint type and substrate, and needs to be calculated differently for each type, as it is selected.
Too make it fancier, the calculated total could be split into quantities of 20L, 5L & 1L buckets. For example if the total is 126L, paint buckets would be 6 x 20L + 1 x 5L + 1 x 1L.
|
|
Riaan S
|
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6195 |
Post Options
Thanks(0)
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6195 |
Post Options
Thanks(0)
|
On the database side you need good knowledge of php and sql
Do you have the required skills?
|
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6195 |
Post Options
Thanks(0)
|
You can also save the data to a text file that you can download and rework using excel or access
|
|
sevens
Newbie Joined: Nov 25 2020 Location: Namibia Status: Offline Points: 8 |
Post Options
Thanks(0)
|
I have done a few sql queries many years ago, using delphi with a firebird database. Mostly just linking invisible & visible components in delphi to the db & writing a few queries to extrct view and sort data.
|
|
Riaan S
|
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6195 |
Post Options
Thanks(0)
|
If you want do do it on your WEB site You need to know
Otherwise you will need to contract it out. As an alternate solution, using php, you can save your data on a text file on your host and download it when required to rework it with whatever tool you know.
Edited by Hobby001 - Nov 26 2020 at 11:37am |
|
Post Reply | Page <12 |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |