Hide fields in data export

[sevavardhini]

Hello,
using ENKETo web format.
when i export my raw data in xls format… i get fields with headers of Notes with blank information

How to hide these fields while exporting. anything to be written in code on survey TAB?
i have received blank field for Logo(Image) also.

help needed.
Akshay

[Kal_Lam]

Could you kindly share with us a sample of your issue through a screenshot. This should help us provide you with better support.

[stephanealoo]

Hi,
When you add note questions to your form, these will be exported as empty columns on your data. Unfortunately there is no way to remove them from the data export. This also applies to the logo column.

You can however see the workaround discussed in the following topic

Exporting Data without Note field

Hi @khasaab, KoBoToolbox at the moment does not have an option to filter selected variables and download and download them. However, you could try the following workaround: Please ensure the following before trying it out in the main project itself: Try the steps outlined below in a dummy project so that you are able to perform the steps outlined below and your real project does not get affected. It’s better to try this only if you have completed the data collection process (as trying it out…

Stephane

[sevavardhini]

Thanku…
Well Im in the middle of developing the form prior to deploy in field. so for as suggested i can implement the remedy after completion of survey . will try this and get back to u
meanwhile scripting in excel would give what we want… has anyone developed an excel module ?

[stephanealoo]

Hi,
On your last query

@sevavardhini

has anyone developed an excel module?

There are lots of material around working with VBScripts on excel, I would suggest you run an internet search and you should be able to accomplish quite a lot,

Stephane