Connect only filtered rows to a child table
Hello,
I am building an app with matching candidate and job.
These tables are many-to-many related and there is a junction table between these tables, named candidateJob.
Job table has a status column with options like active, filled, closed, etc., and I only want jobs with active status to be available options for the form, when adding a new candidateJob in the junction table.
I have tried dynamic form rules, but it cannot prevent jobs with other status coming into the form; all I could do was to make the form back into blank when those jobs were chosen.
I also tried to manipulate reference field option with conditional values, but it requires a field to be chosen to start, which is not what I want.
I want jobs with only active status to be connected into its child table, candidateJob, so that the user doesn't need to deal with choosing a valid job among various status.
Thank you in advance.
I am building an app with matching candidate and job.
These tables are many-to-many related and there is a junction table between these tables, named candidateJob.
Job table has a status column with options like active, filled, closed, etc., and I only want jobs with active status to be available options for the form, when adding a new candidateJob in the junction table.
I have tried dynamic form rules, but it cannot prevent jobs with other status coming into the form; all I could do was to make the form back into blank when those jobs were chosen.
I also tried to manipulate reference field option with conditional values, but it requires a field to be chosen to start, which is not what I want.
I want jobs with only active status to be connected into its child table, candidateJob, so that the user doesn't need to deal with choosing a valid job among various status.
Thank you in advance.
