In-app sort feature not working for the price column

Ask for Help
1

Hi,

I have a price column for my products and trying to use the in-app sort feature to allow a user to sort the list of products by price.

Unfortunatly the feature seems to be sorting the price in a weird way. For example instead of 1.99, 2.99, 3.99, 12.99, 20.00 and 34.99, I’m getting 1.99, 12.99, 2.99, 20.00, 3.99, 34.99. So it’s only looking at the first digit rather than theentire figure. I’ve tried changing the column from text to number and vice versa and I get the same result.

Any suggestions on what I can do to fix it?

1 Like
2

Check the column type in the data editor. It’s numeric or string? May be the second.

3 Likes
3

I had it as number currency and it didn’t work. Then I changed it to just number and it worked. Thank you!

2 Likes
4

You’re welcome

5

Hi,

How do I get the currency sign (£) to appear in the inline list and the table component?

It’s in my data editor but it doesnt appear on the app.

1 Like
6

If your column is numeric, you can set the symbol you need in the data editor. Now I’m not in front a computer to send you a screenshot but if you check you can found some options when you edit the column.

1 Like
7
1 Like
8

Thank you!!!

1 Like