Premium and normal user

💬 App Building
1

Hi i want to build a dashboard base having graphs like world map graph/geographical graph on retool
. My app consists on two types of users (normal and premium) both have different content like normal user can only veiw top 10 entries on table remaining entries are hidden but visible to premium users . Similar way normal user can see limited stats like 2 out of 4 graphs
Also i want to integrate stripe
Are all these possible if yes
Can i have little guide regarding all these
Thanks

1 Like
2

Hi @Ibraheem_Gill, Welcome to Retool Community,

You can achieve all these functionalities using Retool along with Stripe integration for payments

1. World Map / Geographical Graph on Retool
Retool supports embedding visualizations, including maps and geographical data, by integrating libraries like Google Maps, Mapbox, or using APIs to fetch geographical data. Here's how you can add a world map graph:

Using Mapbox or Google Maps :

  • Obtain API keys from Mapbox or Google Maps.
  • Add a Retool Map component and configure it to display data points like markers or regions on the map.

2. User Types (Normal and Premium) with Conditional Access

  • User Authentication : Integrate Retool with an authentication system (e.g., Firebase, Auth0, or a custom backend) to differentiate between normal and premium users.

  • Conditional Visibility :
    Use the hidden property of components to show or hide elements conditionally.

For example : {{ currentUser.type === 'premium' }}
This will make a component visible only to premium users.

Data Restriction :

Use SQL queries or API endpoints to fetch limited data for normal users and full data for premium users.

For example :

SELECT * 
FROM your_table
ORDER BY created_at DESC
LIMIT {{ currentUser.type === 'normal' ? 10 : null }};

3. Graph Visibility Based on User Type

Create all graphs and use the hidden property based on user type :
Normal users: {{ currentUser.type === 'normal' && graphIndex <= 2 }},
Premium users: {{ currentUser.type === 'premium' }}

Use Retool Tabs or Containers to organize graphs and conditionally render them.

4. Stripe Integration : Utilize Retool's API support to integrate with Stripe for payments and user upgrades.

Feel free to ask if you need further assistance or have additional questions. We're here to help!

5 Likes