Solved: Adding columns in the middle of the table broke En... - Page 2

SITECH_Mid-Cana · 11-24-2020 02:33 PM

I get the weirdest problems.

I have a table Rental Requests. The first x number of columns gather information such as company, phone number, dates, etc. The magic happens in the last few columns. I have a column called Product type EnumList. It contains rental products. after the Product column I have an empty column type Show, Category Page_Header with a show If expression. Next column is a Rental Product name which is Enum List with a list of accessories. I have this Empty Column, Rental Product Name repeating for a number of products. Depending on what Product is selected in the Product column EnumList only the relevant Product Names show up so I can select a list of accessories for each.

Everything worked great UNTIL I added a few columns in my table before the Product column. I regenerated structure and everything looked normal. Until you create a form. What happens is a EnumList from Product Name1 got shifted to Product Name2. For example lets say I have a Product Name 1 is Skies it would have EnumList Poles, Helmet. Product Name2 Snowboard, It would have EnumList SnowBoard Shoes, Life Insurance. When I go to create a form, Skies no longer exists and Snowboard has Poles, Helmet.

Is there a way to fix it other then starting from scratch and recreating EnumLists for all products?

Marc_Dillon

It appears that the EnumList for Robotic is displayed correctly for the Robotic column, but it is under the wrong Show column/Page Header. I imagine this is due to the fact that your Show columns don’t have names in the sheet, and so are assigned generic names in Appsheet with their column numbers, which got shifted around when you added new columns before them, giving all of them new names. I’m guessing you have a slice, or column order defined in the form, that just needs adjusted to handle the new names.

You can change a column name in Appsheet, and in the backend, and Save and all will be good(ish). Or you can modify the column structure and regenerate. But if you try to do both at the same time, which you’ve essentially done here although unintentionally, then things will get messed up.

View solution in original post

Adding columns in the middle of the table broke EnumList columns