Calculation script |
Post Reply ![]() |
Page 12> |
Author | |
Hobby001 ![]() Admin Group ![]() ![]() Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 5975 |
![]() ![]() ![]() ![]() ![]() Posted: Nov 26 2020 at 10:37am |
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 |
|
![]() |
|
sevens ![]() Newbie ![]() ![]() Joined: Nov 25 2020 Location: Namibia Status: Offline Points: 8 |
![]() ![]() ![]() ![]() ![]() |
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: 5975 |
![]() ![]() ![]() ![]() ![]() |
You can also save the data to a text file that you can download and rework using excel or access
|
|
![]() |
|
Hobby001 ![]() Admin Group ![]() ![]() Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 5975 |
![]() ![]() ![]() ![]() ![]() |
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: 5975 |
![]() ![]() ![]() ![]() ![]() |
![]() |
|
sevens ![]() Newbie ![]() ![]() Joined: Nov 25 2020 Location: Namibia Status: Offline Points: 8 |
![]() ![]() ![]() ![]() ![]() |
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
|
|
![]() |
|
sevens ![]() Newbie ![]() ![]() Joined: Nov 25 2020 Location: Namibia Status: Offline Points: 8 |
![]() ![]() ![]() ![]() ![]() |
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
|
|
![]() |
|
Hobby001 ![]() Admin Group ![]() ![]() Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 5975 |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
Hobby001 ![]() Admin Group ![]() ![]() Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 5975 |
![]() ![]() ![]() ![]() ![]() |
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: 5975 |
![]() ![]() ![]() ![]() ![]() |
First add a custom class named Chosen_Fields to your two size input fields
You may also check the read-only check box for your WEedit_primer_qty_calc field Edited by Hobby001 - Nov 26 2020 at 8:06am |
|
![]() |
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 |