I have tried to explain to you through the help of an image, I want that if all the conditions are met here, entry should be allowed, otherwise not.
Please help me create this expression. I will be grateful to you.
I am searching for a solution to this. Please help me fix it. I have a lot of hope in you.
@Suvrutt_Gurjar @Joseph_Seddik @WillowMobileSys @AleksiAlkio
Please support me ๐
More details would be needed. Please try to explain your need with your own words, thanks.
Hi @AleksiAlkio
I have a table containing the details of all [channels] and [courier names] of [AWB lengths] Number. I want to create an expression that involves [AWB No] length + [courier name] + [channel] and then match it with a reference table. The goal is to check if an entry exists based on this expression in the reference table.
Hi @AleksiAlkio I'm awaiting for your response
Still need some details.. like what column types these 3 columns have?
I have given you the images of both the sheets.
This is Ref table
โ
โThis is Scan Table . I want to put expression in [awb no] column of this table.
Probably something like..
LEN([AWB No]=
ANY(SELECT(Scan Sheet Contains[Quantity],
AND(
[Courier Name]=[_THISROW].[Courier Name],
[Channel]=[_THISROW].[Channel]
)
))
The ")" was missing from the formula. Use..
LEN([AWB No])=
@AleksiAlkio Okay, ๐ but there's one issue. I want to show an error message when the wrong [Channel] is selected, otherwise no
From here..
Please Explain Expression
There is no need. Just type it. If the validation is false, it will show your message.
@AleksiAlkio I don't no why showing "This entry is invalid"
I want that when I select the [channel] only then the error message should be shown. some mistake in this expression. Give me one more help in this.
IF(
AND(
ISNOTBLANK([_THISROW].[Channel]),
LEN([AWB No]) <>
ANY(
SELECT(
Scan Sheet Contains[AWB LENGTH],
AND(
[REF_COURIER NAME] = [_THISROW].[Courier Name],
[REF_CHANNEL] = [_THISROW].[Channel]
)
)
)
),
"AWB length does not match",
"")
Add the condition to your validation.. then you can just write your warning message without any formula.
ISNOTBLANK([_THISROW].[Channel])
I have set the condition but not Working properly. Please provide expression
I want that when someone scans [awb no], no error message should be shown.
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |