CarolynHendryc1
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Pipelines - Multiple if then else statements
I have a budget table and a template table. The records for the budget table are created using a pipeline based on a choice in another table. This is working great ... BUT, I only have 3 templates set up so far and already I'm scrolling, scrolling, scrolling to add new ones. I already have 12 templates I need to set up and will likely have many more. My question is, is it better to have one incredibly long if, then, else pipeline or would it make more sense to create a new pipeline for each template? The problem with the second option is I have to create pipelines for both when a record is added and when a record is updated, duplicating the number of pipelines. I may end up with 50 or so pipelines just for this one simple action. Would love to hear if someone sees a better solution for this before I continue. Thanks! ------------------------------ Carolyn Hendrycks ------------------------------45Views0likes0CommentsRe: Schedule hours over multiple weeks in one entry
I'm going to have to stew on this for a while to see if I can make it work for us. This is for a forecasting schedule, so the times often go well into the future and can span many months, even years. But I like this idea of a child table (hadn't thought of that) and I may be able to limit the input to just the next 10 weeks or something like that. Thank you for the detailed response!22Views0likes0CommentsSchedule hours over multiple weeks in one entry
We have a Project Tasks table where each task has a Start Date, Duration, Budget Hours, and Employee assigned to it. One of the most important pieces of data we need is how many hours each employee is scheduled per week. The problem comes when we have a task that will happen over multiple weeks. The hours for the employee will only show up the first week, but I need them spread out over all the weeks. For example, I have a task with a start date of June 3, duration of 50 days, and 60 budget hours. On the summary table it shows that employee as having 60 hours booked the week of June 3 and 0 hours over the following weeks. I'm stuck as to how to write a formula to split out these hours over the multiple weeks. We have thousands of tasks and I don't want our scheduler to have to enter multiple entries per task to break things out into weeks.19Views1like2Comments