Bug in alternate row background color

bradlymathews · March 18, 2022, 7:07pm

Take a look at this paginated table:

Page 1:

Page 2:

Page 3:

Page 4:

You get the idea. And yes, it's only this one column.

lauren.gus · March 23, 2022, 12:56am

@bradlymathews

Hey there Is Qty a custom column?

bradlymathews · March 23, 2022, 3:22am

It is not a custom column. The data is from a Azure SQL query with a formatDataAsArray() transformer. The data type of the qty field is int. Nothing about the column is unusual.

I tried some other things like changing the freeze column options (client had gone overboard on freezing everything!) with no effect.

One thing that did fix it was changing to Standard Layout from Compact, so looks like it only affect Compact Layout.

Kabirdas · March 24, 2022, 6:17pm

This is pretty odd is it just the cell background color that's shifting or are the values shifting as well?

bradlymathews · March 24, 2022, 6:32pm

Looks like just the background color.

Kabirdas · March 25, 2022, 6:34pm

Would you mind posting screenshots of your table setup so that we can try and repro it on our end?

bradlymathews · March 25, 2022, 7:15pm

Sure:

Here is the source query:

Here is a some output from the query to throw into your table.

[
{
"line_item_id": 133375,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0001",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Anchor",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133376,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0004",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Butterfly 'Kamehameha'",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133377,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0005",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Camper",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133378,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0006",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Cruiser Bike",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133379,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0007",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Dolphin",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133380,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0008",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Heart",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133381,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0009",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Hook",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133382,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0010",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Hula Dancer",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133384,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0012",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Longboard",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133385,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0013",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Mahi Mahi",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133386,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0014",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Manta Ray",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133387,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0015",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Map",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133388,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0016",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Mermaid",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133389,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0017",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Mermaid Breast Cancer Research",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133390,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0018",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Octopus Black",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133391,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0019",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Octopus Orange",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133392,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0020",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Octopus Purple",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133393,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0021",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Orca",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133394,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0022",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Peace Sign",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133395,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0023",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Plumeria",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133396,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0024",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Rainbow",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133397,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0025",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Rooster",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133398,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0026",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Seahorse",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133399,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0027",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Shaka Island",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133400,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0028",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Shark",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133401,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0029",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Starfish",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133402,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0030",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Sun",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133403,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0031",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Sunflower",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133404,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0032",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Sunset Wave",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133405,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0033",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Tiki",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133406,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0034",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Turtle",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133413,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0041",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha UFO",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133407,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0035",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Ukulele",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133408,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0036",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha VW Bug",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133409,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0037",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha VW Bus",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133410,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0038",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha VW Bus 'Front'",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133411,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0039",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Whale",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133412,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0040",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "Aloha Woody",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
},
{
"line_item_id": 133383,
"invoice_id": "22031149S2-1",
"sku": "002-STK-0011",
"bundled_sku": "",
"quantity": null,
"price": 1.75,
"note": null,
"product_name": "California License Plate 'Aloha' ",
"bundleable": false,
"product_type": "Sticker",
"bundled_name": "",
"bundled_product_type": "",
"product_type_id": 2,
"bundled_product_type_id": 15,
"town_id": 2,
"town_name": "ALOHA ",
"active": true,
"active2": null
}
]

Chris-Thompson · March 25, 2022, 8:24pm

Hey @bradlymathews!

Awesome, thanks for all this info, this is very helpful. How are you handling this alternating background color at the moment? Does each column have some logic in it based on the index of the row like:
{{i%2==0?"lightgrey":"white"}}

I have the rest of the repro set up on my end but the code above seems to work ok on my end

bradlymathews · March 25, 2022, 8:45pm

I am using the Alternate row background setting in the Styles section.

Chris-Thompson · March 25, 2022, 9:28pm

Ah, I see completely missed that on the first pass. I'm having a hard time reproducing this with the same data on my end. Just to confirm, are you on a cloud-hosted or on-prem instance? If on-prem, what version number are you currently using?

bradlymathews · March 25, 2022, 9:43pm

On cloud. Maybe a corruption in the current app? Has happened to me before and causes weird side effects.

Chris-Thompson · March 25, 2022, 9:54pm

Hmm, possibly , would you mind emailing me a copy of the JSON export of this app? My email is chris@retool.com and I'd be happy to dig in further!

bradlymathews · March 25, 2022, 10:42pm

Just sent it.

Chris-Thompson · March 25, 2022, 10:48pm

Awesome, thanks for that, I was able to reproduce the bug and will write up a bug report, thanks for surfacing this!

Chris-Thompson · March 30, 2022, 4:02pm

Hey @bradlymathews — I've gone ahead and linked a bug report to this thread so we can keep you up to date as a fix is merged. In the meantime, it looks like the bug does not persist after upgrading to the new version of the table in my repro app. Does this also seem to work on your end?

bradlymathews · April 5, 2022, 4:17pm

Finally got a chance to test this. Yes, the new table version is immune to the issue. Toss this one into the "No longer matters" bin.

victoria · August 2, 2023, 1:34am