Formula to capture as text, all the rows of another table that reference the current row

Ask for Help Formulas
2

Whenever possible, you should avoid looping in Python, in favor of Grist’s lookup functions.

Without any sample document, I’m making the following assumptions: the formula you show is a SubAções column of Planos de Ação; PAsFK is the name of the SubAções table column referring to Plano de Ação. This should do the trick:

"\n".join(SubAcoes.lookupRecords(PAsFK=$id).Descricao)
2 Likes