Best Structure for Meeting and Minutes

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a Projects table and I would like to record minutes of meeting in relation to each project as well as allied actions.  What is the best structure to deal with it: 

Projects  1TM Meetings

Meetings 1TM Items (minutes) 

I am stuck here how to deal with Action Items whether I need to link these to the meeting and if so how can this also be linked to the right project.    

My preferred solution is that user adds a new meeting with meeting dates etc and then selects the right project  followed by action  against each project.

Will appreciate some insight.  
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
I'd recommend having the Action Items = Minutes.

Basically in your meeting, you will click a button to add a minute, and some of the minutes might have some action to be completed, and assigned to somebody.  Others will not.

That way you can have the notes and items in once level, and reports and follow-up will be much easier.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks Matt.  How do I identify action items to the right project?  Would this have an indirect relationship? 
(Edited)
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
You can do it indirectly, or with a direct connection.  I'd recommend direct.  

You will want to modify the button to "Add Notes" to also write the value for the related project, not just the related meeting.  Saves time and dropdowns when you are in a fast paced meeting.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks and that change to Add Button will be addition to the script therein? Could you give me an example? 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Arshad,

What Matthew means is that you also need to populate the field for say [Related Initiative]

In this button below from your app, the Action is now connected to both a Minute and an Initiative by two relationships.  So the Add Action button needs to populate both field IDs 11 and 13.

Like this
URLRoot() & "db/" & [_DBID_ACTIONS] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Record ID#])
& "&_fid_13=" & [Related Initiatives]

& "&z=" & Rurl()
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
Sorry for the off topic comment but I noticed you are using the infamous Rurl() function that isn't documented among the other formula functions. So I created this application with one formula text field and set the formula to Rurl().

Rurl()
https://haversineconsulting.quickbase.com/db/bm3rgckkd?a=q&qid=1

Every time you edit or view a record or report it changes it value! What's up with that?
(Edited)
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Tracking people on the links you add now eh?  very nice.  ( I clicked it)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
Not at all. You will note the field resets itself every now and then. Rurl() is the mystery formula as it is undocumented.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Is this tracking from the community now?

&_ga=2.136254644.463809833.1505098337-1257757333.1504802482

(this is from the copied link address above)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
Off hand that looks like a google analytics thingy. I think they are tracking you!