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. [form page] [ref match table] 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 :folded_hands:

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 t…

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 [Screenshot_20230818-162303~2.png] This is Scan Table . I want to put expression in [awb no] column of this table. [Screenshot_20230818-162324~2.png]

Probably something like.. LEN([AWB No]= ANY(SELECT(Scan Sheet Contains[Quantity], AND( [Courier Name]=[_THISROW].[Courier Name], [Channel]=[_THISROW].[Channel] ) ))

Hi @AleksiAlkio Thank you for your response. Showing, LEN function is used incorrectly [Screenshot_20230819-074411.png]

The “)” was missing from the formula. Use.. LEN([AWB No])=

Entry Based on Matched Conditions

AppSheet AppSheet Q&A

anonymous8 August 19, 2023, 6:12am 12

@AleksiAlkio Okay, but there’s one issue. I want to show an error message when the wrong [Channel] is selected, otherwise no

Topic		Replies	Views
Need Help this Function AppSheet Q&A other , databases , errors , expressions	1	3	August 11, 2023
COLUMN CONDITION I NEED HELP AppSheet Q&A users , automation , other , databases , expressions	12	2	February 23, 2023
Specific entry allow AppSheet Q&A automation , other , databases , expressions	0	12	February 15, 2024

Entry Based on Matched Conditions

AI Suggested topics