Recursive relationship

[Former Community Member]

Hi. I am trying to implement a recursive relationship in an employee table. The table have the employee email, name, surname and manager email.
Is it possible to create a relationship between the manager email and employee email columns, as all managers are employees as well. I would like to validate the manager email against the employee email column.

[Kirk_Masden]

Hi @henniese! Welcome to the community!

Have you seen this:

Add any number of rows from any row within a table Tips & Tricks 💡

Definitely a frequently-asked question: how do I add some number of rows to a table automatically? It’s possible, but it’s not easy. This article details an approach that can be accomplished entirely within AppSheet (no API use), within the app itself (no workflow use), and accommodates an arbitrary number of rows (no built-in count maximum). While I’ve tried to make the guide accessible for less-experienced app creators, make no mistake: this is an advanced technique. I hope you find this us…

I think it may help. Recursion is discussed in the post.

[Marc_Dillon]

Kirk’s linked post describes a set of actions running recursively, this is not what is needed here, different kind of “recursion”.

You simply need a [Manager] column in your employees table that is a Ref type column, pointing back to the employees table. Each employee record can then specify another employee record as their manager. Then to get the email of the manager, you can use:

[Manager].[Email]

help.appsheet.com

Dereference Expressions

Use a dereference expression to retrieve a field value from a referenced record.

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

[Former Community Member]

Awesome, exactly what I was looking for.
Thanks

[cboteros]

I've noticed that Appsheet very conveniently creates a "Related XYZ" row when you link between different tables, but it doesn't seem to do the same for recursive tables.

In any case, I'm looking for an easier way to reference the "child" records. For the example in this thread, it would be something equivalent to say "Related Employees" (which is all those employees that someone manages)

I'm trying to avoid complex "Selects" if possible... any hint on how to achieve this?