- 8
- 80 924
Desmond Tech Classes
เข้าร่วมเมื่อ 22 ส.ค. 2016
Content Creator
HOW TO LINK KOBOTOOLBOX TO MICROSOFT EXCEL
#excel #kobotoolbox #odk #xlsx #howto #microsoft #microsoft #microsoftoffice #microsoftexcel #link
มุมมอง: 15 328
วีดีโอ
HOW TO RESTRICT DATE OF ENTRY TO SPECIFIC RANGE IN ODK OR KOBOTOOLBOX
มุมมอง 1.6Kปีที่แล้ว
#odk #kobotoolbox #xlsx #excel #howto #youtube
Learn how to convert texts into Upper case, lower case & proper case in excel in less than 3 minutes
มุมมอง 143ปีที่แล้ว
#microsoftexcel #microsoft #excel #uppercaseletter #lowercaseletters #propercase #microsoftoffice #officeexcel
Cascade select questions in Kobocollect and ODK
มุมมอง 4.8Kปีที่แล้ว
#kobocollect #kobotoolbox #odk #cascadeselect
Create your first Kobotoolbox project using XLSform in less than ten minutes: Lesson 2
มุมมอง 41K2 ปีที่แล้ว
#kobotoolbox #kobocollect #xlsforms
KOBOTOOLBOX FOR BEGINNERS
มุมมอง 6K2 ปีที่แล้ว
#odk #kobotoolbox #learnODK #IntroductionToKobo #kobo_kanaeru #xlsx #xlm #xls
HOW TO SELF-UPDATE YOUR SIM REGISTRATION ONLINE
มุมมอง 1K2 ปีที่แล้ว
HOW TO SELF-UPDATE YOUR SIM REGISTRATION ONLINE
could you share the excel form with me please
I tried but I failed thought I tried to copy every step.
This is the most helpful material I have found so far, big up!!!
Thank you sir, share with others the link to learn as well.
Nmekupitia nipitie pia ❤
Hello, is it possible to connect it but using XML values and headers instead of lables? thanks!
can't find sss_1
I'm trying to get import data from KOBO but it's error
check your form, ensure that you have at least one successful entry before you import
Christiansen Mill
Alysa Island
Rowena Well
Emie Forest
Mayer Canyon
Lavon Cliff
Thank you, Desmond. This is very helpful. But how I link kobotoolbox to excell for several sheets which are create from repeate function
Great suggestion!
Beth Cliff
Daniel Mountains
Octavia Turnpike
awesome
Thank you, Desmond. This is very helpful. please keep going
Thank you, I will
It can update real time data?
Is there anyone who can help me with my ODK collection? I am facing that can't submit the entries.
Very effective tools. Thank you for sharing.
Limit participant from selecting future date in kobotoolbox
Link for lesson 1?
If new submissions were received on kobo, would I be able to get them only by refreshing the query in Excel?. Or is this for the data that has been submitted before exporting the Excel file from Kobotoolbox?
refresh
great 😃
the video is blunt, not clear to seee
will improve on imaging and videography
Thanks a lot, its wonderful. However, if we put xls in place of csv, it will show garbage like text. Thanks anyway, csv worked though superb.
it supports csv for now
How about ordinary exporting and download
check my next video
What about if my excel not support Web and I have copy share to my friend could Connect excel. Same Link I have share or need to configure API kobo to his pc
It will still work
Thank you Bro, it is very helpful
Hi @Desmond Good lesson I need some assistance on the same will be happy to get a short lesson
contact via Email. desmondwafula01@gmail.com or whatsapp +254715489011
Is it possible that we enter data in Excel and it automatically updated on the KOBOtool box? I have list of data in Excel and I want to enter in the Kobotool box using automated system
Sure, you can in my next video I will be working on such a project. Subscribe to get tuned
Can you help me solve the " Resource at URL contents exceeded maximum size" error
This means that the file that was uploaded exceeds the recommended file size in terms of mbs(storage). It is advisable that when creating a survey sheet, you restrict on the maximum. It is recommended that upload files should not exceed 10mbs. For the free servers.
Thanks for the video! Just a friendly advice, the music in the background is a little distracting.
If your last line is "when new data is added on kobo all you have to do is to press refresh" then this is Wonderful. 😊
Yes. All you need do is to press refresh
you simply refresh to get new data
But when new entries are added, its not posting on to google sheets. how to deal with that??
The challenge with google sheet is that it is slow to process and update data. Check out my video on Linking with microsoft Excel It solves your problem.
Hello, i am a programmer but rrecently i landed an opportunity of a data entrant at an organisation but it is time consuming as a person who wants to be a good programmer and i cannot miss this opportunity being that i would be having so money in the pocket as i learn programming, for those that have used this tool for long, am i able to use the API to fetch data from the spreadsheets directly to the corresponding fields in the kobo toolbox, thanks
great
Good evening. I really appreciate this video. Please I need your guidance on what I need to do to skip a section if a response to a previous question was chosen, and otherwise to continue to another section.
check my video on skip logic
Hi Desmond, thanks for the video. it is very clear. is there a way to do this without checking the "anyone can view submissions made to this form " option? This is imporantat for sensitive data. thanks
Yes, you can restrict to specific people
Thank you, Desmond. This is very helpful.
great to hear
Thank you it works for me. However is there a way I can also link the repeat sheet? I have tons of repeat and I would like to add that to my google sheet. Also is there a way to make this dynamic so that everytime I submit a new data it will be reflected on the googlesheet?
Yes there is but I would advise that you use Microsoft excel. Check my video on how to link using microsoft excel
Please help me on how to create Kobo tool that can't be use without entering the Identity name
Hello reach me via whatsapp on 0739704173
where could I have gone wrong?
Am getting error message when uploading
check keenly if you miss those quotation marks or comma
Thank you
is there any way to edit bulk data of kobo tool in excel and connected it to kobo server directly?
Hello friend, do you mean that you have pre-collected data in microsoft excel and you want to upload into kobotoolbox so that one can simply edit from there and submit again?
@@desmondwafula5246 I currently have a substantial dataset that has been previously submitted into KOBO Tool through field survey work. I am now seeking to make bulk edits to this submitted data. However, I am encountering difficulties as editing bulk data in KOBO Tool is not as straightforward as it is in Excel. I am inquiring whether there is a method available that would allow me to edit the bulk data in Excel and subsequently update the edited data on the KOBO Tool server. Your guidance on this matter would be greatly appreciated. Thank you.
@@desmondwafula5246 Hello! I am waiting for your reply on this.
@@mahbubanik2786 There is a technique called pull data. You convert your edited data into CSV format then upload it to Kobotoolbox. Unfortunately. This technique can be used when making follow-up or sampling for respondents that previously filled the form.
Your video is too fast and hard to follow at once. but thanks
Hello sir I will create the slower version. I will share the link soon
Hello, I using share account Kobo tool box but I created new account I can’t add user it show failed Permission. I let it be know why it show. Only owner have access Add user ?
check on add user settings
brother how to skip a question if you select from option I will give you an example the question about status a.married b.single c.widowed if I select the b.single the other questions will hide this is the question must be hidden of I select the single from the option What is your spouse job?
In MY NEXT VIDEO I WILL TAKE YOU THROUGH THIS