My data Updated by the app in google sheets keeps shifting to the right

[thrifty_test]

Hello,

has anyone experienced the problem in google sheets where the data in google sheets shifts to the right… instead of occupying the intended columns. this happens when I update the app.

is this a bug?

[Aleksi]

This can happen if the column amount doesn’t match in your device with the column structure.

[thrifty_test]

Is there a way of ensuring that the column regeneration works well?

[Lucinda_Mason]

I’m still pretty new at this but I’ve found, by experience not testing, that if I add a column to my table in google sheets that the placement is key.

Now, every time I add a column I do it at the end of the columns. I’m sure you shouldn’t have to do it this way but when I haven’t, even when regenerating the table in AppSheet immediately, the data is put in the wrong columns. Not the whole row but parts - like from where I added the new column.

That’s just my experience.

[thrifty_test]

Thanks Lucinda,
will try this out…

[thrifty_test]

is there a way appsheet can resolve this?, i actually i also found that Excel doesnot work well with sheet formulas… that why i moved to google sheets but i find google sheets to be super unstable…
I don’t know if there is something that i am not doing right? Now the Column types are selecting themselves to Enum even when i change them to text. When i save the column type goes back to Enum.
Has anyone met this kind of problem before

[thrifty_test]

Do you mean the number of Columns? if so this could be strange because I had regenerated the Column Structure

[Steve]

thrifty_test:

if so this could be strange because I had regenerated the Column Structure

Did you app have the updated structure before it sent data updates?

Lucinda_Mason:

Now, every time I add a column I do it at the end of the columns.

Yep, good idea!

thrifty_test:

i actually i also found that Excel doesnot work well with sheet formulas…

Generally speaking, it’s not a good idea to use spreadsheet formulas with AppSheet, even though AppSheet has some support for them. Best to try to do your calculations within the app itself.

thrifty_test:

i find google sheets to be super unstable…

Does that mean something other then the problem described above?

thrifty_test:

Now the Column types are selecting themselves to Enum even when i change them to text. When i save the column type goes back to Enum.

I’d guess the spreadsheet column is using data validation.

help.appsheet.com

Dropdown from Worksheet Data Validation Rules

How to create a dropdown from data validation rules that you have in your worksheet.