Relationship list error with default value

[Philippe-M]

Checklist

• [ *] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker compose
  • Budibase Version: 3.4.24

Describe the bug
Hello everyone,

I have a table that displays a list of data. When I click on a row in the table, I open a modal window, passing an ID as a parameter. In the modal window, there is a dropdown list that has the default value set to the parameter passed from the data table. I fill out my form and when I click the button to validate it (see gif in screenshot).

To Reproduce
Steps to reproduce the behavior:

1. create table list {id,namelist} and sdelivery {id, (relationship -> list.namelist)} and add data
2. create screens "/list"
3. on screen "/list" add table with list table for source and add action "on row click", add action "Navigate To" > screen > /sdelivery/new/{{ Clicked row.nameList }} and open in modal.
4. create other screen "/sdelivery/new/:namelist" with form data sdelivery table
5. on relationship list add default value : {{ URL.namelist }}
6. save
7. on preview or publish on screen list click on row for open a modal. In list is default select "namelist"
8. clic on save button and see error

Screenshots

Schema

MySQL-dump.sql.txt

Desktop (please complete the following information):

• OS: Linux Fedora 41
• Browser Firefox
• Version 135

[linear[bot]]

BUDI-9107 Relationship list error with default value

[aptkingston]

Hey @Philippe-M. The problem here is just that you need to use the row ID for the default value rather than the nameList column. To do that, update your click action to navigate to /sdelivery/new/{{ Clicked row._id }} (notice the _id field instead), then use this value as you default value instead.

Then everything should work as intended 👍

[Philippe-M]

Hey @aptkingston , Thanks for your response. I modified the click action as you indicated

Now, when I click on one of the lines, it adds the _id value to the list instead of selecting the one corresponding to the id

Could it be because I defined the nameList field as the one to display in my database?