Adding Notes to a data set.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a simple data set of projects and all the important info on that project. Other than just creating a new field list "Notes" and adding text over time is there a more user friendly interface where the notes are added and logged by date and user as there's added  . Maybe there's a "Add Note" button.  Thanks
Photo of David Gendron

David Gendron

  • 80 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
You are on exactly the right path. Simply create a new table called Notes and add a field to that table for Note and really that's about it. Then make a relationship where one project as many notes.

When you make the relationship with the system will automatically make an Add Note button for you and it will also create a report Link field to put on your Projects form for an embedded report of notes.
On the Form Orooertues. Report link field, you can set it so the embedded table of notes displays directly on the project record. And then you can make a report which lists the note field and the record owner field and the Date Modified to show who created the date and when and use that report on the form.

That was a pretty brief explanation of how to build a relationship supposed back if you have any questions or use the help button to look for help on relationships.
Photo of David Gendron

David Gendron

  • 80 Points 75 badge 2x thumb
Thank you for your help--it worked.  As we continue building out our system I'm sure I'll be back with more questions.