Send finalized form to Google Spreadsheet problem

Jerry_Quarry_Mentang · March 31, 2017, 6:16am

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

yanokwa · April 3, 2017, 9:10pm

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.

Shobhit_Agarwal · April 11, 2017, 6:38pm

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.

Jerry_Quarry_Mentang · April 4, 2017, 2:12am

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.

Jerry_Quarry_Mentang · April 5, 2017, 3:05pm

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.

yanokwa · April 5, 2017, 11:56pm

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.

Jerry_Quarry_Mentang · April 10, 2017, 5:13am

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.

yanokwa · April 10, 2017, 10:08pm

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.

Amit_Kohli · August 29, 2018, 9:27am

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

mediha.khamassi · October 6, 2018, 7:32am

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)

md-rahim · October 9, 2018, 6:27pm

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.

Ishor_Neupane · January 3, 2019, 2:10pm

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