About creating linked conditionals fields

Topic Labels: Formulas
1027 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

How to create a new field from searching the value of two fields from the same table in another linked table. For example I want to get the serial number of a PC knowing its name and location (in the same table) but the information needed is in another extended table linked to the table where I want to put the result.

3 Replies 3
8 - Airtable Astronomer
8 - Airtable Astronomer

Can you give some context for how your Base is set up? I’m not quite following your needs.

Thanks for answering but I think what you wanted to do was meaningless in the context of Airtable.

Tabla incidencias Tabla parquímetros

Knowing the IdPQ and Zona_Actual fields of the Incidencias table, find with these search criteria the Serial in the Parquimetro table to place it in the PQ field of the Incidencias table.

Where are the IdPQ and Zona_Actual fields being looked up from. They are look ups in the in Incidencias table. Is the linked record they are referencing in the Paarquimetro table or another one?