Problem with Concatenating - duplicating

Hi guy’s, i need to do a history from column [texto_observacao], so i created the column observacao to be a history.

Column texto_observacao is a type longtext with an initial value to catch the date and the user and a reset when edit:

CONCATENATE( NOW(), " - " , lookup(useremail(),tecnico,email,nome), " - ")

at column observacao, i used the appformula:

CONCATENATE([texto_observacao],"
",[_this])

Its worked, but at every changes that i do at the form, it’s insert another line.
I want only what is written at texto_observacao

3X_a_0_a061a54935121cd2db5765f0aed689741f231a17.png

Should be like that:
3X_f_1_f13bd803d4870262381756c12b26c03210c7d931.png

0 4 120
4 REPLIES 4

Wow, that’s interesting.

I would use an Action that runs upon Form Save to update the history value, instead of an App Formula.

Steve
Participant V

Set Reset on edit? to the expression:

ISNOTBLANK([texto_observacao])

Hi guy’s, what is the return of [_this] in an expression ???

[_THIS] refers to the current column
In Johny’s case, he could have used [informacoes adicionas] for the same effect.

Common usage scenario: setting some column to only be editable if it is blank:
editable_if = ISBLANK( [_THIS] )

Top Labels in this Space