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