Implementing Rotational Display Logic for Sponsored Jobs in a Specific Category

galliaeran · 2024-09-19T16:05:29.558Z

Hi Bubble community,

I’m working on a job board app where users can pay to sponsor their jobs for increased visibility. I want to implement a feature where, if multiple people sponsor their jobs in the same category (e.g., “marketing”), these jobs are shown on a rotating basis.

For example:

User A and User B both sponsor their jobs under the “marketing” category.
When a user visits the page showing jobs in this category, I want to alternate between displaying User A’s and User B’s jobs. On one visit, User A’s job is shown, and on the next visit, User B’s job is shown. The rotation should continue as long as there are multiple sponsored jobs.

Zeroic · 2024-09-21T10:31:59.076Z

Hey! 2 approaches that I have in mind:

Have an isSponsored boolean field in your Job table and as your data source for the group that will show the job, use the :random item operator on the isSponsored jobs - Operators and comparisons | Bubble Docs
Have a Sponsored count field in your Job table and increment whenever a job is shown in the group to a user. The data source for the group in this case can be a sponsored job with the least count value (keep in mind that this would use the sort by operator which works up till 50k items in the DB) - Operators and comparisons | Bubble Docs

Let me know if this is helpful

system · 2024-11-28T16:06:24.297Z

This topic was automatically closed after 70 days. New replies are no longer allowed.