Send finalized form to Google Spreadsheet problem

Hello,

When I was following the tutorial of Google Drive integration in here
https://www.google.com/earth/outreach/tutorials/odkcollect_drive.html, I
having a problem when sending the form with missing columns error
(screenshot attached).
Can anyone help what I'm missing ?

Thanks,
Jerry

Hi Jerry,

What version of ODK Collect are you using?

Yaw

ยทยทยท On Thu, Mar 30, 2017 at 11:16 PM, Jerry Quarry Mentang wrote: > Hello, > > When I was following the tutorial of Google Drive integration in here, I > having a problem when sending the form with missing columns error > (screenshot attached). > Can anyone help what I'm missing ? > > Thanks, > Jerry > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.

The current version of the app takes the list of all sheets and picks the
first one. It has nothing to do with the name of the sheet.

1 Like

Hi Yaw,

I'm using version 1.5.1.

Regards,
Jerry

Sent using my mobile device, apology for any typos

ยทยทยท On Apr 4, 2017 4:10 AM, "Yaw Anokwa" wrote:

Hi Jerry,

What version of ODK Collect are you using?

Yaw

On Thu, Mar 30, 2017 at 11:16 PM, Jerry Quarry Mentang jerry.qm@gmail.com wrote:

Hello,

When I was following the tutorial of Google Drive integration in here, I
having a problem when sending the form with missing columns error
(screenshot attached).
Can anyone help what I'm missing ?

Thanks,
Jerry

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Yaw,

I found the problem and I feel really stupid for not paying attention to
the steps in the video.

Apparently the position of submission sheet is important. When I moved this
sheet to the leftmost of the sheets tab, the submission process works fine.

I hope this is useful to others who have the same problem as me.

Regards,
Jerry

ยทยทยท On Tue, Apr 4, 2017 at 9:12 AM, Jerry Quarry Mentang wrote:

Hi Yaw,

I'm using version 1.5.1.

Regards,
Jerry

Sent using my mobile device, apology for any typos

On Apr 4, 2017 4:10 AM, "Yaw Anokwa" yanokwa@nafundi.com wrote:

Hi Jerry,

What version of ODK Collect are you using?

Yaw

On Thu, Mar 30, 2017 at 11:16 PM, Jerry Quarry Mentang jerry.qm@gmail.com wrote:

Hello,

When I was following the tutorial of Google Drive integration in here, I
having a problem when sending the form with missing columns error
(screenshot attached).
Can anyone help what I'm missing ?

Thanks,
Jerry

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2 Likes

Hi Jerry,

Glad you found a fix! We either have to use position or require a
special name for the sheet. I think using position is easier for the
majority of users.

This should be documented somewhere but I know it's hard to find. We
are looking into centralizing and improving ODK's documentation. If
anyone has experience or interest in this effort, please let me know!

Thanks,

Yaw

ยทยทยท On Wed, Apr 5, 2017 at 8:05 AM, Jerry Quarry Mentang wrote: > Hi Yaw, > > I found the problem and I feel really stupid for not paying attention to the > steps in the video. > > Apparently the position of submission sheet is important. When I moved this > sheet to the leftmost of the sheets tab, the submission process works fine. > > I hope this is useful to others who have the same problem as me. > > Regards, > Jerry > > On Tue, Apr 4, 2017 at 9:12 AM, Jerry Quarry Mentang wrote: >> >> Hi Yaw, >> >> I'm using version 1.5.1. >> >> Regards, >> Jerry >> >> Sent using my mobile device, apology for any typos >> >> On Apr 4, 2017 4:10 AM, "Yaw Anokwa" wrote: >>> >>> Hi Jerry, >>> >>> What version of ODK Collect are you using? >>> >>> Yaw >>> >>> On Thu, Mar 30, 2017 at 11:16 PM, Jerry Quarry Mentang wrote: >>> > Hello, >>> > >>> > When I was following the tutorial of Google Drive integration in here, >>> > I >>> > having a problem when sending the form with missing columns error >>> > (screenshot attached). >>> > Can anyone help what I'm missing ? >>> > >>> > Thanks, >>> > Jerry >>> > >>> > -- >>> > -- >>> > Post: opendatakit@googlegroups.com >>> > Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> > Options: http://groups.google.com/group/opendatakit?hl=en >>> > >>> > --- >>> > You received this message because you are subscribed to the Google >>> > Groups >>> > "ODK Community" group. >>> > To unsubscribe from this group and stop receiving emails from it, send >>> > an >>> > email to opendatakit+unsubscribe@googlegroups.com. >>> > For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> -- >>> Post: opendatakit@googlegroups.com >>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> Options: http://groups.google.com/group/opendatakit?hl=en >>> >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "ODK Community" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to opendatakit+unsubscribe@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. > > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.

