Skip to Main Content
Feature Request FR-2602
Product Area Page Components
Status CLOSED

1 Voters

Implement referral program

lhe Public
· Jun 25 2022

Idea Summary
Automatically generate a referral URL for newly registered user, who can send this URL to friends to attract more traffic, and earn points for himself or herself. 

Use Case
User A registered on my website, the system assigns a USER_ID=1234, the system generates a link https://apex.oracle.com/ref?=1234 This user can send this URL to friends “This is cool, check it out”.  If friends registered on my website and becomes user B (with USER_ID=1235), then user A gets a point (stored in a table), and user B got his own referral URL https://apex.oracle.com/ref?=1235 so on and so forth.

How would you implement this idea? If you are not sure, leave blank.

This idea has been closed due to the lack of community activity during the period since it was submitted.

Comments

Comments

  • jayson hanes Admin OP 3.2 years ago

    Hi, this seems to be a very application specific request and not an APEX feature request? I like the idea of doing this in THIS app perhaps, and we'll consider it. I don't think it would be practical to make this a standard APEX feature somehow though. I'm open to hearing any other thoughts on this of course!

  • lhe OP 3.2 years ago

    Thank you Jayson. The referral code could appear in any name-value pair, ABC=1234, or XYZ=1234. I guess the key is how Apex captures the extra parameters from the URL and store it in session state. Thanks!

  • jayson hanes Admin OP 3.2 years ago

    The thing is, you can already do this in APEX today. If you define an application item or a page item that is set to unrestricted, its' value can be set via url - at which point an application or pre-rendering/page process can be created that checks this value and takes action. Enabling friendly urls in APEX for the app would also make this look exactly as you describe. Give it a shot?

  • lhe OP 3.2 years ago

    I am not aware of this, do you have any youtube video, or documentation of how this works?

  • gabriel.diaz.arias OP 3.2 years ago

    Please put this in the forums not in apex ideas as it doesn't nothing to do with apex itself, just with a specific implementation, this should be closed.

  • lhe OP 3.2 years ago

    Please feel free to close.  Thanks.

  • lhe OP 3.2 years ago

    I am not sure what qualifies as “an idea” or “an implementation”, I just would like to share my thoughts as a user.

    Apex has made many, sometimes dramatic, changes over the last 3 years, most of them made things much easier, which is excellent, if you are a user who has been following along, new features and office hours are probably sufficient, however if you are a newbie, you are simply lost, and sometimes, you see the tricks or tips online, but 5 hours later, only to find out the new feature has made such 5-hr implementation a 5-min job.

    My suggestions (from a user perspective)

    (1) re-start the instructor-led training ASAP, it is seriously lacking and lagging.

    (2) create many small modules that can be used instantly (I heard we used to have many productivity apps). The current idea of having less, but complete or sophisticated apps is toxic, because it intimidates newbies and scare people away, it takes a long time to see anything tangible. e.g. login page with 3 functions (sign up, sign in, and reset password), EVERY SINGLE web-facing application needs this kind of login page, why isn't there a module or sample available for users?  another example is this request – “referral”.  Sure, it is a piece of cake for you gurus, but it is pretty hard for newbies, if people can't get over with the first obstacle, then they might stop exploring altogether.

    I call myself newbie, actually I am not, I am an Oracle DBA for over 20 years, and I used Apex 4 six years ago, I am trying to pick it up again, I am so excited to see so many new and improved features, but at same time, I am overwhelmed by the fact that for many simple task, I have to spend hours (even days) to piece information together.  

    I think Apex is THE best and the future of database centric applications, however, you have to help your customers to use your product.  Another example, look at the Youtube 22.1 office hours videos, most of them have 1K - 2K views, maybe 25% of the views are from Apex developers at Oracle, and I contributed 20 views, then you can see how many people AROUND THE WORLD are using Apex latest version :)

  • jayson hanes Admin OP 3.2 years ago

    hi lhe, we understand and appreciate your comments. I will mock up an example app on apex.oracle.com and share with you soon.

  • lhe OP 3.2 years ago

    wow, really?  that's above and beyond!  I truly and sincerely appreciate it!

  • lhe OP 3.2 years ago

    Hi Jayson,

    There is no instructor-led training either online or in classrooms, can you please suggest to Oracle University to set one up?  Thank you!