Beginner :-) - Get address location result from Table 1 in Table 2

AppSheet AppSheet Q&A
1

Hello everyone,

I’ve tried several tests without satisfying results and, as I’m a beginner on AppSheet, I’d like to know if someone can help me :slightly_smiling_face:

I have a Table for Companies, with a specific column with the address (Location format). I have another Table for Contacts with a drop-down list to choose the Contact’s company.

What I would like is to get is the automatic implementation of the Company address on the Contact row, column Contact Address.

One last thing, where do I have to put the code, in a bot? Or somewhere else? I’ve tried to use LOOKUP function but it got me a count instead of the full address.

Many thanks for your help!

2

If the Contacts table contains the Company column and it’s a Ref column, you can read the address with the formula as [Company].[Address]. Add a virtual column in Contacts table and use that formula in the “Formula” field.

2 Likes