Notebook as column

A
Arnold Puy 👤 Member for 19 years 1 month

Hi Christian,



You need to assign first the Notebook Topic to your activities (e.g. Anticipated Problems, Corrective Action, Current Status, etc..).



Regards,



Arnold

C
Christian Viddal 👤 Member for 16 years 8 months

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

A
Arnold Puy 👤 Member for 19 years 1 month

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


N
Neal Walsh 👤 Member for 18 years 9 months

Hi Christian,



If you Group & Sort the Columns by List, Notebook is there.



Regards,



Walshy

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