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.

Link any fileds

224 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello, there is a way to link a field to another table,other than the, master key field?
See attached file

Thanks

Sylvain

2 Replies 2

Hello, you can create a column with type "Linked Record to Table 2" in Table 1. Let's call it "newColumn". Then you can set an automation which pastes the value of Portes Fabriques to newColumn. By this way you build the link with tables. Since the second table's first column is in formula type, the pasting automation does not work if there is no record in Table 2, already with the name of Portes Fabriques. Therefore, newColumn is not empty if there is a record with the same name (of Portes Fabriques) in Table 2. If there is no such record, newColumn is empty. This can be enough, but you can also create another column with the formula: IF(newColumn = "", 0, 1)

Hello, i am sorry but i tried and i can’t find how to paste the value to new column

thanks

sylvain