Hi Yaw,

Unfortunately I have no experience on writing documentation.

I'm willing to contribute, if you could tell me what would you need me to
do.

Regards,
Jerry

https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail
Virus-free.


https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

ยทยทยท On Thu, Apr 6, 2017 at 6:56 AM, Yaw Anokwa wrote:

Hi Jerry,

Glad you found a fix! We either have to use position or require a
special name for the sheet. I think using position is easier for the
majority of users.

This should be documented somewhere but I know it's hard to find. We
are looking into centralizing and improving ODK's documentation. If
anyone has experience or interest in this effort, please let me know!

Thanks,

Yaw

On Wed, Apr 5, 2017 at 8:05 AM, Jerry Quarry Mentang jerry.qm@gmail.com wrote:

Hi Yaw,

I found the problem and I feel really stupid for not paying attention to
the
steps in the video.

Apparently the position of submission sheet is important. When I moved
this
sheet to the leftmost of the sheets tab, the submission process works
fine.

I hope this is useful to others who have the same problem as me.

Regards,
Jerry

On Tue, Apr 4, 2017 at 9:12 AM, Jerry Quarry Mentang <jerry.qm@gmail.com wrote:

Hi Yaw,

I'm using version 1.5.1.

Regards,
Jerry

Sent using my mobile device, apology for any typos

On Apr 4, 2017 4:10 AM, "Yaw Anokwa" yanokwa@nafundi.com wrote:

Hi Jerry,

What version of ODK Collect are you using?

Yaw

On Thu, Mar 30, 2017 at 11:16 PM, Jerry Quarry Mentang jerry.qm@gmail.com wrote:

Hello,

When I was following the tutorial of Google Drive integration in
here,

I
having a problem when sending the form with missing columns error
(screenshot attached).
Can anyone help what I'm missing ?

Thanks,
Jerry

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it,
send

an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups

"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an

email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

1 Like

Hi Jerry,

Thanks so much for offering! Once we line up someone to lead this effort,
we can loop you in then.

Yaw

ยทยทยท On Sun, Apr 9, 2017 at 10:13 PM, Jerry Quarry Mentang wrote:

Hi Yaw,

Unfortunately I have no experience on writing documentation.

I'm willing to contribute, if you could tell me what would you need me to
do.

Regards,
Jerry

https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free.
www.avast.com
https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail
<#m_-4359464285139856582_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Thu, Apr 6, 2017 at 6:56 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Jerry,

Glad you found a fix! We either have to use position or require a
special name for the sheet. I think using position is easier for the
majority of users.

This should be documented somewhere but I know it's hard to find. We
are looking into centralizing and improving ODK's documentation. If
anyone has experience or interest in this effort, please let me know!

Thanks,

Yaw

On Wed, Apr 5, 2017 at 8:05 AM, Jerry Quarry Mentang jerry.qm@gmail.com wrote:

Hi Yaw,

I found the problem and I feel really stupid for not paying attention
to the
steps in the video.

Apparently the position of submission sheet is important. When I moved
this
sheet to the leftmost of the sheets tab, the submission process works
fine.

I hope this is useful to others who have the same problem as me.

Regards,
Jerry

On Tue, Apr 4, 2017 at 9:12 AM, Jerry Quarry Mentang < jerry.qm@gmail.com> wrote:

Hi Yaw,

I'm using version 1.5.1.

Regards,
Jerry

Sent using my mobile device, apology for any typos

On Apr 4, 2017 4:10 AM, "Yaw Anokwa" yanokwa@nafundi.com wrote:

Hi Jerry,

What version of ODK Collect are you using?

Yaw

On Thu, Mar 30, 2017 at 11:16 PM, Jerry Quarry Mentang jerry.qm@gmail.com wrote:

Hello,

When I was following the tutorial of Google Drive integration in
here,

I
having a problem when sending the form with missing columns error
(screenshot attached).
Can anyone help what I'm missing ?

Thanks,
Jerry

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it,
send

an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups

"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it,
send an

email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi all! I just went through this... what's the status w/ updating the documentation for this?

Hi Jerry,
Currently I'm suffering from this problem since a couple of months, and I did not have a reflex to visit the forum.
The problem with me is that the first forms were sent without problem, the following no.
I'm not sure to understand what position you are speaking about ??
Really, it's a big problem for me (more than 100 forms saved).
I will be really pleased and gratefull if you could help me on that
Thank in advance.


Best regards
Mรฉdiha (Tunisia, North Africa)

Hi, don't worry. Please count and check your total questions you have in your xls form. Then check the columns you have in gsheet. You can find it and edit the column name.

Hi Jerry,

Yes you are right i have got same problem earlier. Now i have fix that problem like as you suggest. Thank you for your kind support.

Regards,
Ishor

2 Likes