-
Goal:
I have a table element that pulls data in from MySQL that we want to review / update as needed. Some of these columns are a Tag (not Tags) column type. Ideally, we'd be able to change these and they save, but they either revert or most often disappear. I am not using any filters or conditional settings to hide rows. I do have certain columns hidden for easier readability, but include the full changeset when saving a change. -
Issue / Steps:
For some reason with this column, any time I change the tag from Yes > No or No > Yes and save, the value updates (I can see the row id with the updated value and it is correct) but when the data refreshes, the row is hidden and I can't figure out why. The actual underlying value of this column is a string of "Yes" or "No". I am able to update string columns and multi-tag columns without issue. This seems to only affect the Tag column type. I've tried creating a new table to ensure I didn't -
Details:
Using the latest available components. Am able to change the other rows with string / multi tag column types, save, and refresh the data successfully. I am using table.changesetArray in the mysql gui query to change tables without multi-tags.
If multi-tags are being used, I use table.changesetArray.map(row => Object.assign(row, {fieldName: JSON.stringify(row.field7)}))
Also the table references a transformer and not a query directly -
Screenrecording:
Still working on this, but I believe the underlying issue is I am setting a static mapped item value for the column...
I believe I figured this out. The first column is a tag, but the mapped value (something set automatically when I mapped the data in Retool) was changing the value from a lowercase to upper case value:
{{ _.startCase(item) }}
Had to remove that from a few columns, but that fixed the issue.
1 Like