Google sheet collect data column order

Support
1

What is the problem? Please be detailed.

I want to have my data in a specific order (somme question are juste note so I do no reply need the none answer)
I try to put my column title in a specific order but each time when a form is received the order go back to the previous one

What ODK tool and version are you using? And on what device and operating system version?
1.20
What steps can we take to reproduce the problem?

What you have you tried to fix the problem?

Anything else we should know or have? If you have a test form or screenshots or logs, attach here.

2

Hi @Fabienne35

that's strange because I tried a scenario like:

  1. I sent one form to Google Sheet
  2. Then I reordered my columns.
  3. Then I sent another form

and the order didn't change. Could you provide more info? Maybe you can share your form and the sheet you are using?

3

I sent a sample form
I open a new sheet and copy the column name in my order

In the 2nd line I put some text to explain the column information

I sent all my form in this new sheet

I experiment a reordering of columns title
Fabienne

4

Do you mean that column names are reordered back but not other rows and then they don't match right?
If so column names are not reordered but in fact ODK Collect inserts them again. Such a case might take place when one of column names is empty. Are you sure you copied column names properly?

5

Exactly

And truly I put a blank columns between my first prefered columns ans the others

Thanks for the explanation

Fabienne