Hey there, I’m trying to build a sort of verification system for my users and I’m really struggling with the workflow to make it work. I’m hoping someone can help point me in the right direction.
(For context, my app is for political campaigns. I want to provide users with verification codes to prove they are the candidate they say they are. So if a user enters a verification code that is assigned to a Candidate (thing), that Candidate is added to the User’s List of Candidates (list of things), thereby verifying that user is the candidate they claim they are)
Ideally, something like this happens:
- WHEN User hits submit button & their verification code Input is found in the Candidate’s verification code field
- Add the Candidate(thing) that contains the matching Verification Code to that User’s List of Candidates
But I’m having trouble figuring out how to make that happen in Bubble. I almost need something that would be similar to VLOOKUP in excel.… Find Row that Contains X and return Y from that row. Can anyone help me figure this out?