Workflow email template will not work in this case. I’m using a parent table to list the classes and then a child table to to store the individual messages for each class. I want the user to be able to add rows to the child table whenever they want to add a new message and add rows to the parent table whenever they want to add a new class. The messages will regularly use different names so I want an automatic substitution for keywords. Ex: If the word Student is used in a message then the substitution expression will replace it with the name listed in the edit only table named Info. This table only has one row to prevent the formula from pulling more than one answer.
That being said, I’m not even close to getting that expression right because I can’t get a regular substitution expression to work. For example, when I plug SUBSTITUTE([Message], “Student”, “Test”) into the formula slot in the column information absolutely nothing changes in the final message seen in the app.
Ideally, I think something similar to the following expression will be what I use, but if I can’t figure out why a regular substitution expression isn’t working then there is no way I’ll be able to figure out a more complicated one. That is why I’m hoping someone has a sample app where I can look at how they use the substitution expression.
I hope this helps explain everything and thank you so much for your help!