Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Restricted views using enumlist and slices

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?

Solved Solved
1 9 502
1 ACCEPTED SOLUTION

You might try either of the following:

IN([Lead Status], {"Requires Inspection", "Ongoing Lead", "Lead Completed"})

or:

NOT("Currently not a Lead" = [Lead Status])

View solution in original post

9 REPLIES 9
Top Labels in this Space