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.
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