Skip to main content

Connecting fields


Hi, is there a way to connect several fields. I have several fields: dress name, dress style number, dress retail price, and dress wholesale price. Is there a way that when I enter the name of the dress in that field, the base can fill in the other fields with the accompanying information?

3 replies

Kamille_Parks11
Forum|alt.badge.img+25

If whatever table you’re doing this in is linked to a table with all your information Dresses, the {Dress Name} field could be a Link to Another Record-type field, and {Dress Style}, {Dress Retail Price}, and {Dress Wholesale Price} could all be Lookup-type fields.

That means you only have to define that the style and prices for a dress are once, in the [Dresses] table, and every time a dress is mentioned inn another table it will automatically pull in the other information.


  • Author
  • New Participant
  • 1 reply
  • April 17, 2021
Kamille_Parks11 wrote:

If whatever table you’re doing this in is linked to a table with all your information Dresses, the {Dress Name} field could be a Link to Another Record-type field, and {Dress Style}, {Dress Retail Price}, and {Dress Wholesale Price} could all be Lookup-type fields.

That means you only have to define that the style and prices for a dress are once, in the [Dresses] table, and every time a dress is mentioned inn another table it will automatically pull in the other information.


Thanks Kamille,
I’m new to airtable and very excited to use it. I understand the concept you describe, but is there a manual which would have directions to implement it?


Databaser
Forum|alt.badge.img+19
  • Inspiring
  • 866 replies
  • April 17, 2021
Robert_Danes wrote:

Thanks Kamille,
I’m new to airtable and very excited to use it. I understand the concept you describe, but is there a manual which would have directions to implement it?


You could start here.


Reply