Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Sep 13, 2021 02:20 PM
Hi! I’m making a database for me to keep track of my train delays and the compensations I need to request, have requested and are approved or declined.
I like to have an overview of the route I took. For this, I have two fields:
Both have these two options in a single select
:
Basically I want to only select the departure train station, and the formula should put the other option in the arrival train station. For example if I select “Noorderkempen”, the arrival train station should be set to “Antwerpen centraal”.
How would I achieve that? Thanks in advance!
Sep 13, 2021 03:16 PM
The {Arrival Station}
field could be a formula field with this formula:
SWITCH(
{Departure train station},
"Antwerpen-Centraal", "Noorderkempen",
"Noorderkempen", "Antwerpen-Centraal"
)