Airtable connections: Link, Lookup, Rollup

Here is how you can connect data into Airtable, 3 ways:
- using Links, similar with what Data Validation in Excel looks like
- using Lookups, like VLOOKUP in Excel works
- using Roundups, work pretty much like SUMIF, COUNTIFS in Excel

[gaby.salazar]

Concise, clear, & with examples... Applause! Thank you so much from Mexico City, Radu!

[vokinburt]

Awesome explanation. This is a fantastic reference.

[davnunn]

Thanks for this video. Is there a way to link tables, but only see a subset of relevant records when choosing the linked item? Example a content planner for different platforms - create a new story for a platform (say magazine) then add date from a linked table - but only show publication dates for the magazine, not all platforms?

[XAE_A_Xii]

i am struggling to understand if you could advise. I ahve two tables - A - Profit by customers, and B-pricelists by customers. Both tables are synced from the other database - products base. The reason i separate by bases is to make sure i don't make some changes in the price list for one customer and inadvertently update all other pricelists. And the reason i don't put prices by customers and profit tables is to prevent sending costs to our clients by error. In table A (Profit by customers)), i want to pull prices from table B, but table A is already popluated with the product items, which are the same in all three tables. I don't want to create another linked column and select the same items that are already in the table (my list is very long). How can I lookup based on what i already have? In excel, it's very simple, just use vlookup. IN airtable, i broke my brain

[Rejken]

Hi,
Do you happen to know how to create a search engine which will allow me to search between 3 tables [free version of airtable here]?
I have 3 tables: Amazon, Ebay, and Website. Each table contains customer information such as First Name, Last Name, Phone Number, Email, etc. I would like to implement a search engine in the fourth table, allowing easy customer search based on criteria like first name or phone number, eliminating the need to manually navigate through each table to find a specific customer.