eeuhchad 0 Posted January 8, 2017 Share Posted January 8, 2017 I have a "Completed" notebook established for Work Orders (notes) that are randomly numbered with an "Unique ID". (ex: 2940156789) I would like to know if I can Search this notebook and produce a list of the Unique ID numbers found in the notebook. Thanks for any help you can offer! I am not a programmer as is likely evident by this post. Link to comment
Level 5* CalS 5,310 Posted January 8, 2017 Level 5* Share Posted January 8, 2017 Are the numbers in the note title or body? Link to comment
eeuhchad 0 Posted January 8, 2017 Author Share Posted January 8, 2017 They are in the note body. If it helps we could place them in the note title when it is created. Link to comment
Level 5* CalS 5,310 Posted January 8, 2017 Level 5* Share Posted January 8, 2017 If you have Excel skills you can generate a list of the numbers if you put the number in the note title. Preferably put the number at the beginning or end of the title, or preceded by the some prefix. This standardization makes it easier write a formula to extract the number from the title field within Excel. The steps are: Select the Completed notebook while in list view.. Select one note in the list and then press Ctrl-A to select all of the notes. Press Ctrl-C to copy the note meta data (which will be whatever columns are in the list view). Open Excel and Paste with Match Destination Formatting. Then you can unpack the W/O number from the title. Reads harder than it is. You can create the base model and then just paste subsequent copies into it. FWIW. Link to comment
Level 5* DTLow 5,746 Posted January 8, 2017 Level 5* Share Posted January 8, 2017 16 hours ago, eeuhchad said: I have a "Completed" notebook established for Work Orders (notes) that are randomly numbered with an "Unique ID". (ex: 2940156789) I would like to know if I can Search this notebook and produce a list of the Unique ID numbers found in the notebook. For sure, if the number is in the title you can produce a list of the numbers The screenshot I posted is a list of my journal notes If instead of the date, the title included your "Unique Id" you have your list You can use the copy-links feature to copy this list and paste it elsewhere Link to comment
eeuhchad 0 Posted January 8, 2017 Author Share Posted January 8, 2017 Thanks for the help! This will help make our invoicing process more efficient. Link to comment
Level 5* CalS 5,310 Posted January 9, 2017 Level 5* Share Posted January 9, 2017 4 hours ago, eeuhchad said: Thanks for the help! This will help make our invoicing process more efficient. You are welcome. Link to comment
Recommended Posts
Archived
This topic is now archived and is closed to further replies.