I understand this question may be a bit complicated. If there are any forum posts, videos, or classes from the app academy that may be of better use, please let me know. I am also familiarizing myself with Airtable, in the case that may provide a better environment for my idea.
I am creating an app with two collections: Users and Questions. Questions are either answered with “yes” or “no.”
I have it designed such that, when each user answers a question with yes, that question will be added to their column designated for such questions (as of now, it will move to the next question if they answer no). For users, let’s call this the “yes” column - which is a relationship between collections users and questions
For the logged in user, I want to find a way to produce/locate a separate user (a current user) whose relationship with questions is most similar to that of the logged in user. This current user would either show up in a separate column for a given user in the database, or it would show up in a custom list of users in the app.
user 1 “yes” column: (question id numbers) 1, 3, 7, 9, 10 [current user: user 2]
user 2: 1, 2, 3, 4, 8 [current user: user 3]
user 3: 2, 4, 8, 9, 15 [current user: user 2]
In this case, user 1 shares 2 questions with user 2 and 1 question with user 3, therefore the current user for user 1 would be user 2. However, User 2 shares 3 questions with user 3, so user 3 would show up for them. Even though User 1’s current user is user 2, user 2 has a different current user.
Any advice is much appreciated!