I need to create a simple table which allows multiple people to enter their availability each day (everyday may be different). Everyone is located in a different timezone though and I want there to be a field which will display it in our native time gmt+7.
Some ideas i had were
Creating the time field, then another field which has their timezone + our timezone calculation, then parsing it into a new date/time field.
Any help would be appreciated thank you