Referral Program

Hi everyone, I want to add a Referral Program to my app so when someone refers someone they get 200 points and the person who signs up with the Referral link gets 100 points. How do I set that up?
@erwblo

Thanks

Create a unique referral code for each user (or use their Row ID).

When someone signs up, ask them to provide this code, which goes in a Referral Code Column and 100 in their points Column.

Try and ITE column where if someone uses their matching User ID, add 200 points to their column.

Is their a video on this?

Not that I know of.

@Joe_Gabriele Can you give me the instructions on how to exactly make it?

is better if you have a deep link to users screens and they can share that link, this way whoever comes to that link and click sign in from it, you will know who referred it

Do users have a public profile for people to view? Technically it doesn’t matter really.

This is what I did:

My User sheet has Row ID’s, which is basically a unique code assigned to each user, automatically generated by Glide. I use these Row ID’s as their referral code because they are all guaranteed to be unique.

I allow Users to share this code with new people, if they so choose. When a new person signs up, they have the ability to provide a Referral Code. This is when they can provide the unique user ID.

That entry is captured into a Referral ID column in my “New sign up” sheet. From that sheet, I can see if any new users used a referral code at sign up. I then relate that Referral ID to that existing User so I know who the referrer is.

As for adding points, you’ll probably have to figure out how to use the Math Column to add points to each respective user (200 to referrer and 100 to new).

1 Like

@Joe_Gabriele Can you give a screenshot on how you did it?

I created a Button on the Public Profile (opt in) called “Get Your FREE Bio Link”.

Screen Shot 2021-05-09 at 10.39.34 PM

That Button has custom action that copies the User ID of the Public Profile User and opens up my New User Application.

Screen Shot 2021-05-09 at 10.39.48 PM

During their initial application, I ask if they have a Referral Code, which is the User ID that was copied via the link. If the individual was sent a Referral Code via text or email, they’d have to paste it in manually.

Screen Shot 2021-05-09 at 10.40.11 PM

Upon Submitting their application via Button, I used a custom action based on if someone used a Referral Code or not.

Screen Shot 2021-05-09 at 10.40.42 PM

I have 2 sheets, 1st is to capture all Referrals only, where I add the Referral Code to the corresponding Column.

Screen Shot 2021-05-09 at 10.41.12 PM

And the 2nd Sheet is just all New Applicants, where the Referral Code is also captured.
Screen Shot 2021-05-09 at 10.41.26 PM

Now that you captured which new user used a Referral Code and are able to match up that Referral Code to an Existing User, you can then credit the 100 or 200 points respectfully to each user.

I don’t use points so you’ll have to just try to figure it out yourself or ask someone who might know.

Hope this helps. And this isnt the only way you can implement a referral program and might not be the best way either. I just did this over the weekend and it seems like it will work for my use case lol

5 Likes

How do you edit the sign up page?

You make a tab called “Sign Up” with visibility set for only non-signed in users, add Text Entries and a Submit Button that Adds a Row to your User’s page to create the new User.

1 Like

Will that automatically delete the old sign up tab?

1 Like