Hi everyone — looking for advice/best practices.
We’re configuring Ramp workflows/submission policies where routing is based on Department (e.g., dept codes like 0123). In a later step, users select a Project from a dropdown. We have a large Project list (~500), and ideally we want users to only see projects tied to their department.
Right now, it looks like the only way to do this is to manually select individual Project options under a conditional filter. That works for one department, but as we roll out more departments it feels like we’ll need to update the workflow anytime a project is added or the project↔department mapping changes (tedious and error-prone).
Questions for the group:
- Has anyone found a way to dynamically filter Project options by Department (without manually maintaining allowed project lists)?
- If not, what workaround has worked best for you? (e.g., naming conventions like
0098 – Project Name, “conditional coding” rules, separate project fields per dept, nightly API/CSV sync, post-submit validation, etc.) - Any Early Access / Custom Fields approach that helps with this?
Appreciate any pointers or examples of what’s worked in practice.