Community
Select to view content in your preferred language

Filter INBOX based on field value and csv

704
0
07-21-2023 01:59 AM
CherylWheeler11
by
Regular Contributor
‎07-21-2023 01:59 AM

 

Hi, I am looking at trying to filter an INBOX based on the relationship between the logged in user and a field in a csv file.

The csv file looks like this:- 

CherylWheeler11_3-1689929104768.pngCherylWheeler11_3-1689929104768.png

In my survey I have a question that selects the site area using a choice list

CherylWheeler11_2-1689929063509.pngCherylWheeler11_2-1689929063509.png

 

So I want to only list those surveys which have the same area name as that stated next to the user in the csv file for the user logged in. For example, for User1, the INBOX would only list surveys in 'east'.

I was looking at using pulldata with the csv to create a list of only those users in the area selected, then concatenating the list of users into a variable. My idea was to then use a LIKE statement in the INBOX query to interrogate the ${username} and the concatenated variable.

CherylWheeler11_4-1689929608445.pngCherylWheeler11_4-1689929608445.png

CherylWheeler11_5-1689929635980.pngCherylWheeler11_5-1689929635980.png

My question is - how do I concatenate the name field values from the filtered list from the csv file?

Thanks. 

 

 

 

0 Replies