Dereference in combination with [_THISROW]

[Cubaine]

I have found myself in many situations in which I have wished that the following was possible:
[_THISROW].[Reference column].[Column from referenced table]

Without the above, I have to create a separate column for the dereference first before being able to use it in a selection formula like this: [_THISROW].[Created Dereference Column].

[MultiTech]

You aren’t alone in this, but like in all things AppSheet - there’s another way!!! (^_^)

You can do things like this:

LOOKUP([_thisrow].[Reference Column], Reference Table, TableID, Column_You_Want)

Also: depending on where you’re using this formula, you might be able to eliminate the [_thisrow] part and use a dereference formula.

Guillermo_Perez:

[Reference column].[Column from referenced table]

[Cubaine]

Awesome thanks @MultiTech_Visions this works great!

[MultiTech]

You’re welcome! (^_^)