How to filter for a logged-in user when this field is a rollup field from another table

Case: I have users.
Table 1: jobs, the jobs are connected to recruiters (users).
Table 2: candidates: the candidates are connected to table one through a roll-up for users/recruiters.

What I want to do is show a table component with My candidates (so all candidates connected to the current logged-in recruiter, through the jobs). I cannot filter this component by using the roll-up field, as the option is not shown for this field to filter for the logged-in user.

Is there a work-around - or a better way?

Possibilities in table 2:


Possibilities in table 1:

Hey @Peter,

There are two options here, as shown in our Data Source Filtering Document.

I’ll demonstrate them with your specific example in the following video.

Hi Chem, thanks for the explanation. I have learned from it.

Alas I have a user connected to a job, not a job connected to a user, as you explained it. So I have to rebuild it, in such a way that I don’t disturb how the current application is functioning. It is indeed a 1 to many, so 1 user/recruiter should be connected to several jobs.

Thanks for your thoughts

1 Like

If we have companies connected to user, candidates connected to user and the logged company seach candidates with some filter, how may I save the selected candidates on a table?
Or is it better to register company name on candidate record?
Several companies may select same candidate. For that reason I thought of using a table candidate / company, but then I don’t know how to get all the details, just with the code or the email

If I have a table and want to show the candidates selected by a company (the logged in Co.) I just have the option to filter by predefined company code… How to select the code of logged in company or candidate?

,

so we do not have the option of the logged in co. code. It would be nice to have teh selection of any field of the logged in Co., not just e-mail. Or setup dinamic field that takes the value of the logged in company, customer, candidate, or whatever.

Same if I want to show to candidates the companies that have selected them when they are logged in, filtering the companies that selected them. So why only e-mail is the field used for filtering results?

Is it possible to setup a variable field(logged user) or field conected to logged user

Thanks for your explanation.