Updating a link to table field with the application builder results in an "The data_source configuration is incorrect: Recursion detected." error
Describe the problem
I have a table with Staff members and a table with Scheduled Events. Those tables are linked to each other:
- A staff member is linked to multiple scheduled events
- A scheduled event is linked to multiple staff members
I have created an application that updates the field Team members in the Scheduled Events table. This field is a link to table field to the Staff table. In my application, I want to be able to add staff members to an event.
Steps to reproduce
- Database:
- Create a table Staff
- Create a table Scheduled Events
- Link the tables to each other
- Create a new application
- Create a data source that gets a single event (based on id parameter)
- Create a data source that gets a single staff member (based on id parameter)
- Add a button
- Create an event for the button that updates a record in the Scheduled Events table
- Row ID = the parameter passed to the page
- Team members = All existing team members (Data > Event > Team members > [All > value),Data > Staff > Name)
- Execute the application and press the button
Actual result
An error message
{
"error": "ERROR_DATA_SOURCE_IMPROPERLY_CONFIGURED",
"detail": "The data_source configuration is incorrect: Recursion detected."
}
Expected result
The new staff member should be added to the Team members field. But this only works if a create an additional field in the table that converts the field to a text field separated by commas using the formula join(lookup('Team members','Name'),',')
Environment
- Operating System: Mac
- Web Browser: Chrome
- Deployment Type: docker
- Baserow Version: Develop