Reading data from a recently submitted form offline

Filling in a new instance of a form completely offline How do i locally query from a previously submitted instance of the same form ?

1. What is the issue? Please be detailed.
Filling in a new instance of a form completely offline How do i locally query answer to a question from a previously submitted instance of the same form ?

2. What steps can we take to reproduce this issue?
I have attached excel form and when i try to read data using collect from the previous submitted form it does not work.

3. What have you tried to fix the issue?
I tried a query as follows to read from a previous submitted form

instance('aXv9sWPY5YJpb4XQwdzPyM')/root/data[contains(pname, ${search_name} )]/cnic

4. Upload any forms or screenshots you can share publicly below.
Attached form

aXv9sWPY5YJpb4XQwdzPyM - 2026-06-23T082454.056.xlsx (19.8 KB)

Hi @jurrefws and welcome to ODK!

You can't directly query local submissions. In ODK, we have a separate concept of Entities that can be created, updated and queried offline by forms in ODK Collect. If you have a person/place/thing to collect data about, you would generally save its important identifying characteristics to an Entity. You'd also generally save some status information to help guide a user through a workflow. You can learn more in the documentation. You can use the Ask AI feature in documentation to explore ideas relevant to your specific use case.

I see some references to Kobo in your attached document. Please note that although Kobo does use several ODK components, it's a separate project. As far as I know it does not have a way to query data created offline but you would have to ask them to be sure.