Looking up Field is not populating data from a linked table
I will attach two pictures so you can see where is my mistake
My idea is to have every project data in a Record at Table1 (Clients), and share Table2 (My works) to an employee. Where he will read Clients info population like Adress, Name and he will able to set “State” that can be “In Progress” or “Finished” so in my “Client” table i will read whats is going on with that project.
I think my description is confusing because I find the database structure in the given screenshots confusing. I specified that you link records, not tables, because you have to tell AirTable which record(s) are relevant from a particular table. A Lookup field will display nothing until your Link to Another Record field is populated.
In @LondonBalling’s [My Works] table, the primary field is {Servicio}. There is also a {Link to Clients} field, which will echo the {Servicio} field from the [Clients] table. This means that London would have two different fields reporting what service is preformed. The base is not actually using Lookups and Links where it probably should.
I remade the base here to show how it most likely should be set up, assuming I’ve properly understood what London was trying to build.
Airtable: Organize anything you can imagine
Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.
Within the attached image, I have the Event Overview table, and it is only supposed to pull information from other tables (Event Basic Info, Venue Info etc.) to display it. It has no function besides displaying aggregated information. There are other links between the other tables as well. I think I’m getting most confused by the linking to the first column design within airtable and don’t know how to accomplish the things just stated within that structure. Does that help describe my problem, @Kamille_Parks ?
If you want to pull info from other tables, then you’re using the wrong type of field. Link fields don’t pull information from other tables. They let you create links to specific records from other tables. It’s a manual process of choosing which records to link.
You’re not linking to the first column. You’re linking to the entire record. Because Airtable needs to show you something so you know which record is linked, it uses the contents of the primary field (the first column) as that link label, which may be why you think that the link is pointing to the primary field.
Once you have some linked records, then you can pull in data from other fields in those records using a Lookup field type. Here’s an example. I’ve got a [Clients] table that looks like this:
I then make a [Jobs] table, and want to link to a specific client for each job, so I make a {Client} field that’s a link to records in the [Clients] table:
In this field, I’ll choose the record for John Smith for my first job:
Again, this is a link to John’s record, not just a single field. Because it’s a link to a record, I can use a Lookup field to pull in any field from that linked record. If I want to see John’s email address, I’ll set up a Lookup field like this:
What this does is look at the record linked in the {Client} field, then pull the data from that linked record’s {Email} field into this one:
If John’s email ever changes, I modify it in his record in the [Clients] table, and that change is automatically reflected anywhere that {Email} field’s data is pulled, like my lookup:
Does that help to clarify the process?
