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 ๐
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!
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.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |