Using Text Blaze as a Note-taker

I'm trying to figure out a way to use Text Blaze as a note-taker while making calls with my students. I would love to be able to type their name and it pulls up any notes I may have written about them during their time with me. This would be a great way to jog my memory instead of searching through the hundreds of logs we input while a student is in our class.

I have gotten as far as creating a table:

Student: {=proper({site: text; selector=#StudentFullName})} Notes {if: {=proper({site: text; selector=#StudentFullName})} == "Jennifer Saavedra"}{endif} part of the band, not available on Thursdays, stays with mom on the weekends.

However, I am unable to edit the table during a call. I would need to open Text Blaze, pull up the snippet, and edit it that way. My other option is to use the notes section already built into our website. However, I have other information already inputted in there and if I use the website tool it will pull all of the information. Is there a way that if I use the website tool I can then extract the information after a certain keyword?

For example: If the Note box says: G.P. Email #2: 08/28, G.P. C #1: 08/24, G.P. Email #1: 08/21, ACT: 08/21, WC: 08/15, WT #1: 08/14, WE #1: 08/14 Notes: part of the band, not available on Thursdays, stays with mom on the weekends.

I would use the website tool to pull this information but then the extract formula to only pull the part in bold. So the work "Notes" would be the keyword that it's looking for to pull everything after this. Is that possible?

Hey @Jennifer_Saavedra
How about splitting by the word "notes"? You could do:

{text="G.P. Email #2: 08/28, G.P. C #1: 08/24, G.P. Email #1: 08/21, ACT: 08/21, WC: 08/15, WT #1: 08/14, WE #1: 08/14 Notes: part of the band, not available on Thursdays, stays with mom on the weekends"}
{=catch(trim(split(text, "Notes:")[2]),"")}

2 Likes

@Dan_Barak1 This works perfectly and is so much easier than my original idea with the table. I have been looking for something like this to be able to make my conversations with my students more personal and meaningful. However, with 150 kids, it's not always easy to remember what their hobbies are. Would you be able to break down what each part of the formula does? I am trying to learn these more complicated expressions so I can apply them to other snippers if needed.

Sure. let me know if you'd like to jump on a quick call to go through this:

  1. split splits a text into a list of items based on the phrase in the second argument (here "Notes")
  2. [2] selects the 2nd item in the list (the list created by split)
  3. Trim removes white space from the beginning and end of a string of text
  4. Catch catches errors and returns the 2nd argument in case of an error. Here the main suspect is the [2] which will produce an error if the list has only one item, which will be the case if there's no "Notes" in the text (in that case, the entire text will become the first item of the list)