hope you all are safe and well during this pandemic.
I am required to pull a set of choices from an external csv file, for creating a select_one question in my form. I came across the ‘search()’ function with the following syntax :
search(csv file, ‘matches’, column name to be searched in csv file, text to be searched in that column, name of filtering column in csv file, text to filter the column)
I have 2 queries here:
- In my project, I don’t need any text to be searched in the column. If my filtering criteria filters 10 rows of data, I would require all 10 rows to come as choices in my form. Is this possible? I have tried by excluding parts of the syntax I do not need, but this does not seem to work
- Can multiple columns be filtered with different filtering criteria?
Could someone get back at the earliest on this?
Thanks in advance,