Solved: Columns inaccurate when adding new table

Nick_Neumann · 04-02-2020 03:17 PM

I’m trying to add an incredibly simple table with one column for ref validation. It’s one column with the header of Status and 4 other rows with statuses (Needs Copy, Needs Photo, Ready, Published). When I add the table, it reads “Needs Photo” as the column name and then only displays “Ready” and “Published” as row values.

I have even tried adding the table with just “Status” as a column header with no row values, which works initially, but when I add “Needs Copy, Needs Photo, Ready, Published” as row values, the same problem occurs. What’s going on here?

Phil

Bolding the header row will solve the problem.

A single column table containing short text values that look like column header values can throw off type inference.
The word “Photo” is a word that typically appears in the header row of a table.
Since that row is relatively near the top of the sheet and it contains a word that often appears in a header, that row it is getting selected as the header row.
When your worksheet contains multiple columns (as most do) it is easier for Appsheet to locate the header row.
If a row is bold, we take that as a strong indication that the bold row is the header row.

See https://help.appsheet.com/en/articles/961390-spreadsheet-cell-formats

View solution in original post

Chris_Jeal

Hi @Nick_Neumann,

I think I may have come across this issue before.
Try freeze the 1st row of your data table ‘Status’ then regenerate your column structure.
If I remember correctly that solved it for me.

Also, might be worth adding in a key column, if your data already exists in your data table use randbetween to generate your unique id.

MultiTech

Another bit of helpful info: make the top row bold, AppSheet used to pick up on this and key off of that to find the “Column Headers” back in the day. Not sure if that code is still in use or not, but that was one thing that always worked for me.

Phil

Bolding the header row will solve the problem.

A single column table containing short text values that look like column header values can throw off type inference.
The word “Photo” is a word that typically appears in the header row of a table.
Since that row is relatively near the top of the sheet and it contains a word that often appears in a header, that row it is getting selected as the header row.
When your worksheet contains multiple columns (as most do) it is easier for Appsheet to locate the header row.
If a row is bold, we take that as a strong indication that the bold row is the header row.

See https://help.appsheet.com/en/articles/961390-spreadsheet-cell-formats

Steve

Nick_Neumann

You all are correct, bolding the header worked. Thank you!