Hello, I am looking to change the way my project app works. I am wanting to make a single table that holds the project information, lead information, and job information.
Every project gets its base information, it becomes a lead, and if accepted becomes a job.
In this table I will add an enumlist which I can select which stage/s its currently at.
I will use slices in the project, lead and job views to filter only relevant information for each team.
However, if I create a project, I don’t want it to become instantly available to view in the job view. Am I able to filter using the enumlist? So if the stage is not selected to job, it won’t show under the jobs view?