Wanting to add html characters to Database Update Action Step

I am probably doing this wrongly.

I want to create notes per DB record, so these notes are stored in a single field. Date and time is added to the beginning of each submission. This is a mock-up of what I want to end up with…

This is the MySQL DB Update…

image902×271 9.41 KB

And the update binding

{{$_POST.prev_notes + NOW.formatDate('dd/MM/yyyy') + ' at ' + (NOW.formatDate('h:mma')) + ' : ' + $_POST.notes}}

This is what I want to achieve, I have done this manually in phpMyAdmin…

I thought I could do something like and add some HTML directly

{{$_POST.prev_notes + '<br><i>' + NOW.formatDate('dd/MM/yyyy') + ' at ' + (NOW.formatDate('h:mma')) + ' :</i> ' + $_POST.notes}}

but it won’t work.

Can someone throw some light?

I know I could probably use Summernote but I wanted to avoid that and try something more basic.