User row NOT FOUND for some users

Ask for Help
1

Hello, hope somebody of you has an idea where my error is coming from…

  1. In my app, users have to register first (“users”).
  2. I want the app to display some public user info, so I created a “user profile” with a relation to the “user”. The relation is done through row ID.

So far, so good! In my app, teachers create courses and add students to them (with a public “user profile” which contains a random cartoon image and a random name, so everything anonymous).

  1. In order to CREATE the “user profile” I created a workflow: When a user signs up for a course for the first time, a new user profile is created and linked to the user. In the workflow, I add the row ID of the “user” to the new “user profile”.

Here comes the error: The user’s row ID does not exist (yet?). For some users, there is an error. For others, everything works. You see that in the screenshot enclosed.

  1. I am also updating the “user” with the image of the “user profile” in this workflow. Because the user image cannot be a lookup column, as you know. Same error: User row does not exist.

How is this possible? Does it take some time for the user row to be accessible? I added 2 seconds in the workflow and that does not help. Also, I am working with Glide tables only.

Bildschirmfoto 2024-12-05 um 11.32.19
Bildschirmfoto 2024-12-05 um 11.32.191980×990 135 KB

2

So you have a public table in addition to a normal users table? Only students would be added to the public table, but they will still be added to the normal users table?

Does the error happen at the set column values step? Do you set it to write through a relation, or something else?

3

Yes, both normal users table and another added table.

Here is the error in step 4 in detail: When a user joins his/her first course, I want to update the user table. But Glide does not find the user’s row. No relation, just the built-in function.
“Set column values: No row to set values in.”

Bildschirmfoto 2024-12-08 um 19.09.52
Bildschirmfoto 2024-12-08 um 19.09.522200×884 106 KB

4

Has that user logged in at that point? I notice you’re adding a row to the Users table just before that, so I’m not really sure that user has logged in.

The “User profile row” should only work if the user has logged in.

5

Yes. My app requires login.

(The first step in the flow is not the user’s table but the “User Profile” which is the table linked to the user table. Sorry for the confusion.)

6

So it’s adding a row to the table that is your User Profile table?