Skip to main content
Solved

How to autofill a record on linked tables?

V
Forum|alt.badge.img+1

Hi,

In my Airtable, I have a simple Work Order app, connected to Softr.

My tables are: Owners, Units, Work Orders. All 3 tables are linked.

I would like to automate (autofill?)  “Owner’s Name Surname” in Work Orders  table

When a user chooses an Unit (like in WO 6),  Owner’s Name Surname  should be automatically filled (in WO 6 -  “John Doe”).

(I can rearrange  Owners  table, and make   Owner’s email   as primary field, if that will help)

I have tried different Automations, but I couldn’t make it. 

Thank you very much. 

Best answer by Marvel_digitals

Hi Vedran

You can do this using a Lookup field in the Work Orders table.

  1. In Work Orders, create a Lookup field.
  2. Select the Units link.
  3. Choose to pull the Owner’s Name Surname from the Owners table.

This will auto-fill the owner’s name when a unit is selected.

If you need full automation (without lookup fields), let me know, and I’ll guide you!

View original
Did this topic help you find an answer to your question?

2 replies

M
Forum|alt.badge.img+1
  • Marvel_digitals
  • Participating Frequently
  • 9 replies
  • Answer
  • March 20, 2025

Hi Vedran

You can do this using a Lookup field in the Work Orders table.

  1. In Work Orders, create a Lookup field.
  2. Select the Units link.
  3. Choose to pull the Owner’s Name Surname from the Owners table.

This will auto-fill the owner’s name when a unit is selected.

If you need full automation (without lookup fields), let me know, and I’ll guide you!

V
1 person likes this
  • V
    VedranN
V
Forum|alt.badge.img+1
  • VedranN
  • Author
  • New Participant
  • 2 replies
  • March 20, 2025

It works :)

So simple  🤣

thank you very very much

 

Reply


Most helpful members this week

Terms & Conditions