I am having inventory scanning application with barcode option .
My table follows
I am having
Barcode scanner (Counter 1)
Input Text (Counter2)
DropDown(Counter3)
Exisiting Setup,
Input Text (Counter2) and DropDown(Counter3) Changes automatically based on the Barcode Scanning.
Example : Input Text (Counter2) is 5449000066947 is then dropdown change to 10121900.
Requirement :
I need to activitied the search in the Input Text (Counter2).
Example : If i enter 250 ml then dropdown box should display follows
10153701
10121900
Exisiting formulas.
Barcode scanner (Counter 1)
Onscan: Collect(MaterialMasters,{TextInput4:BarcodeScanner1.Value,Dropdown1:BarcodeScanner1.Value})
-------------------------------
Input Text (Counter2)
Default :BarcodeScanner1.Value
------------------------------------
DropDown(Counter3)
Items: If(IsBlank(TextInput4.Text),MaterialMasters,Filter(MaterialMasters,'full cases'=(TextInput4.Text)||'single cases'=(TextInput4.Text) || mm=(TextInput4.Text) || Materialdesc=(TextInput4.Text)))
-------------------------------------------------
Solved! Go to Solution.
Hi @AVTS :
Please try this formula:
If(
IsBlank(TextInput4.Text),
MaterialMasters,
Search(
MaterialMasters,
TextInput4.Text,
"full cases",
"single cases",
"mm",
"Materialdesc"
)
)
Best Regards,
Bof
Hi @AVTS :
Please try this formula:
If(
IsBlank(TextInput4.Text),
MaterialMasters,
Search(
MaterialMasters,
TextInput4.Text,
"full cases",
"single cases",
"mm",
"Materialdesc"
)
)
Best Regards,
Bof
Many Thanks Its worked
User | Count |
---|---|
171 | |
95 | |
74 | |
72 | |
58 |
User | Count |
---|---|
215 | |
166 | |
97 | |
93 | |
74 |