Why are some of my Results (dropdown type) not popping up in the lookup column?

Sewon
Sewon
  • Updated

Issue

User creates a lookup table that pulls ALL results for a specific entity but not all of them are populating in the lookup column

 

Environment

Lookup Tables / Columns, Results

 

Cause

The dropdown type only gets pulled into the lookup columns once with no duplicates. Lookup columns won't show you how many times a dropdown option was recorded but only whether the option was recorded or not. E.g. if you recorded Yes 2 times and No 1 time, it will still be pulled as "Yes, No" in the lookup column and not "Yes, Yes, No". 

Screenshot 2024-03-12 at 1.04.32 PM.png

 

Resolution steps

Change the dropdown type to text or number. If the dropdown was yes/no, a boolean type will work as well.

Screenshot 2024-03-12 at 1.03.56 PM.png

Was this article helpful?

Have more questions? Submit a request