# Dynamic search to create a list **URL:** \ **Category:** Support\ **Created:** [May 17, 2022, 9:25am UTC](https://forum.getodk.org/t/dynamic-search-to-create-a-list/37691 "2022-05-17T09:25:17Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Lucas\_Hayraud](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/lucas_hayraud/32/18035_2.png) [@Lucas\_Hayraud](https://forum.getodk.org/u/Lucas_Hayraud)\ **Post date:** [May 17, 2022, 9:25am UTC](https://forum.getodk.org/t/dynamic-search-to-create-a-list/37691/1 "2022-05-17T09:25:17Z")
Hi to every ODK users ! I'm starting with ODK Collect and I'd like to create a dynamic search from an already existant list (from Excel). I'd like to know if it's possible to create a list on ODK by tiping the name of a species (for example) and then add it in a table so that the others fields/colums fill automatically. Hope I'm clear enough to receive help ! Thank you, Lucas ---
**Author:** ![mathieubossaert](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/mathieubossaert/32/6131_2.png) [@mathieubossaert](https://forum.getodk.org/u/mathieubossaert)\ **Post date:** [May 17, 2022, 12:14pm UTC](https://forum.getodk.org/t/dynamic-search-to-create-a-list/37691/2 "2022-05-17T12:14:05Z")
Welcome on the ODK community forum @Lucas_Hayraud . When you'll get some time, please [introduce yourself here](https://forum.getodk.org/t/introduce-yourself-here/6671) . Could you give some precision about what you want to achieve ? Do you want to select a species in a list and then get some information from the reference dataset like the phylum / class / order or any other for the selected taxa ? ---
**Author:** ![Lucas\_Hayraud](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/lucas_hayraud/32/18035_2.png) [@Lucas\_Hayraud](https://forum.getodk.org/u/Lucas_Hayraud)\ **Post date:** [May 19, 2022, 10:15am UTC](https://forum.getodk.org/t/dynamic-search-to-create-a-list/37691/3 "2022-05-19T10:15:17Z")
Thank you Mathieu ! I'm gonna try to be as clear as I can... So I'd like at the end to have a list of species I saw in the field. And this list would be created by starting typing the first letters of a species, it proposes from these letter the correspondant species and by clicking on the right one, add it to the list. In addition to that, once the species is found and added to the list, the fields such as her protection, but it works for the phylum / class / order as well are automatically filled. Once I'm done I wish I could export the table in a CSV on XLS format. Hope I'm clear enough... ---
**Author:** ![mathieubossaert](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/mathieubossaert/32/6131_2.png) [@mathieubossaert](https://forum.getodk.org/u/mathieubossaert)\ **Post date:** [May 19, 2022, 11:56am UTC](https://forum.getodk.org/t/dynamic-search-to-create-a-list/37691/4 "2022-05-19T11:56:15Z")
Yes it is clear 🙂 You can achieve all of it. I do not know what you've already try with xlsform so maybe it will be unclear... Here is a recent discussion about searching in a list with first letters of the species name and about creating a summary list : > [@Filter list of floristic species with 3 first letters of name](https://forum.getodk.org/t/filter-list-of-floristic-species-with-3-first-letters-of-name/37580): > > 1. What is the issue? Please be detailed. Hello to all ODK community and support ODK grinning, I am a GIS engineer in Dynafor unit in the research organization Inrae in France. And I and some other Inrae colleagues have been trained during 2 days at the end of April2022 on ODK by the famous and talented Mathieu Bossaert from CEN Occitanie France. Thanks to him and happy to join you blush. Excuse my English which is perhaps approximate. I am in the middle of elaborating my first form to all… Maybe this form will inspire you About calculating a value relative to the selected item in the list, this part of the doc will help you : > **[Form Logic](https://docs.getodk.org/form-logic/#id27)** > > ODK Collect supports a wide range of dynamic form behavior. This document covers how to specify this behavior in your XLSForm definition. Form logic building blocks: Variables: Variables reference ... ---
**Author:** ![Lucas\_Hayraud](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/lucas_hayraud/32/18035_2.png) [@Lucas\_Hayraud](https://forum.getodk.org/u/Lucas_Hayraud)\ **Post date:** [May 19, 2022, 1:03pm UTC](https://forum.getodk.org/t/dynamic-search-to-create-a-list/37691/5 "2022-05-19T13:03:32Z")
Alright, I'll check these links, thank you ! Coming back soon to you