# Data collection conundrum **URL:** \ **Category:** Ask for Help\ **Created:** [June 12, 2023, 4:42am UTC](https://community.glideapps.com/t/data-collection-conundrum/62670 "2023-06-12T04:42:48Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![PRutledge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prutledge/32/60297_2.png) [@PRutledge](https://community.glideapps.com/u/PRutledge)\ **Post date:** [June 12, 2023, 4:42am UTC](https://community.glideapps.com/t/data-collection-conundrum/62670/1 "2023-06-12T04:42:48Z")
I created a simple data collection app for a disaster relief group with many volunteers. The data tables cross reference each other to set up different lists (ie. list of all volunteers, list of volunteers by disaster, list of admin). The problem I am having is when you select two sets of data (ex. select multiple disasters because you volunteered at more than one), which is an option in the app creator, that person falls off all of the lists of people connected to those two disasters. They no longer show up on either list unless you go back and only select one disaster. (they don’t leave the data tables, only the lists on the app. Hopefully I’m explaining this well. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 12, 2023, 4:52am UTC](https://community.glideapps.com/t/data-collection-conundrum/62670/2 "2023-06-12T04:52:44Z")
Sounds like you just need to setup an appropriate relation/query. When a volunteer adds themselves to a second Disaster, does that create a new row in your table, or is an existing row updated? Can you show how these entries appear in the Glide Data Editor? ---
**Author:** ![PRutledge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prutledge/32/60297_2.png) [@PRutledge](https://community.glideapps.com/u/PRutledge)\ **Post date:** [June 12, 2023, 4:59am UTC](https://community.glideapps.com/t/data-collection-conundrum/62670/3 "2023-06-12T04:59:48Z")
It’s an existing row update. ![example1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82ed3c2f0046aa48e5d294ad4d6fa040f1c31a4a.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 12, 2023, 5:13am UTC](https://community.glideapps.com/t/data-collection-conundrum/62670/4 "2023-06-12T05:13:35Z")
Okay, cool. Here is what you can do: - Add a [Split Text](https://www.glideapps.com/docs/reference/computed-columns/split-text-column) column to your Volunteers table that targets the Disaster Event column. This will create an array of events. - Add a [multiple relation](https://www.glideapps.com/docs/reference/computed-columns/relations#multiple-relations) column that matches the array column with the Disaster name in your Disasters table. - You can then use that multiple relation column as the source of a Collection on your Volunteers detail screen Note that the above will break if you have a Disaster name that contains a comma, of if you edit the name of a Disaster. A more robust approach would be to add a [RowID](https://www.glideapps.com/docs/reference/computed-columns/row-id-column) column to your Disasters table, and write that RowID into your Volunteers table. ---
**Author:** ![PRutledge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prutledge/32/60297_2.png) [@PRutledge](https://community.glideapps.com/u/PRutledge)\ **Post date:** [June 12, 2023, 1:51pm UTC](https://community.glideapps.com/t/data-collection-conundrum/62670/5 "2023-06-12T13:51:38Z")
Awesome! I had an existing reaction column that I needed to select [match multiple] on. Just needed to create a multiple relation column and point the reaction column in the right direction. Thanks tons! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 13, 2023, 1:51pm UTC](https://community.glideapps.com/t/data-collection-conundrum/62670/6 "2023-06-13T13:51:49Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.