In this video, I demonstrate how to generate short, pretty and unique codes per user to be used as IDs or invite codes and how to use these codes to create a referral system for your app.
You should be able to do that with a relation (to find referral codes that match your own code), then a rollup to count, and a math column to multiply the points (if you’re not only awarding 1 point for 1 referral.
This should be some if then else columns based on the final math column above.
Yep! Perfect possible. I show in the video how to roll up the number of invites. Use a math column to do a multiplier of points per referral. You can even create a table of referral rewards with minimum points needed and give out rewards/badges based on the table. Lots of possibilities!
But do you know how to do a link with the referral code? What I mean… Imagine if some user share a link to me, and when I complete my profile the user automatic get the referral bonus. Is it clear? If not I can explain better!
Unfortunately, Glide doesn’t let you populate input components with URL parameters. Best you could do is put the referral code in the message and when the user signs in, they’ll need to type the code.
Thank you for taking the time to make such a detailed tutorial, you can’t imagine how much you helped me to improve my application in pages. Best regards
There is a risk that 2 or more simultaneous users have the same invite code. So it is not a unique code. Set value and increments are not immediate and and can mess the codes…Right ??
More probably to win the lotto. This is an example of unique code i am using
39e2010c-Hey
You can also add 2 first characters of user s name or similar. With the Single Value method I used to find regularly simultaneous users with same code…and it is a mess…
I use first name +3 digit random number generated for my referral codes. Requires fewer digits while making them personalized. Of course can simply add another digit or two as the app grows and if worried about duplicates, but for me it’s not catastrophic (and it’s only 1/1000 chance) if two people with the same first name have the same code, and hence combine to share referrals and credit for the referrals.