How to transform a table into questions on ODK

Support
1

Hello all!

I was hoping someone might be able to provide an example of what I would need to include in my form, to be able to enter data from table such as this:

image

Time, Temp fish, Temp air and Smoke density are unique values every time.

Thanks in advance!

Fran

2

Using what tool? ODK Collect?

3

Yes sorry, ODK Collect. Here is my form so far, row 39 is what I need to change. Smokingformv5.xls (384 KB)

4

Unfortunately, it's not possible because we don't support such a tabular/grid view. I've also heard from other users that it would be a nice feature and there is even a topic about it here: Form design: grid of text or numeric input

Please go through it maybe add your insights it will help us to add it.

1 Like
5

Hi @Frances!
Kushe? How dae bodi? :slight_smile:

I would suggest you use a repeat group to collect the 4 variables you need.
Each new group (loop) would be a new record of the paper table.

Please see attached a sample excel form with rows 39-44 added and edited.
I've tested it on Enketo and seems to work fine.
Note that I've saved it in xlsx format (which has larger compatibility and uses less space).

I hope this helps!

Best,
Andrea
:sierra_leone:Smokingformv5.xlsx (74.9 KB)

1 Like
6

Hi Andrea! I am fine thank you. I don't see an attachment, sorry.

7

Sorry, here it goes

Smokingformv5.xlsx (74.9 KB)

Also, here the link to the enketo test upload:
https://odk.enke.to/preview?form=https://xlsform.opendatakit.org/downloads/_ummmir1/Smokingformv5.xml

Cheers,
Andrea

1 Like
8

This is a perfect solution for the time being, until a table widget is developed. Thank you so much!

2 Likes
9

Glad it worked!

Good luck with your exercise.

Best,
Andrea

2 Likes