Autocompute formula

[Luca_Favaretto]

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

[1minManager]

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

Simon@1minManager.com

[Luca_Favaretto]

1minManager:

Any(Select(Tablename[Sigla],[Noma]=[_ThisRow].[Firma]))

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

[1minManager]

Send a sample of both tables data. As the itallian wording is making it confusing

[Luca_Favaretto]

Main table

table with Initials

thanks

[1minManager]

Is this what you mean?

CONCATENATE(Initials([Firma]),"/",Initials([Relatore]))

Simon@1minManager.com

[Luca_Favaretto]

Thanks,it works!!