Can I use lookup to link records?

[FJL]

Your Setup: SeaTable Cloud

Describe the Problem/Error/Question:

New user here, I have a table of Contacts, which is imported from Mailchimp through an integration, so new rows are regularly added, but the number of options for the column Suburb is fixed. I would like to sort or group contacts by Suburb, but not alphabetically, rather by geography. So I created an additional table with one column for Suburb and a second (numerical) column for Sort. In the Contacts table, I would like to create a Sort column using a lookup formula: i.e. it would lookup the Suburb in Contacts and return the Sort from the table Suburbs. Is this possible? It seems I have to manually link the records in the two tables, shouldn’t I be able to use lookup for that?

[rdb]

You can use SeaTable’s data processing operations to complement the information in your contacts table.

Specifically, in your case, the “auto add link” or the “lookup and copy” actions should do the trick.

The data processing operations are available in all SeaTable Cloud plans.

If you want to automate the linking/copying process, you can use a SeaTable automation. Automations are only available in the Enterprise plan.

[FJL]

Thank you! It is good to discover data processing.