Self Referring tables dont make a related rows?

[Austin]

I have a table that references itself and isn’t generating a related rows column, is this normal?

[Steve]

Austin_Lambeth:

is this normal?

Yep. I don’t recall why this is, but there is a reason.

[Austin]

probably to force prevent someone from accidentally making an infinite loop. Makes since but slightly bothered. Could probably just bring a copy of the table and reference table 1 from table 2 and table 2 from table 1 to get the effect I want. Or just make the actual formulas instead of being lazy and wanting related rows.

[Austin]

Can I still de-reference it though? Even if it doesn’t make a related rows? @Steve

[Steve]

Yep!

[Austin]

Well that’s at least 58% of the reason I want it! Sweet!

[Marc_Dillon]

You know you can make your own “Related…” VC, right?

help.appsheet.com

REF_ROWS()

Gather related rows from table or slice

[Austin]

i did not

[Marc_Dillon]

[Markus_Malessa]

I have a setup similar to yours and had to create my own virtual column with REF_ROWS formula pointing to the same table. Although it would have been nice had Appsheet created this itself like it does with other REF type columns, but it did not take much effort at all.