When to use [_thisrow]

A very common question, here’s a short video in an attempt to answer this question. (I’m not satisfied with this video, I will do another at some point)

Short Answer: When you need to pull data from the table where the formula lives

When you’re building a SELECT() formula:
Shared with CloudApp

12 Likes

Excellent work, @MultiTech_Visions! Great explanation of the concept, and cool visual effects.

Now do one for [_THISROW-1,2,3,etc] and make more clones of yourself to explain it!

vlcsnap-2012-09-24-19h37m32s14_99

7 Likes

@MultiTech_Visions,

Thank you. The explanation video of [_THISROW] is very creative.

2 Likes

Never used or fully understood [_Thisrow-1]

is it useful?

2 Likes

Normally I’d be glad to type up my own explanation, but there’s no way I can explain it better than @steve already has:

ALL CREDITS TO @steve FOR THE GRAPHIC
…just copying here for easy reference

image

7 Likes

image

TEXT(SELECT(PRODUCTOS[NOMBRE], (PRODUCTOS[ID]=[_THISROW].(DETALLES[PRODUCTO]))))&", “&
TEXT(DETALLES[CANTIDAD])&”, “&
TEXT(PRODUCTOS[PRECIO])&”, “&
TEXT((PEDIDO[Total]))&”
"

Unable to find function ‘[_THISROW].’

Como puedo corregir este error, necesito ayuda

This makes no sense:

In fact, your whole expression is bad, and I can’t make sense of what you’re trying to do.

2 Likes