I have two related tables, Opportunities and Tasks. An opportunity can have many tasks.
I am trying to add a field on to my opportunity table to show when my next task date is and if there is nothing assigned to shade the opportunity yellow to signal we are not doing anything with it and we need to create opportunities....
I have a summary field for the number of tasks so I can easily shade the record yellow if the number of active tasks = 0
How do I go about getting the next task date? I was thinking to use a summary field with a min of task due date but that doesnt appear in my opportunity table.
Thanks!
------------------------------
Ivan Weiss
------------------------------
Question
Get the next date of a task related to an opportunity
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.