Pulling information from one table based on Single...

[Mubarak_Syed]

Hi - I have just started using Airtable and I am wanting to arrange for information entered in one table to mirror in another field in a separate table. Can anyone help with this?

[Mohamed_Swella1]

Hi @Mubarak_Syed,

Welcome to Airtable Community! :grinning_face_with_big_eyes:

You can do that by Linking a record from Table 1 to Table 2, then using the Lookup function.

However, if you give me more context I can help you better.

BR,
Mo

[Mubarak_Syed]

Ok thanks, Basically I have two tables AUDIT and TIDY UP

I am going through doing file audits but some documents are not applicable to every file therefore do not need tidying up. So if I click N/A in the AUDIT table I want that to automatically show as NA in the TIDY UP table? Does that make sense?

Thanks!

[Mohamed_Swella1]

Hi,

So do you have any link between both tables? I did not get that part.

If they are linked, you can create a Lookup field that looks up the N/A field.