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.
