Table Tag Column - Row Hidden When Tag Changed

App Building
,
1

  • 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:
    Table-Tag-Column

2

Still working on this, but I believe the underlying issue is I am setting a static mapped item value for the column... :man_facepalming:

3

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