Running into another issue and I’m not sure if i should start a new post, or continue replying to my initial question. So i apologize in advance if this is the wrong way..
Current set up & issue
Building an app where users go through a series of multiple choice questions.
I have a games table with approx 50 columns and approx 50 rows of questions (more will be added in the future)
I set up a USERs table with different ROW IDs so each app user has a different experience not linked to any other user
After each multiple choice question, i want a “Next” button to appear which directs to the next multiple choice question, and then another multiple choice question, etc etc.
I am getting stuck creating this component to direct users to the next game/question. I got as far as creating a component, but it only shows the details of the current game when clicked. (Not a new game). The AI has been very helpful up until now for this particular feature.
Generally we suggest opening a new thread if the issue is unrelated. (That’s why I moved the post here).
I would:
Add a rowID column to your questions table.
Add a lookup targetting that rowID column, so you get an array of rowIDs.
Use a find element index column, find the current row’s rowID in the array above. The result is a 0-based list of indexes.
Add a “current index” column to the user profiles table.
Have a screen where the user presses a “Start Game” button that writes 0 to the “current index” column and show a new screen.
Add a custom collection to that screen, target the questions table, filter the row’s index equalling to “current index”.
Next button would increase current index by 1. Previous would decrease. Hide Next when Current index = Max index from the table (use a rollup). Hide Previous button when Current index = 0.
I do not see how/where to find an element index column. I’ve searched all of the available column options, even used the AI to help locate. I see basic, computed, AI, and Integrations (along with few others). But nowhere do I see element index columns.
