Mapped Field on Table doesn't work

App Building
1

Goal: Trying to show the tag details on a table field by mapping the option list

Steps: I have done this many times and it always work:

  • Click on table field
  • Make it a tag
  • User the mapping of the option list
  • Select the query and update the value and label

Details:

  • I am 100% all the values from the table field exist in the table
  • This is the only query that doesn't work
  • Have tried in a couple of tables that have the field
  • Maybe the field name is reserved in Retool?
  • I tried updating the field (as the drop down shows the records. But after saving the update the column that is mapped goes back to be blank

Screenshots:

image
image1856×786 176 KB

2

Hi @Dataland , this might be a long-shot, but I vaguely recall encountering something similar when mapping the options of an editable column.

I think it came down to case sensitivity between the underlying values and the mapped options (used for potentially selecting a new value in the cell and saving it back to the source).

Can you double-check the casing of the values and the options to rule that out?

1 Like
3

Hi @dguzzo, thanks for the tip. The tables and field names were correct; but I did find that the data type of the 2 fields I was mapping together were different. One was an integer and the other was a varchar holding integers. Change the varchar to be an integer and everything started working.
Good to know that the data type of the mapped fields need to match!
Thanks again.

2 Likes