+4Hi there,
Fairly new to Airtable, and I’m wondering if it’s possible to add fields to the view you see when you access the pop-up related to a linked field. It looks like it only show three fields. Does Airtable allow you to add more. See screenshoot.
Thanks,
Sam
Welcome to the Airtable Community, Samuel! I assume that you’re talking about the listing of linked records that you see when you click the + button in a linked records column in a grid view. If I’m right about that, then actually you do have SOME control over the fields that are shown.
Let me approach this in two ways.
First, you control the definition of the primary field in the linked table — the one that says “Mill County Texas Cemeteries (2002)” in the second record in your screenshot. If you need to see more info in this listing in order to pick records efficiently, you might want to consider changing your primary field to a formula field that concatenates the fields you want to see. I do this a lot.
.
The second approach is a little less straightforward and may even be an accident of Airtable’s current deep design that could change in the future.
You know by now that the Primary Field in a table in Airtable — the column that’s fixed to the left of every grid — is very important. Well, the first view in every table is also very important. I don’t mean the view that is first in the list of views for that table. I mean the default view that was created automatically by Airtable. This view is important even if it has been moved — in fact, even if it has been deleted. It seems to determine how the table is viewed from the perspective of other tables (unless the link between tables is itself defined on the basis of a specific view). [Corrected 14 hrs later per response from @Martin_Kopischke below.]
Now, what matters isn’t how the view itself looks to a user. What matters is the order of the fields in the Hidden Fields menu.
The screenshot above shows the hidden fields list for a Notes table that is a child table linked to another table. When I go to add a note from the other table by clicking the + button in the LinkedNotes column in a grid, what I see is a short version of the note (the primary field) + Created + CreatedBy + Status. NOTE that all three of those fields are in fact invisible in the Notes grid! By moving those fields up and down in the Hidden Fields menu, I can modify the fields that appear in the other table. Here’s the result:
Not entirely satisfactory, but a useful tip in some circumstances.
+4Welcome to the Airtable Community, Samuel! I assume that you’re talking about the listing of linked records that you see when you click the + button in a linked records column in a grid view. If I’m right about that, then actually you do have SOME control over the fields that are shown.
Let me approach this in two ways.
First, you control the definition of the primary field in the linked table — the one that says “Mill County Texas Cemeteries (2002)” in the second record in your screenshot. If you need to see more info in this listing in order to pick records efficiently, you might want to consider changing your primary field to a formula field that concatenates the fields you want to see. I do this a lot.
.
The second approach is a little less straightforward and may even be an accident of Airtable’s current deep design that could change in the future.
You know by now that the Primary Field in a table in Airtable — the column that’s fixed to the left of every grid — is very important. Well, the first view in every table is also very important. I don’t mean the view that is first in the list of views for that table. I mean the default view that was created automatically by Airtable. This view is important even if it has been moved — in fact, even if it has been deleted. It seems to determine how the table is viewed from the perspective of other tables (unless the link between tables is itself defined on the basis of a specific view). [Corrected 14 hrs later per response from @Martin_Kopischke below.]
Now, what matters isn’t how the view itself looks to a user. What matters is the order of the fields in the Hidden Fields menu.
The screenshot above shows the hidden fields list for a Notes table that is a child table linked to another table. When I go to add a note from the other table by clicking the + button in the LinkedNotes column in a grid, what I see is a short version of the note (the primary field) + Created + CreatedBy + Status. NOTE that all three of those fields are in fact invisible in the Notes grid! By moving those fields up and down in the Hidden Fields menu, I can modify the fields that appear in the other table. Here’s the result:
Not entirely satisfactory, but a useful tip in some circumstances.
Very pertinent answer, but colour me surprised at the above quote: in my experience, the first view in the view list of a table is exactly what the view field order in cards and record views takes its cues from. I have a “Detail View” view pinned up there for that exact purpose, it is not the original view created with the table, and changing its field order / visibility has the expected result.
+33Very pertinent answer, but colour me surprised at the above quote: in my experience, the first view in the view list of a table is exactly what the view field order in cards and record views takes its cues from. I have a “Detail View” view pinned up there for that exact purpose, it is not the original view created with the table, and changing its field order / visibility has the expected result.
Correct, it is the very fist view based on the ordering of the views in the left margin.
Very pertinent answer, but colour me surprised at the above quote: in my experience, the first view in the view list of a table is exactly what the view field order in cards and record views takes its cues from. I have a “Detail View” view pinned up there for that exact purpose, it is not the original view created with the table, and changing its field order / visibility has the expected result.
Thanks, @Martin_Kopischke, for the correction. I swear I tested this once again last night before posting! But I must have been getting tired and not paying attention. Tested again just now and you’re right, it’s the first view in the views sidebar, regardless of creation order of the views. Will amend my response to the OP.
I try to post helpful responses — but I also try to post clear responses so that my own mistakes will be corrected by others. Thanks again.
William
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
