Make a relation from a single cell array

I am very new to making apps and to Glide App maker in general. I am trying to submit a form with Chose Components and other components. My problem is that I cannot both submit both the names of the participants in the “Participant Names” column and the participant id in the “Participant ID” column. Right now it is writing an array, inline list to the Participant ID column.

To solve this issue I have tried to 1. create a column to make an Split-text Array column, 2. Make another column as a relation to that Array column with the User table’s ID column, 3. Finally, I created a lookup column to display the names of the participants. (I tried to just create the relation directly from the Participant ID column with my User Table > Participant ID column, but it will not read the array that is posted). The problem with this solution is that the relation is taking each participant id and writing it down 3 times. If I have 2 ID numbers in the array it will have those 2 ID numbers written three times.

Please help!

Question: Why do you need both? The IDs would normally be sufficient. You can split those, relate the resultant array to your users table, then take a joined list of names via that relation.

2 Likes

Thank you for the reply Darren!

I want to be able to see the participant’s names so that the users are able to see their data like a notebook. Since I am so new to this I may need the steps a little more broken down on how to accomplish this. What is it that you are saying I should do to solve the problem?

Since you already have a relation, you can display data from the related table using a collection sourced from the relation.

Thank you Jeff for the reply!

So you are saying that when I display the data to the user I will be able to provide the user with the participant names when I recall the data using a Glide component? If so, that make sense. However, the relation is part of the problem. As you can see it is displaying 3 sets of the same participant id’s instead of just on set.

However, I would also like the central Google Sheet (in which I hope to be able to establish an automatic sync with the Glide table) to be updated with all the data for the admin. The Glide table that these participant id’s and participant names live, is the place where I will be looking at the entirety of the data whereas individual users will only be able to see their particular entries.

I figured it out! I am sorry to sorry such a puzzle without all the information. I noticed that somehow I imported the data into the User table three times. So the relation was pulling up the same ID three times because it was in the column three times!! So, I deleted the triplicates and now it works. Thank you for taking a stab at this!

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.