KarimGawish
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Many to Many Relationship
Hello All, I have a table with lists of tasks that we need to work on daily and another Schedule table that has all employees and their availability dates. The usual situation is that 1 employee can finish several tasks per day, but some tasks require 2 employees to work on the same task. So right now the relationship is that 1-day schedule has many tasks (Diagram 1 attached). With the date field being the key field in the schedule and the due date on the tasks table is the reference field. How can I have this relationship without creating yet another table (Diagram 2 attached)? Or what is the least messy way to achieve this. ------------------------------ Karim Gawish ------------------------------4Views0likes3CommentsRe: List days capacity between two dates
------------- There is a real advantage to a scripted solution which is that you will get a static value that you can store when the Project is created or evaluated. A pure Quick Base solution where things are dynamically calculated will change as the Days Capacity change. -------------- Having it dynamically calculated and updated is not gonna be a problem at all, I can find a workaround to store the "state" of the project at the time of submission. (Checkbox to be ticked while adding a new project confirming our knowledge that we might not meet due date for example) So a pure Quick base solution can still be an option. Thank you for your help. ------------------------------ Karim Gawish ------------------------------18Views0likes1CommentRe: List days capacity between two dates
I think I should have another column with the decreased capacity. I think I didn't describe the problem properly, I'll try to describe it in a better way. Let's say we manufacture chairs, we receive projects daily, each project has a set number of chairs. Each employee can make 3 chairs per day, everyday they're at the office. When I receive a project request to make 25 chairs from Feb 23 to Feb 26, I want my total capacity for those days calculated and the number of chairs required deducted sequentially from the daily capacity and stored in the sheet. In the screenshot I wrote the numbers I expect the formula to provide. 23rd we'll do 9 chairs, so ending capacity is 0 24th we'll do 9 chairs, ending capacity is 0 25th we'll do the remaining 7 chairs, ending capacity is 2 26th will remain unchanged since we finished the project the day earlier. That way when we receive a new project, using the ending balance, we can automatically know if our remaining capacity can fit the new project or not. The following assumptions stand: - Projects are First come first serve basis - hence sequential deductions - "Chairs" are identical to each other, and all employees have the same capacity to make 3 chairs every single day at the office. Projects differ in the amount of chairs only. I appreciate your help since I've been stuck here for some time. ------------------------------ Karim Gawish ------------------------------12Views0likes0CommentsList days capacity between two dates
I'm trying to calculate the workload of my department while adding new projects. So I have a table for Projects submitted and a table of employees' availability dates. I need a formula that does the following: It lists the days between submission and deadline dates of new projects and retrieves value in a field [capacity] corresponding to those days from a child table and sums them. For instance, if I add a record with the following data: Submission date: Feb 23rd Deadline: Feb 26th it returns: sum(Feb 23 [capacity] + Feb 24[capacity] + Feb 25[capacity] + Feb 26 [capacity]) If you calculate it manually according to data in screenshot it should return 36. Thank you