Hi,

Self-referencing table is a basic feature in a lot of comparable software (Access and Filemaker Pro). It's frustrating to migrate here and be left without the possibility of doing so.

Self-referencing table is critical for allowing sub-record (sub-task, sub-milestone, etc.) management. If you have a Task form, you might want to allow your users to structure their work in a task/sub-task way. Zoho Project allow such feature. For this, you need to be able to reference a task to its parent task. You can't create a additional sub-task form because you won't be able to show tasks and sub-tasks inside the same report/calendar/timeline anymore

Currently the suggested solution is to update an empty dropdown field using :ui.add.list() after fetching the form records as list. There are multiple issues with this;

1. you can't use the "Allow new entries" feature present in lookup fields which will confuse users

2. the logical way of allowing sub-task would be to provide a subform inside the form. But you currently can't do that.

Allow tree view for list report would be the next logical step. Allowing seeing records not as groups but as parent-child in a list would allow for easier task management.

Hope this can be discussed with the team.

Cheers.

B.