Notebook as column
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Hi Christian,
You need to assign first the Notebook Topic to your activities (e.g. Anticipated Problems, Corrective Action, Current Status, etc..).
Regards,
Arnold
Thanks a lot for the suggestions from both of you.
Maybe I am blind but when I open the list of available columns I am not able to find Notebook, neither when I am doing the search. Any ideas?
Reason why I need it is when exporting to excel I want to show the notes associated with each of the activities.
Thanks,
Christian
Hi Christian,
There is a workaround, create a new report using activity notebook as your subject areas. Open it in excel and then save it.
When done, create a new UDF and display the newly created UDF say, "Remarks". Then go to file menu --> export --> spreadsheet - (xls).
Note: Include the "Remarks" into the column during exporting.
When done, do it in excel by using the "vlookup" function of excel.
Otherwise, email me @ [email protected]
Regards,
Arnold
Hi Christian,
If you Group & Sort the Columns by List, Notebook is there.
Regards,
Walshy