I have the need for a calculated field and a way (place) to hook it so that it is calculated and stored when a news custom type record is created. I've been going through the documentation, but I'm not completely certain what would be the best way to do it within the system.
Specifically: I'm creating a database of several hundred locations - I need a (geocode) latitude and longitude for each. Requesting them each time I use them isn't reasonable, so I'd like to call a lookup of the geocode from an address in the record and store it. Ideally this would happen as the input form gets validated.
Any suggestions would be welcome.