Hi everyone,
I need a bit of help with the ux of my inventory app.
On a mobile device, the user can scan a barcode for the product code (MPC; Mfg Product Code) and based on the value the fields group_(MGC; Model Group Code)_ and Description should be filled from a table Hardware with columns MPC, Description and MGC.
Any ideas, suggestions or help is greatly appreciated.
Solved! Go to Solution.
Hi @Lynn,
Thanks for the quick reply.
The โStock Management Appโ is the basis for my app but it doesnโt take the Barcode of the product and populate the other fields either.
Maybe I should explain a bit more for clarity; The user scans the MPC of a device and dependent on this value it should fill the other 2 fields (eg. MGC = โNotebookโ and Description = โHP EliteBook 850 G5โ). After a few other bits of information are collected on the mobile the user can select โSaveโ and commit all of the information to the data sheet.
Does that help any?
The expression that โalmostโ worked was something with SELECT(). Iโve change it trying to solve my problem so I donโt know exactly what I had in there. Sorry.
I guess the main problem is โhow do I access field values that are only present in the mobile app part of the program?โ
I have just realized that the expression neither in the Slice nor in the Data Bable function. There appears to be a basic mistake in my expression.
At the moment I am using a Slice and trying SELECT(HWInfo[MGC]; HWInfo[MPC] = [_THISROW].[MPC]; TRUE) but keep getting the error Cannot compare List with Text in (HWINFO[MPC] = [ID].[MPC]).
I donโt understand why is is choosing the [ID] field and not the [MPC] field.
UPDATE
Thanks to the new YT Video posted today (https://www.youtube.com/watch?v=jSkXMtsj1dM) I was able to find a solution for this problem. Apparently I wasnโt using the Reference data type properly.
Thanks anyway to whoever looked at my question and wanted to help.
Hi @Charles , What was the formula that you tried that didnt quite work? Did you check out the sample โStock Managment Appโ ?
https://www.appsheet.com/samples/This-inventory-app-uses-barcode-scanner-to-record-stock-in-and-stoc...
Hi @Lynn,
Thanks for the quick reply.
The โStock Management Appโ is the basis for my app but it doesnโt take the Barcode of the product and populate the other fields either.
Maybe I should explain a bit more for clarity; The user scans the MPC of a device and dependent on this value it should fill the other 2 fields (eg. MGC = โNotebookโ and Description = โHP EliteBook 850 G5โ). After a few other bits of information are collected on the mobile the user can select โSaveโ and commit all of the information to the data sheet.
Does that help any?
The expression that โalmostโ worked was something with SELECT(). Iโve change it trying to solve my problem so I donโt know exactly what I had in there. Sorry.
I guess the main problem is โhow do I access field values that are only present in the mobile app part of the program?โ
I have just realized that the expression neither in the Slice nor in the Data Bable function. There appears to be a basic mistake in my expression.
At the moment I am using a Slice and trying SELECT(HWInfo[MGC]; HWInfo[MPC] = [_THISROW].[MPC]; TRUE) but keep getting the error Cannot compare List with Text in (HWINFO[MPC] = [ID].[MPC]).
I donโt understand why is is choosing the [ID] field and not the [MPC] field.
UPDATE
Thanks to the new YT Video posted today (https://www.youtube.com/watch?v=jSkXMtsj1dM) I was able to find a solution for this problem. Apparently I wasnโt using the Reference data type properly.
Thanks anyway to whoever looked at my question and wanted to help.
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |