Time Zones ?

The Date Picker automatically added the date for me.
Can i have access to the CSV to test further ??

I manually changed the date to 05/01/2022 and it added the correct amount of eggs to Trailer B.
The Total cumulative total though is incorrect.

Here's the csv
Looks like you selected June 6 2022 and Jan 6 2022.
I used the date that loaded which for me was Jan 5 2022.
I see your in Australia. My script had a time zone setting. I removed it but I will have to test in a few what time and date it is at my host. That's the issue with date time scripts. You need to know if the host will affect your date because it's actually located in a different time zone.
I'm currently seeing 120 eggs for Trailer B and in the Cumulative Total.
What date format do you like to use?
The one you have now?
What date loads when you go to the form?

Hi Eric,
I have attached a screen shot for you.
The date i get when i load your form 6/1/2022.
There is the HTML Script you gave me a few days back creating the date for the date picker.

The Trailer B value is correct (120) but the Cumulative Total should be 1166.
Trailer A + B + C + D = 1166

After looking at the CSV file,
I can see that vthe values for Trailer A,C & D that are displayed on the form are not actually in the CSV file and the Trailer B value of 120 eggs is correct.
I assume we need to remove the Values in A,C & D ??

I just added 220 eggs for trailer A and it worked fine, i got confused with the greyed out values.
The darker values for A & B are correctly calculating.

You are scripting superman mate lol

I removed those placeholder values from the form. Probably not needed since nobody can actually enter any values in them.
Lets discuss the Datepicker. Do you need to be able to select the date?

The DatePicker has been a pain from day one to be truthful.
Time Zone and Format issues etc

That being said 99% of the time the users will use the current date.
So the Date Picker is probably not necessary, it could be just a field that propagates with the current date.

Who is your host?
If you now look at the top right of my form you will see where my form is hosted the server is in the time zone America/Boise
https://ericrohloff.com/coffeecup/ccfor … tsy/004WZ/


If you look at this second form is says America/Detroit.
https://ericrohloff.com/coffeecup/ccfor … 04WZ-2.php
I added a script to allow changing it.

I use Sites N Stores in Australia, not sure who is actually hosting the site though.
Will attempt to find out.

FYI Most of my clients are in Australia and i have a few in New Zealand.
So what your saying is the Time Zone is an issue ?
So if the Date Picker places a forward date compared to the TZ where the CSV file is hosted then it will cause an issue displaying the correct running totals ??
I assumed the Time Zone that was set in WFB will be added to the CSV file giving the user the correct date and time for their locale.
What would be a good work around if any.