Updating the Timezone for profile by lookup another table

Avatar

Avatar
Ignite 1
Level 1
samaamcer
Level 1

Like

1 like

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Boost 1
View profile

Avatar
Ignite 1
Level 1
samaamcer
Level 1

Like

1 like

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Boost 1
View profile
samaamcer
Level 1

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
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
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)