Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
[x] I have searched budibase discussions and github issues to check if my issue already exists
Hosting
Cloud
Tenant ID:
Describe the bug
I have authors, titles and title_author tables with n:n relationship between authors and titles (via supabase/postgres). In the data tables or in the table element, the multiple records of authors on the title or multiple titles on the author are displayed correctly by the selected display column (e.g. authors.full_name and titles.title), can be added, deleted etc. But on the form element, the multiple records are displayed by the _id column. New records can be searched and added, but the old ones cannot be deleted (both in design and preview).
To Reproduce
Create an n:n relationship of two tables via a third one where multiple records from one table are associated with a record in the second table. Set display columns. Generate a table with edit modal form or a form. Open the form and check the field with multiple related records.
Expected behavior
The form should have the multiple related records displayed by the display column and it should allow the deletion of those records.
Screenshots
Records for titles in the authors table correctly displayed
Records for titles in the authors form incorrectly displayed as _ids
App Export
I am happy to export, but should I encrypt it?
linear[bot]
commented
2 days ago
Checklist
Hosting
Describe the bug I have authors, titles and title_author tables with n:n relationship between authors and titles (via supabase/postgres). In the data tables or in the table element, the multiple records of authors on the title or multiple titles on the author are displayed correctly by the selected display column (e.g. authors.full_name and titles.title), can be added, deleted etc. But on the form element, the multiple records are displayed by the _id column. New records can be searched and added, but the old ones cannot be deleted (both in design and preview).
To Reproduce Create an n:n relationship of two tables via a third one where multiple records from one table are associated with a record in the second table. Set display columns. Generate a table with edit modal form or a form. Open the form and check the field with multiple related records.
Expected behavior The form should have the multiple related records displayed by the display column and it should allow the deletion of those records.
Screenshots Records for titles in the authors table correctly displayed
Records for titles in the authors form incorrectly displayed as _ids
App Export I am happy to export, but should I encrypt it?