Hello, when i fill "realtore"and โfirmaโ columns, I would autocomplete โsiglaโ Column with the first name and surmname initials.(example: LR/MV)
I have create table with first name\surname and initials
which formula can I use?
settings in my tables?
Thanks
![image|295x325](upload
Try an Initial Value in Relatore of
Any(Select(Tablename[Sigla],[Noma]=[_ThisRow].[Firma]))
In Relatore you probably also want to turn on Reset on Edit
Dosenโt work.
i have a table with columns sigla,relatore,firma
i have another table with association between name of โrelatoreโ or โfirmaโ and โsiglaโ
My goal should be
put name โfirmaโ column LUCA ROSSI
put name โrealtoreโ column MARCO VERDI
automatically system generate โsiglaโ LR/MV checking name in table
need an app formula in โsiglaโ Column
Send a sample of both tables data. As the itallian wording is making it confusing
Main table
table with Initials
thanks
Is this what you mean?
CONCATENATE(Initials([Firma]),"/",Initials([Relatore]))
Thanks,it works!!
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |