Forum Discussion

DavidGendron's avatar
DavidGendron
Qrew Member
7 years ago

Adding Notes to a data set.

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

2 Replies

  • 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.
  • Thank you for your help--it worked.  As we continue building out our system I'm sure I'll be back with more questions.