Notes Field on Time Cards / Time Sheets

[Scott Jordheim]

Hello, we are looking to bring the "notes" field into reports we do on time cards / time sheets.

I haven't figured out where this field actually lives yet, as it doesn't seem to be a part of either of those tables. From what I can tell, whatever is entered into the "notes" field does roll into the "comments" field at some point in time, but I'm not sure how that works.

Has anyone ever successfully brought "notes" into a report where you could even use it as a filter condition that would pull in records as soon as something was added in that field?

For example, I want to pull in anything where a user added notes of "test" immediately after they added the notes, and not having to wait until the time sheet was approved.

Edit: Did find the notes field (in our case: notes and u_notes), but still can't use it as a filter condition.

[Michael Fry1 · Accepted solution]

Out of box Notes field is a journaled field, same as Comments and Work Notes. That means you can add Notes to report, but wouldn't be able to use as condition, unless condition was is not empty.

[Scott Jordheim]

Thanks! I looked into solutions such as building a database view to bring it over, but that was quickly shot down when I saw what it would do to load times.