LinkedIn
Twitter
Hi
i have to tables: visao and lojasemail
on table visao i have a virtual column “problemas lojas” type list with app formula(SELECT(visao[concatenar lojas], (AND([solucao] = “Avisar Loja por email”,[status]=“aberto”))))
it works fine.
but on table lojas email
i have a column “lojas” type longtext app formula( visao[problemas lojas])
to get the value from table visao - virtual column problemas lojas.
that way it’s getting the value but are duplicating the values, there are only 6 values (its in looping):
how can i fix it?
on the table visao - apear only 6 values.
Solved
1 ACCEPTED SOLUTION
hey guys, i do it to work.
on table visao - left virtual column:
concatenar lojas - appformula =concatenate(“RCC”,[protocolo]," - “,[estacao],” - “,[maquina],” - “,[problema],”
"
,)
and on table lojasemail
create another virtual column:
teste - appformula SELECT(visao[concatenar lojas], ([solucao] = “Avisar Loja por email”))
and set the column lojas to get and save on database the info from virtual column test
now it work
