Hello
AaronAbe,
I have done a small reproduction using radio buttons with calendar picker control to choose between times. This here changes to the time zone of your choice every time you submit.
- In your view just below Registration Status. Add the radio but group. Label the 1st radio button Singapore and the 2nd Radio Button Belgium.
- In Layout page, Under the category heading, navigate to your Data Source heading under the properties tab on your left. Click type ellipsis and choose Use a static list of values in the control. Click List items ellipsis and add value and display. In your case you will add Singapore and Belgium separately. Click ok and ok again to return to the layout section.
While still in the Layout page. Select date time control, properties, click format ellipsis and select User settings radio button, next to Language/Regional Settings
Rules
3. Under conditions tab, type “contains” and select “a control contains a specific value”. Click on it. Select the name radio button list control and select value “Singapore”.
3.1. Select the Actions tab, type “properties” and select “Set a control’s properties” and select the Date time calendar control . Click configure, change display time zone to be (UTC+08:00) Beijing, Chongqing, HongKong, Urumqi. Click ok to return to your rules.
3.2. Repeat step 3 and 3.1 for Belgium
3.3. While still in your rules, In the conditions tab, type “advanced” and select “an advanced condition is true”, select the date time calendar control. click configure, in general , select the “no” radio in enabled.
When selecting the time zone you want, it should change with every submission change made. My literature is not up to par, but these are steps to a functionality that is working.
@AaronAbe I have also attached screen shots to the rules to aid with this reproduction on the right of the screen.
I hope you manage.
Hi @AaronAbe ;
In additional to @Dumisani 's refferal, Should there be any alteration of some sort feel free to dive & drill into this external doc perhaps it could be very helpful to change the whole sql time zone(https://www.inmotionhosting.com/support/website/databases/how-to-change-mysql-server-time-zone/) follow the prompts and goodluck.
Kind regards;
Widson.
thanks @KagisoMasha and everyone.
@KagisoMasha I followed slightly your suggestion. I did not need radio buttons as my user did not need to choose different timezones. Sorry if I may not have been clear in the problem statement. They are always at Singapore time zone and I needed to figure out a way to ensure that when the record was written on the database, it was still reflecting the Singapore Time zone and not the server's Belgium time zone. I also could not change the server time zone itself as there are also a different group of users located in Belgium but from a different deparment that were using their own forms.
However, your input did help point me to the right direction. I created a rule to set the property of the control when it loaded. What was weird was when I set that to UTC +8 for Singapore time, it still did not save the time correctly. However, when i set the control's property to UTC +1 to match Belgium's timezone it was now both displaying on the form Singapore's timezone plus it was writing on the database using Singapore's timezone as well. I'm not sure why this is behaving this way but hey it fixed it so I'm good with it.
thanks again.
