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 🙏
Change
Addetti[Operatore]=usersettings(Operatore)
to
[Operatore]=usersettings(Operatore)
Also Addetti[Data] to just [Data]
Thanks for your reply, but I need to compare the data in "Turno_Oggi_Form" with those in the other table.
You need to indicate what table the expression is attached to and what columns in what tables you are trying to compare.
The Table is Addetti, the column Operatore, but If I put [Addetti].[Operatore]=usersettings(Operatore), I receive "Unable to find column 'Addetti'"
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? 😭
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")
User | Count |
---|---|
32 | |
30 | |
30 | |
18 | |
16 |