How do i go about making a specific field change to a specific value depending on whtsa in another field?
What I’m trying to do is, put together a database of property listings.
So if I pick a specific apartment building in a single select field. I want another field to update and show nearest subway station. so I dont have to do add the subway station every single time I add a listing in a specific apartment building.
There will be of course hundreds of apartment buildings. Am I supposed to write a formula that says?
IF xx building, then put this Subway station?
if xx building, then put this station.
Does that mean you have one Single Select field with hundreds of options? Sounds like this may be better suited for a Link Records field. You’d have a table of Buildings with a field for “closest subway”.
Now each time you “select” the building in your Listings table you can use a Lookup to pull in the subway value automatically.
That would be my recommendation. Typically, you use single or multiselect fields if you just need one piece information i.e. the fact that it has a sauna. Link Record fields are used when you have a long list of items and/or you need more than one piece of information about it i.e. the name of the building and the closest subway.