Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Updating the Timezone for profile by lookup another table

Avatar

Avatar
Ignite 1
Level 1
samaamcer
Level 1

Like

1 like

Total Posts

10 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

10 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
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
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)