Column width in table view does not take into...

(Yossi Oulu) #1

Column width in table view does not take into account the max column width

Trying to maximize the data seeing in a table on a mobile is a very important task for good UI. It seems that appsheet arbitrarily limit the number of columns to 3 sometimes 4 or some other miss calculation. E.g. in the attach example, the second field NI is a TEXT field with initials of names, 2 characters in size. I set the max width of that column to be 2. So I expected it to place the next field ‘PO’ just after it, but it keeps a lot of space for no reason, which leaves no space for the message. The PO is a text field with a width limit of 4 characters, but there it decides to show only 2 (indeed I have for now only PO with 2 characters in size)

It looks like a bug in the column size calculations. Can you please fix that?

Thanks a lot!

(Yossi Oulu) #2

More info about that… if I change the PO field to be REF (instead of Text) it decides to increase the space taken by that field in the table UI see here:

So it is all very unpredictable…

I hope this is a small thing to fix


The column width determination is actually quite complicated, but column statistics are only generated when you choose “Save and Verify” in the editor (it noticeably speeds up saving many small changes if we skip this on Save).

So two things to try: - Make sure the column width option in the table settings is Narrow - Save and Verify, then sync the app

(Yossi Oulu) #4

@Adam_Stone_AppSheet thanks… sure this is the first thing I tried. All im showing here is with Narrow and after save. If the intent was to leave minimal space so for sure this is bug.

(Aleksi Alkio) #5

When the situation is like that with fixed length, I normally merge these columns with the virtual column and then I can be sure that it shows them correctly. I know it would be better if the app could show that situation perfectly but sometimes we need to use workarounds.

(Yossi Oulu) #6

@Aleksi_Alkio yes. Did that

but you loose the sorting capability per column. Sounds like a small bug fix.

(Yossi Oulu) #7

@Aleksi_Alkio and when you do that the columns are not aligned. You can never know how much space to leave… it depends on the font… all becomes ugly

(Aleksi Alkio) #8

You can still sort the order in the table view even if you show only the merged column. But as I said, it works in some cases.

(Yossi Oulu) #9

@Aleksi_Alkio How can you sort?? the user has the ability to click on a column and sort the data according to that column. If few columns are merged you can only sort on the first column

(Aleksi Alkio) #10

Not from the column header though. I meant from the table view’s definition.

(Yossi Oulu) #11

@Aleksi_Alkio sure. Not related to table view.