Try to change Localize Save button

[Pelatone73]

Hi all 👋

could someone please tell me where I'm wrong? 

I'm trying to change SAVE button in localize on event but I receive that error:

Cannot compare List with Text in (Addetti[Operatore] = [_THISUSER].[Operatore])

This is my formula:

If(and(context(“view”)=”Turno_Oggi_Form”,SELECT(Addetti[Row ID],Addetti[Operatore]=usersettings(Operatore)),SELECT(Addetti[Row ID],Addetti[Data]=TODAY()))),“Accedi”, “Salva”)

Thanks in advance 🙏

[TeeSee1]

Change 

 Addetti[Operatore]=usersettings(Operatore)

to 

 [Operatore]=usersettings(Operatore)

Also Addetti[Data] to just [Data]

[Pelatone73]

Thanks for your reply, but I need to compare the data in "Turno_Oggi_Form" with those in the other table.

[TeeSee1]

You need to indicate what table the expression is attached to and what columns in what tables you are trying to compare.

[Pelatone73]

The Table is Addetti, the column Operatore, but If I put [Addetti].[Operatore]=usersettings(Operatore), I receive "Unable to find column 'Addetti'"

[Pelatone73]

I've tried to set the function in this ways

If(and(context(“view”)=”Turno_Oggi_Form”,isnotblank(usersettings(Operatore)),Addetti[Operatore]=usersettings(Operatore)),“Accedi”,"Salva")

If(and(context(“view”)=”Turno_Oggi_Form”,SELECT(Addetti[Row ID],[Operatore]=usersettings(Operatore))),“Accedi”,"Salva")

but the results is always the same:

 Cannot compare List with Text in (Addetti[Operatore] = [_THISUSER].[Operatore])

No one can help me? 😭

[baba_sawane]

Hi Pelatone,

try: 

If(
and(
context(“view”)=”Turno_Oggi_Form”,
isnotblank(usersettings(Operatore)),
contains(Addetti[Operatore],usersettings(Operatore)) ),
“Accedi”,"Salva")

or :

If(
and(
context(“view”)=”Turno_Oggi_Form”,
isnotblank(usersettings(Operatore)),
contains([Operatore],usersettings(Operatore)) ),
“Accedi”,"Salva")

or :

If(
and(
context(“view”)=”Turno_Oggi_Form”,
isnotblank(usersettings(Operatore)),
contains(concatenate(Addetti[Operatore],usersettings(Operatore)) ),
“Accedi”,"Salva")