Concatenate() with lookup()

AppSheet AppSheet Q&A
1

2 / 2
I have two fields of type Ref. They return indexed values. If I need to retrieve another value from another column in the table, I use the Lookup() function. If I do this individually for each of the fields, everything works fine. The problem occurs when I use the Concatenate() function and put the two Lookups inside it, one for each field. It does not return the other values from the other columns in the tables. It returns the value that is stored in the table, which is the key value (index).

LOOKUP([PROPERTY], “PROPERTY”, “PROPERTY_ID”, “OWNER”) returns “João” LOOKUP([PROPERTY], “PROPERTY”, “PROPERTY_ID”, “TENANT”) returns “Paulo”

CONCATENATE(LOOKUP([PROPERTY], “PROPERTY”, “PROPERTY_ID”, “OWNER”), " - ", LOOKUP([PROPERTY], “PROPERTY”, “PROPERTY_ID”, “TENANT”)) returns

X1 - Y2

it should return

JoĂŁo - Paulo

2

If there’s a first part of your post, that’s not available here for reference. Consider using a single post or at least providing a link between the posts.

If your post is a question seeking an answer, it should be posted in the AppSheet Q&A board, where it’s more likely to be seen by someone who can provide an answer and won’t confuse anyone reviewing this Tips & Tricks board for the type of content it’s intended for.

1 Like