I’m trying to set up a lookup database in Stackby, similar to how it’s done in Excel. I want to pull data from one table into another based on a common field. Can someone guide me on how to create this setup? Any examples or tips would be helpful!
You need to first create a link column type to create relationships across your tables and then lookup any column data from one table to another using the Lookup column.
Stackby is a database, not a spreadsheet. So linking records between two tables is pretty straightforward - where you can create one-one, one-many and many-many relationships across records between two tables. Eg. Product to Clients or Applicants to Job Positions.
Here’s the quick guide on Link & Lookup in your database.
It’s different than VLOOKUP and HLOOKUP in Excel.