DonLarson
Qrew Deputy
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Best way to have a repository of pre-configured options but also allow users to add/edit
The Users would only have to create child records for the unique or custom questions. A Pipeline should auto build the records from the Standard table to the questionnaire table for the particular campaign. I have used the technique Mark has described for multiple business cases.Re: Calendar Reports
Does the Sub Job have any different fields/ information from a Job? If it is 100% the same then I would relate the Jobs Table to the Jobs Table and make sure that the reference field is Related Customer Job or something that makes it very clear a given Job is the Sub because it has a Parent. If a Sub is different in any way, make a new table. I have a business case for a client where we have to take time cards from employees in the field and then break them into pieces for Payroll. The big distinction is Regular and Overtime for components of a single time card. Just like your case there are different Start and Stops but there is also Related Payroll Allocation Type which a Time Card does not have.Re: Running Total with a Max
Dan, I have solved a similar problem on Time Off, but attack it differently. There is a Pipeline running monthly that expires the oldest earned time that exceeds the threshold. It also checks seniority and will raise the threshold on an individual basis from the new hire level out to five years when employees max out.
