Input Text to find a field inside a Data Type

Need help Database
1

Hey guys, I really need your help here.

I have 2 Datatypes:

  • Product: with all informations of PRODUCT1 (including NAME);
  • Stock Control: for in/outs register of stock for products. So one filed is Product > Product (type).

image
image

The user will type the product name in the search bar.
A repeating group will show all entries for this product. I´m confused in how to relate the Product Name typed in the search bar with the Product (list) in the Stock Control database.

image
image1891×292 19.6 KB

Any clues?
Thanks

2

Search works only for texts fields - Repeating group should contain data of products as source. Then you can set the search bar value to dynamic & search for the product’s name field

3

You can not via a normal search use the text based value (coming from input element) to filter the search in the RG based on the Name of the product when the Stock Control Database is using the Product as a related field. If you want to filter via the text field (Name) from the related data type (Product) on the data type of Sock Control database, you would need to use an Advanced Filter.

Alternatively to the Advanced Filter, what I prefer is to simply put onto the Stock Control database a text field that is the Product Name as text…you can still have the related field of Product as well which is used for different purposes, but the Product Name field of type text on Stock Control database is simply used for this feature of searching and filtering Sock Control based on the input value.

1 Like