Dropdown Selections Changing Randomly Across Multiple Fields – Data Entry Issue in Retool

I’m having a significant problem while using a Retool app connected to our database. The app has several dropdown fields like country, state, city, and other options. Here’s a detailed description of the issue:

When I select an option from one dropdown field (for example, the country dropdown where I select "United States"), it works initially. But then, when I move on to another field (like the state field), things start to go wrong.

  1. When I hover over the state field (or any other text or dropdown field), the mouse cursor turns into a hand icon, which suggests it is a clickable field, instead of showing the text select cursor that would allow me to type or make a selection.
  2. When I click on the state field, the expected dropdown doesn’t appear, and I am unable to type anything into the field.
  3. Even worse, as soon as I click on the state field, the country that I had previously selected randomly changes. For example, I might have chosen "United States," but after clicking on the state field, the country will suddenly switch to something random, like "Japan" or another country.
  4. This behavior is not limited to the country and state fields. It happens with multiple fields across the app. Every time I try to click a new field, the previous selections keep changing, and it’s becoming impossible to correctly input data.
  5. This is leading to incorrect data being entered into our database, which is a serious issue because the integrity of our records is being compromised.

Steps I’ve taken so far:

  1. I’ve refreshed the page and reloaded the app several times, but the issue continues to occur.
  2. I’ve tried clearing my browser’s cache and cookies, but that hasn’t resolved the problem either.
  3. I haven’t made any changes to my system or browser recently that could have caused this.

Expected behavior:
I expect to be able to select a value from one dropdown (like the country field) and then move to the next field (such as the state) without my previous selection changing. Each field should allow me to either type or select from the available options without affecting the previously selected values.

Details:
I’m not a developer, but I use this Retool app regularly for inputting data into our database. The issue affects multiple dropdown fields and text input fields across the app. It used to work fine, but this problem started recently and now it’s causing major disruptions in the way we input data. The random changes in selected values are causing us to record incorrect information in our database, which is a significant problem for our work.

Unfortunately, I don’t have access to the app’s backend or configuration as I’m only a user, but I wanted to report this issue in case anyone has experienced something similar or has suggestions on how to fix it. I’ve also tried looking through the Retool documentation, but I couldn’t find anything that addresses this specific issue.

Screenshots:
I’m unable to provide screenshots, but I can provide further details if needed.

App json export:
I don’t have access to export the app’s configuration, but if required, I can request it from our development team to help with troubleshooting.

Has anyone else encountered this issue, or do you have any ideas on how this could be resolved? Any help would be greatly appreciated.

Hello @TechExplorer,

Apologies for the issues, this is very odd. I am going to look into see if we have having an incident that could be causing this.

Could you share a screenshot of you select value/drop down components settings?

I would suggest checking if Widget gird is enabled, and if so, turning off widget grid.

We might need you to come to office hours to take a look at the app over a shared screen to help with debugging this issue if it is still present.

There could be a number of things causing the UI to lag or this could be a whole new bug we haven't seen before.

Are you self-hosted or on the cloud?

Hi Jack_T, In this video, you can see that I’m having trouble entering values in some fields. When I click or manage to input something in one field, it unexpectedly changes the value in another field that was already filled in. This issue happens every time I interact with the fields, and it seems like there's some bug causing the fields to be linked or affecting each other when they shouldn’t.

Let me know what you think!

att.DS_KnQH1TG7ibIv0LwKepNh-Xa4wGhcdCjbiheXqexE

Hello @TechExplorer,

Thank you for sharing that screen recording, that is some very odd behavior :sweat_smile:

I am wracking my brain to think of what we could change or test out. My first gut reaction was to have you try deleting and recreating the drop down components to see if starting fresh might get the components to work as intended.

The timing of the issue is odd, given that you said it was working and now it seems to not be working.

I did have an engineer reach out to me who saw this issue and thinks it could be related to a known bug we are currently working on!

We are working on fixing an issue where a dropdown appears to be closed but is actually invisible and changes the field's value based on where you click on the page as if it is still open.

Which would explain why the first field such as country is changing when it should have closed and stopped taking inputs.

Here is a link to the thread, we will be updating users there for when the fix comes through. I can also connected this thread to the engineering ticket as well for sending me updates to alert you to.

Just to test things out. From a fresh page load, try clicking on another dropdown field besides countries, such as states. Then try to click on a field below states and see if it changes the states, as if the states dropdown had never closed.

That would confirm the bug is the same one reported and give us some closure while we wait for the update to fix it :sweat_smile:

Thanks for the detailed response! Can you please provide the link to the thread? :slight_smile: Thanks!

1 Like

Ah yes apologies I thought I had linked it! :sweat_smile:

The thread for the invisible dropdown is here.

Sorry for the issue and I hope to be coming back with good news on a fix or update timeline soon!