Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Simple question about data linking between tables

Solved
Jump to Solution
527 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi !
I’m searching since days the solution on the forum, i just can’t find it, but it might be really easy !

I have two tables, in one of them i have all the informations i need, and in the other i would like to have a general view of my data, and organize it.
For example, i have a column with a single select, and i would like to retrieve in the other table, only the records that have the “Yes” option.

In the second table where i want to retrieve the data, i already created a link to the first table, to count afterwards, but it doesn’t work … Any idea ?

In general, i want to retrieve certain data from a table depending on specific criteria, to another one.

1 Solution

Accepted Solutions

Since you’re using linked records, you can use some combination of rollups, lookups and/or formulas depending on what you’re trying to do.

Here’s the single select example you described:

Table 1
Name (Single Line Text)
Orange
Apple
Banana

Yes No or Maybe? (Single Select)
“Yes”
“No”
“Maybe”

Yes Value (Formula)
“Yes”
“”
“”

Formula: IF( {Single Select} = "Yes", "Yes", "" )

Table 2

Fruits (Linked Records)
Orange, Apple, Banana

Fruits with “Yes” (Rollup)
1

Rollup Settings: Table 1 > Yes Value (formula)
Rollup Formula: COUNTA(values)

See Solution in Thread

2 Replies 2

Since you’re using linked records, you can use some combination of rollups, lookups and/or formulas depending on what you’re trying to do.

Here’s the single select example you described:

Table 1
Name (Single Line Text)
Orange
Apple
Banana

Yes No or Maybe? (Single Select)
“Yes”
“No”
“Maybe”

Yes Value (Formula)
“Yes”
“”
“”

Formula: IF( {Single Select} = "Yes", "Yes", "" )

Table 2

Fruits (Linked Records)
Orange, Apple, Banana

Fruits with “Yes” (Rollup)
1

Rollup Settings: Table 1 > Yes Value (formula)
Rollup Formula: COUNTA(values)

Thanks a lot, it works !