5 Replies Latest reply on Mar 10, 2016 8:04 AM by Extensitech

    Time in different States

    StanC

      Hi,

       

      Within our company database we have a dropdown list of where the company is based (which US state).

       

      I have already created a dropdown list for the list of States. I also have a box for "current time" for that company.

       

      I want to have it so that when a specific state is selected Filemaker updates "currenttime" box for that particular company by assessing the state and time difference.

       

      I think i would need to some kind of script or calculation so that Filemaker will update the "currenttime box, I'm just unsure the way to go about it

       

      I hope that makes sense