function for AppSheet

[Anzhelika]

Hi guys! I don't understand how you can configure the filtering function for reference strings. I have a table of compatibility between a form and a product. I just want the list of products compatible with it to be filtered in the table where the form is filled out. I wrote a Filter function for the initial values ​​of this list. but doesn't work. I tried to make Select but it always writes that the expected type is List, not a link. I do not understand how to do it right, I have been suffering for a long time. help me please

[Tommy62]

Schaue mal folgende Erklärvideo:2 Möglichkeiten zum automatischen Ausfüllen von Formularen 

[Anzhelika]

I have several types of products suitable for the form, and not one, so this solution does not work. i need to get a filtered list of reference strings to select

[Suvrutt_Gurjar · Accepted solution]

If understanding of your requirement is correct, then in the Product id1(ref) column of the Form table , you could try a valid_if expression of 

FILTER( "Compatibility Table", [Form ID]=[_THISROW].[Form ID])

Edit: I think the expression needs to be as follows because FILTER() will return key column values of the Compatibility table and not "Product IDs"

SELECT(Compatibility Table[Product ID], [Form ID]=[_THISROW].[Form ID])

Note : The above suggestion is based on just the description given and screenshot shared. Since the column names are in different language than English, I have made some assumptions. Also I could not use Google translate because the column names are in screenshot , so those cannot be copied for translating. If the above suggestion does not work, you may need to share the column names and table names in text format.

[Anzhelika]

Thanks a lot! You helped me!