KarenWondergem
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Confusion about Status across multiple tables- Project Management
The Status multiple choice field should be centralized, am I correct? Right now there are three status fields- one in each of the table. Do I make another table with a list of all the statuses? Would it then be a lookup field in each of the tables, and from there I apply the formula you mention above?Confusion about Status across multiple tables- Project Management
Total newbie, I am learning but I apologize for the fairly easy question I am sure. I have 3 tables in my app: Courses Projects Change Log Each table has a multiple choice Status dropdown: Course Status (Main Record: Course ID) LIVE ARCHIVED Projects (Major Projects) Major Project Pending Major Project in Progress Major Project Completed Change Log (Minor Changes) Minor Change Pending Minor Change in Progress Minor Change Complete All projects and changes have launch dates. A project or change can be Complete, but will launch on a certain date (the dates are in a connected Calendar table) I would like all three to relate to each other, but in the following manner: All Courses have the default value of LIVE unless we move to ARCHIVED If a Major Project or Minor Change is started for a course, the user changes the Status to Pending or In Progress. The Status then shows up in the main Course table so if the main record is accessed, it shows the course being worked on in a project or minor change. When the Major Project or Minor Change is marked as Complete, the Status in the main course table will automatically change to LIVE when the Course Copy date occurs. Is this possible? If so, how can this be accomplished?Auto populate dates
I am a complete newbie so this may be an easy question for some. I am using QB to manage courses at a school. I have a project sheet with the following fields: Launch term (Dropdown - text multiple choice) Launch date (Date) Copy date (Date) End Date (Date) I want to auto populate the three date fields based on the choice in the dropdown. For example, If the user chooses Spring 2 2018, the term start auto populates with the date for Spring 2, the course copy auto populates 2 weeks before the date for spring 2, and the end date auto populates for one month before the course copy. Right now they are not connected to anything. Is this possible? Please see image for a visual. We have multiple terms per year, with multiple dates, across multiple schools, so each term is unique as is their respective dates.
