Dropdown Tags in Plus (+) to Add New Row not showing when table is empty

[Andrew_Hogue]

Hi,
I've been trying to debug this issue. Everything works fine when I have data already in the table, but when its empty and use the "+" to Add a new row, the dropdown fields don't populate properly. Any help is appreciated!

Here is an example of it the table when it works:

• I'm using a dropdown list populated with info from another table (investigators) :
  
  
• Inserting a new row:
  
• and selecting from dropdown list in new row:
  

THE BUG:

1. New Row dropdown doesn't populate on new row:
   

• If I click "save changes" it will insert an empty row which I can then update properly using the dropdowns but for some reason just on the empty table it doesn't work.

Configuration Info

• Using Retool Database

Backend Tables:

1. rel_investigator_studies - which is a relationship table with the following columns:

• id (unique)
• investigator - number (foreign key ID into a table with investigator info)
• Study - number (foreign key ID into a table of studies)

Queries:

1. investigators which contains info about the investigators
   with columns:

• id (unique, primary key)
• Name
• InvestigatorType (Enum)

2. LIST_STUDY_RESEARCHERS

select *
from rel_investigator_studies 
where rel_investigator_studies."Study" = {{ urlparams.study_id }} 

UI elements:

1. Table with data :

{{ LIST_STUDY_RESEARCHERS.data }}

and columns:

2. The investigator field is configured like this:

[lamh_bytecode.io]

Hello @Andrew_Hogue
Sorry I don't have a solution, just want to say that I was able to replicate the issue as well even with a hardcoded array.

[Tess]

Hi there! Unfortunately, this is a Retool bug We are discussing how to solve for this internally! I will keep this thread updated if I get any news about a fix shipping

In the meantime, my suggestion is to have users add new rows via a form, rather than through the native new row functionality. To get a similar look, you could trigger the add new row from a custom button in the table UI & open a modal. We have more on this workaround here