Filtering problem

[ThinhDinh]

In your screenshot, are you adding users to the project from the project’s details screen? I’m asking to see if we can have the context of that project.

What I would do is create a custom form.

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particular…

• Add a relation to the assignments table from the projects table, and a joined list column on top of it to retrieve all emails that have been assigned.

• Add a query to the users table, filter by email is not included in this row > joined list column of assigned emails, and use it for your choice component.

• Add user-specific columns for storing the person you want to assign’s email (I think you have an email entry in there in case the name is not on the list? If so, two user-specific columns for this).

• Show an error when the “custom email” column has a value included in the joined list column.

• Add an If-Then-Else column named “final email”. If “custom email” is not empty then return “custom email”, else return the value from the dropdown choice component.

• Create a relation from that If-Then-Else to the assignments table, and use a rollup to sum the number of hours they have been assigned.

• Use that rollup value to show/hide the choices for hours to be assigned in this project.