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

No worries at all! 

The lookup field in Airtable doesn’t work well for filtering in Softr. One quick fix is to convert your Lookup field into a Rollup field using “arrayjion”. This turns it into plain text, which Softr can read better.

If that doesn’t solve everything, I can help set up an automation to make it work perfectly. Let me know!

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

5 replies

M
Forum|alt.badge.img+2
  • Marvel_digitals
  • Participating Frequently
  • 15 replies
  • 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
  • 4 replies
  • March 20, 2025

It works :)

So simple  🤣

thank you very very much

 

V
Forum|alt.badge.img+1
  • VedranN
  • Author
  • New Participant
  • 4 replies
  • March 23, 2025

​@Marvel_digitals 

I am really sorry for bothering you…

I my example, my Airtable base is connected to Softr, and with  Lookup field,

I cannot filter results in Softr app,

so…

I would really need help with an automation.

(I have tried different types of automation, but non of them worked)

thank you...

 

M
Forum|alt.badge.img+2
  • Marvel_digitals
  • Participating Frequently
  • 15 replies
  • Answer
  • March 23, 2025

No worries at all! 

The lookup field in Airtable doesn’t work well for filtering in Softr. One quick fix is to convert your Lookup field into a Rollup field using “arrayjion”. This turns it into plain text, which Softr can read better.

If that doesn’t solve everything, I can help set up an automation to make it work perfectly. Let me know!

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

Thank you very much, it worked  😀

Reply


Most helpful members this week

Terms & Conditions