Get full name of another table

[Rafael_Candido_]

hi, i have a doubt , i getting a user name of another table and after select the user name i need to get automatic a full user name in a select , what the function made this ?

i thinking with a select dp view where slack = full_name, but how works in appsheet?
i need to make a survey public form is possible ?

[Marc_Dillon · Accepted solution]

This post is a bit confusing. I think maybe you’re wanting to do a lookup?

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

Or possible a dereference:

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

[Rafael_Candido_]

Thank you marc!