I post jobs that a selected group of individuals (workers) may choose to accept. Not all jobs will be offered to very individual. After reviewing the list of jobs, a worker may choose to bid (and add a new offer) or not to bid. A worker should login to see jobs offered to him/her and review the list regularly. I want to create all this with just two tables: jobs and offers.

I encountered a problem that I don't know how to overcome. How can a user hide a job after reviewing requirements? The purpose of this is hide in his job list those that does now want to bid. Otherwise his dashboard will be cluttered with jobs he has already reviewed.

I created a multiselect field to the Jobs table and through that could limit who can view a particular offer. I thought that I could add another multiselect field that would store info on who opted out. But I don't know how I can run a script that would change the value of the multiselect field from a view. It appears that a formula field does not allow this.