Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
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
Go to Solution.
write a workflow which will update the timezone based on your table on an hourly basis.
View solution in original post