Understood - thanks for the explanation, Nigel!
I think I got a grasp of the logic behind fields that are treated as lists of values - I haven’t tested these linked fields with more than 1 linked value so it was curious to see that formulas are applied to each of the values in the field. Perhaps the logic can be updated to treat these as sort of a single piece of data?..
Let me show you an example (closer to what I’m achieving for my planned database), and how this example works differently in Baserow and Airtable.
Let’s say I have a table with a list of countries, and another table which lists agreements and their territories. For these territories I have two fields - one for available territories, and another for excluded territories. One additional formula field concatenates the values from the previous two territory fields to present a description of all available territories concat(field('Territory'), ' ex. ', field('Excluded Territory')) .
