Trouble getting the Choice column to write to the correct row of a spreadsheet

Hey everyone! This might be a bug, but I’m more inclined to think that I’m having a massive brain fog moment. I have a choice field. When the user selects one of two choices (client or coach), the selected choice should write to that user’s User Type column in Google Sheets/Glide. Unfortunately, that’s not happening–in fact, nothing happens at all.

Edit: actually, on closer examination, the Choice column is writing to the spreadsheet–it’s only that it’s writing to the very first row/user, not to the current user. Here’s a Loom video showing what I mean.

For posterity, here’s a screenshot of my original configuration (as @Uzo and @Mark_Turrell pointed out, I was originally writing to the same column as the source of the data).

(upload://tJrR457pRdi5PevM3N1cjONAljX.jpeg)

Normally I’d have:

  1. a lookup sheet (usually in Google Sheets / GS)
  2. a column for your choice options in the Lookups
  3. I use the Lookup sheet as the Source, and pick up values from that column
  4. the the ux for the choice component, you wrote the data to your ‘User Type’ column

I hope this helps :slight_smile:

from what i see in the picture, you are writing data to the same column as a source of the data… this is why there is no change

@Uzo @Mark_Turrell Thank you both for the insight! You’re both correct, but I’m still seeing a strange issue occur. So, update: I was originally incorrect, and the Choice column is writing to the User Type column–however, it’s writing to the very first row, not the current user’s row. Here’s a Loom video showing what I mean. Do you have any ideas?

Filter the screen by signed-in user.

4 Likes

Aaahhhh, you are completely correct! I knew it was something very simple I was missing. Thanks, @shchc !

2 Likes