We want to update the profile timezone for the by lookup another table for example
we have a table with the customer ID and GMT offset as 1234,120 120 means GMT + 2
we don't get timezone from CRM so all timezone is default
Is there a way where we can write a query like if GMT = 120 then update with "GMT + 2 "
or any looup we can create
write a workflow which will update the timezone based on your table on an hourly basis.