Hey guys! I’m stuck on an issue and I was wondering if anyone have any tips or can guide me in the right direction.
I’ve created a functionality where users can save a job from a list of job posts when they click on a bookmark icon. I created a separate database called “Saved Jobs” , and when users click on the bookmark icon to save a specific job, the icon will change color depending on if the job is saved or not. The saved job will be added/deleted on the Saved Jobs database depending on the color of the icon.
I got the functionality working, however my main issue is that multiple users can see everyone’s saved jobs. Currently, all of the saved jobs changes the bookmark icon color for all of the saved jobs in the database, but I just want to show the icon change color only for the ones that the current user has saved. The database contains every user’s saved jobs, but I want each user to be able to see only their own saved jobs, and not everyone else. My Saved Job database has a Created By field that differentiates different users that saved the job, which I thought might be useful to filter the saved jobs by each user, but I am not sure how to filter it in my workflow.
I’m thinking to create a custom workflow or create a specific condition on the bookmark icon, but now sure how. Any help will be appreciated!
Hi there, @supportportal… if I understand your post correctly, try adding a privacy rule on the Saved Jobs data type that says when This Saved Job's Creator is Current User, allow the user to find the items in searches and view all fields. Then, leave the boxes unchecked for everyone else, and I believe that will address the issue of users being able to see each other’s saved jobs.
Thank you for replying @mikeloc ! I have that privacy rule on my Saved Job database, but it didn’t fix my issue.
I probably could have done the logic better, but my issue is that I have a separate field called Saved in a separate database called Jobs. It toggles between yes and no depending if that job is saved or not. That flag allows me to populate the Saved Jobs database for my Bookmark Icon color change logic to work. I think I may have overcomplicated things with this.
Currently the bookmark icon changes colors for all of the jobs that is marked ‘yes’ under the Saved field in the Jobs database, which is why users can see everyone’s saved jobs. I just want the bookmark icon to change color only for the jobs that a specific user has saved, which was why I thought that the Created by field under the Saved Jobs database might be useful for this case. Again, I’m not really sure.
I hope that makes sense! Do you know any other way I can tackle this?
Yeah, it seems like you have overcomplicated things.
If I followed all of that correctly, you should be able to get rid of the Saved field in the Jobs data type because you can use the Saved Jobs data type to change the color of the bookmark icon. If a particular job is found in a search for things that were created by the current user in the Saved Jobs data type, then change the job’s bookmark color. Does that sound like what you are trying to do?
