[Solved] Retrieving an old record in spreadsheet

How can an existing user retrieve his/her username stored in the spreadsheet for the app…this is what I’ve tried so far …

The app will loop through the spreadsheet if current userid from Google firebase matches the one in the spreadsheet and then grab the corresponding Username stored for that ID and then stored it another Variable.
So I account for a feedback to be sure,I mean to check if there’s any error,so I can an error response of (null)

Please help ``

1 Like

Can you provide an example? Your description is not clear to me.

1 Like

When a user signups the first time,they will be required to create their full name which will be saved in the spreadsheet,and their unique id stored too.now lets assume they change their phone,when signin back in as an existing user can be possible because of the Google Auth-signin feature right?
So now i cannot expect them to create another Fullname into the spredsheet.
so i want to check from the spredsheet with the Unique id stored,the users fullname and retrieve it back and store in a Variable to avoid multiple entries by same user

1 Like

i will loop through a base first,if the Unique USERID[from google signin]stored from the previous Signup session =Currenet USERID also grab from the Signin component,and then grab a property of Username stored with unique ID…

I hope that makes sense a bit

Are you trying to do a VLOOKUP @versatile?

Does this help you make progress at all?

3 Likes

Didn’t work out for it

If you use a count with rather than a for each loop then this will be a lot easier to implement

1 Like

Am not sure I quit understand that,or how to do it

You’re just going through the list one item at a time right now. There’s no (easy) way use the item to look up a value in an adjacent column.

If you swap to the “count with i” approach then I corresponds to the row number so you can retrieve values from any columns in that row.

Did you have a chance to work through the tutorial I linked you to previously?

2 Likes

I just found out how to do that,
I called the spreadsheet,and then loop through the base, saying if CurrentUserID stored in a variable=any ID in the spreadsheet column for IDs,it should then grab the property of the user’s username stored in previously to the spreadsheet and store it in a variable that will reveal it in the App
Below is the blockings

1 Like