Updating the Timezone for profile by lookup another table

Avatar

Avatar

samaamcer

Avatar

samaamcer

samaamcer

30-12-2019

 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 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

17-01-2020

Hey,

 

write a workflow which will update the timezone based on your table on an hourly basis.

 

Regards,

Amit

Answers (0)