I’m building an assessment app. The “Begin Assessment” button is supposed to:
Clear the user’s previous answers and scores.
Set Current Question ID (in the Users table) to the Row ID of the first question (pulled with a Single-Value → Risk Assessment → Row ID → First).
Navigate to the Assessment Questions screen, which is filtered by Row ID is User Profile › Current Question ID.
Everything works except one stubborn glitch: as soon as Glide writes the Row ID into Current Question ID, a “1” is prefixed in front of it (e.g., wr730NZgRjSPJ8CRcHo.Ow becomes 1wr730NZgRjSPJ8CRcHo.Ow). The extra “1” breaks the filter, so the assessment never resets to Question 1.
What I’ve tried (with no luck):
Converted the Users table from Google Sheets to a Glide Table (“Copy of Users”) and set it as the active User Profile table.
Verified Current Question ID is a plain Text, user-specific column (no template, math, or default).
Confirmed First Question Row ID pulls the correct ID (no “1”).
In the workflow’s Set Column Values, Row = User profile row, set Current Question ID = First Question Row ID, clear Score/Response.
Deleted the old Users sheet column and any default values.
Tested with a brand-new user account; the “1” still appears the instant the workflow runs.
It acts as if Glide is coercing the Row ID into a number first, then concatenating it back with the string. I can’t find any hidden logic that adds that leading “1”.
Has anyone seen a Row ID get prefixed like this, or know where else Glide might be transforming the value? Any advice is hugely appreciated—this one character is blocking the entire assessment reset.
The reason I’m using the “First Question” variable instead of directly assigning the Row ID is because I needed a dynamic, reusable way to target the first question in the assessment — without hardcoding that specific Row ID every time.
“First Question” is a single value column I created to hold the Row ID of the very first assessment question (from the Physical Security-Risk Assessment table). That way, if I ever reorder or replace the first question, I only need to update that single-value field — and everything else stays functional.
So in the workflow, when the user clicks “Begin Assessment,” the app copies that Row ID value from the First Question column into the Current QID column of the Users table — which then drives the rest of the assessment logic.
Let me know if you think there’s a better way to approach it though — I’m definitely open to cleaning this up if there’s a simpler method.
Two separate values are being concatenated here. A boolean which is probably either a 1 or 0, and a RowID. Neither of which are the actual ‘First Question Row ID’ column that is intended to be used.
I replaced the old boolean + RowID reference with a clean Single Value → First → Row ID column called First Question Row ID (non-user-specific, text).
In my Restart Assessment workflow I now set Current QID = User › First Question Row ID and clear the Response / Score columns.
On first load after publishing, the reset does work on my phone (the assessment starts at Q1).
But after completing the assessment and clicking “Begin Assessment” again, it stays on the last question instead of jumping back to Q1.
Any idea why the user-specific values wouldn’t be clearing?
– Current QID, Response, Score, and Section Score are all user-specific columns.
– The workflow’s “Set column values” step shows Clear value for each of them.
Is there a better pattern for fully resetting the user profile row after submission?
Appreciate any insight!
Thanks for the reply. In the workflow, the “Begin Assessment” button is supposed to take the user to the first question (Q1), but instead it’s landing on the last question they previously viewed. I suspect Glide is still referencing the last row or question ID from the previous session.
Here’s what I have so far:
The assessment questions are in a separate table (not a collection).
Each question is displayed on its own screen using screen filtering.
The “Begin Assessment” button uses a Go to tab or Go to screen action.
There’s no explicit reset of the question flow or navigation state in the workflow.
I can share workflow screenshots if needed. But before I do that — should I be manually resetting anything like the screen’s row ID or using a “set column value” to point the user back to Q1?