I populate list of items by using search('file_name')
In my csv file a column name DateOfValidity provide a date that i would like to use
Only if current date is before this date of validity the item should be populated
What ODK tool and version are you using? And on what device and operating system version?
Odk 1 v1.17
What steps can we take to reproduce the problem?
What you have you tried to fix the problem?
I try in the apparence column of xls form
Today dateOfTheDay
Select_one Item choose your item search('File_name','DateOfValidity','>${DateOfTheDay})
it looks like there's some issues with implementing the functionality you're trying to use (dynamic selects from pre-loaded data) as noted by @LN in this issue:
@Fabienne35 how many options are there? can you include them on the choices sheet of the form itself instead of in an external file and follow the example in my first post?
In fact the datas comes from an other software which is updated every weeks and the number of items could be huge in certains circonstance (>1000)
so I need to figure how to filter when the stock file is generated I forget having an real time filtering
Thanks