hello ladies and gents,
i have created a user-form, where User´s can enter times (timepicker)
IN addition I would like to create a new field, which calculates the difference betwenn 2 timpickers and shows it on TEXTfield/user-input-field.
so my thought is:
ENTER TIME in "timepicker1"
ENTER TIME in "timepicker2"
ACTIVATE THE (BY CLICK) the text-field next to it, and get the difference nummeric
(f.e.: 10:00 - 11:30 = 1,5)
So far I managed to connect the database with the inputfields(timepicker) AND save them by clicking the submit-button, which I WANT to do with the new field (the difference) aswell.
If someone could provide some help/code, please consider that I´m ABSOLUTE new to wix ;-)
Also consider that "timepicker2" can be smaller than "timepicker1" due to day-jump.
(f.e: 22:00 - 02:00 = 4,0)
NAME OF my setups:
dataset: "hours dataset" which connects to my "hours" list/database
timepicker1: input sign in time (Value connects with "day1in")
timepicker2: input sign out time (Value connects with "day1out")
total1: Textfield connected with dataset and value connects to "totday1"
thanks for reading so far ;-)