Ref Row filter then duplicate [ capl barcode ]

[Sirfyaad]

I want to filter the row with the help of a [capl barcode column]. But only that row 

filter should be shown in the details view [capl barcode column]. It has to filter the data capl barcode column related.

[WillowMobileSys · Accepted solution]

Still not getting enough details BUT I'll take a generic stab at it.  

I think what you are saying you want is in a Detail View, you want to see an Inline table list of OTHER rows (from the same table) that also have the same [CAPL BARCODE] value.

To do this, simply add a Virtual Column to your table, lets call it "Table A".  Set the virtual column to a type of List and set the Base Type to Ref and then set the Referenced Table property to the table of "Table A".

In the App Formula of your Virtual Column use an expression similar to that below.  NOTE: this is just an example...you will need to change it to use your Table and Columns:

SELECT(Table A[key column for Table A], 
       AND([CAPL BARCODE] = [_THISROW].[CAPL BARCODE],
           [key column for Table A] <> [_THISROW].[key column for Table A]
       )
) 

The expression above MUST return a list of row keys.  The "<>" portion omits the current row from the displayed list.

Add this Virtual Column to your Detail View.  Since the Virtual Column is defined as List with Base Type of Ref, it will automatically display as an Inline Table.

When you view one of your rows, you will see a list of rows in a table that are related by the [CAPL BARCODE] column EXCEPT the current row you are viewing.

I hope this helps!!!

[WillowMobileSys · Accepted solution]

In AppSheet ".SWITCH" is not valid syntax.

In each column there is a separate Show_If property.  You want to delete the period and then move the SWITCH(...) portion of your expression to the Show_If property.

[WillowMobileSys]

It is not clear what your end goal is.  

If you are asking how do you search by [capl barcode column] to filter the results down to just those rows,  you need to make sure that column has been marked as Searchable.  There is a property at the bottom of the column definition in the Other section.

If you goal is something else, then please describe what you want the users to be able to do.  We can help you better that way.

[Sirfyaad]

NO.

When the [CAPL COLUMN] is a duplicate, the Ralted Row filtered from the [CAPL column] below the detail view

[WillowMobileSys]

Still not clear.  I won't try any more to assume what it is you want. You need to spend the time to explain what your goal is. 

Showing images or where you are having a problem or to show what you want will help a LOT!!

[Sirfyaad]

Hi @WillowMobileSys 

I want that if the value which is in the [CAPL BARCODE] of detail view, if it is more than one, then all of them are shown below the detail view. 

[WillowMobileSys · Accepted solution]

Still not getting enough details BUT I'll take a generic stab at it.  

I think what you are saying you want is in a Detail View, you want to see an Inline table list of OTHER rows (from the same table) that also have the same [CAPL BARCODE] value.

To do this, simply add a Virtual Column to your table, lets call it "Table A".  Set the virtual column to a type of List and set the Base Type to Ref and then set the Referenced Table property to the table of "Table A".

In the App Formula of your Virtual Column use an expression similar to that below.  NOTE: this is just an example...you will need to change it to use your Table and Columns:

SELECT(Table A[key column for Table A], 
       AND([CAPL BARCODE] = [_THISROW].[CAPL BARCODE],
           [key column for Table A] <> [_THISROW].[key column for Table A]
       )
) 

The expression above MUST return a list of row keys.  The "<>" portion omits the current row from the displayed list.

Add this Virtual Column to your Detail View.  Since the Virtual Column is defined as List with Base Type of Ref, it will automatically display as an Inline Table.

When you view one of your rows, you will see a list of rows in a table that are related by the [CAPL BARCODE] column EXCEPT the current row you are viewing.

I hope this helps!!!

[Sirfyaad]

@WillowMobileSys 

Its working but, I want this virtual column to be visible only to admin. my function not working why. please help. 

SELECT(CAMPUS SCAN SHEET[GATE ENTRY NO], 
AND([CAPL BARCODE] = [_THISROW].[CAPL BARCODE], 
[GATE ENTRY NO] <> [_THISROW].[GATE ENTRY NO] 
 ))
.SWITCH(
  INDEX(
     SELECT(
       User Login[User Control],
       [Email]=useremail()
            )
        ,1),
  "User",FALSE,
  "Admin",TRUE,
  FALSE
)

....from rows of table 'CAMPUS SCAN SHEET'
....where this condition is true: (ALL these statements are true:
........1: (The value of column 'CAPL BARCODE') is equal to (The value of 'CAPL BARCODE' from the row referenced by 'GATE ENTRY NO')
........2: (The value of column 'GATE ENTRY NO') is not equal to (The value of 'GATE ENTRY NO' from the row referenced by 'GATE ENTRY NO'))

[WillowMobileSys · Accepted solution]

In AppSheet ".SWITCH" is not valid syntax.

In each column there is a separate Show_If property.  You want to delete the period and then move the SWITCH(...) portion of your expression to the Show_If property.

[Sirfyaad]

The function is working. But the blank row is showing when the [capl barcode] is empty. how can i fix this. 

[WillowMobileSys · Accepted solution]

Add to your criteria:

...ISNOTBLANK([Capl Barcode])...