Hello,
I'd like an app to facilitate fast scanning of product barcode to assign to bins in a warehouse. I'd like the flow to be:
step 1 (Set bin number and Source).
Step 2 scan all the barcodes that are relevant to the info in step 1.
Step 3 close this process and start over at step 1.
TIA!
Disclaimer:
I'm admittedly new to AppSheet and still finding my way around. I usually can find answers on my own, but in this case don't know how to phrase what I'm trying to accomplish
Solved! Go to Solution.
You could evaluate the following as suggested in the table and image.
The sequence of operation looks like this - one minute video.
https://www.loom.com/share/2e3caa269b334ea2a23c821477385b59
1 | Add an Enum button [NewBin] | Enum Options ResetBin Initial Value "SetBin" | Valid_if [_THIS]="SetBin" Valid_If Error message "Set the source and bin number fields" |
2 | Enum Column [BinNumber] | Enum Options 1,2,3,4 | Show_if [NewBin]="ResetBin" |
3 | Enum Column [Source] | Enum Options Electrical, Mechanical, Hydraulic | Show_if [NewBin]="ResetBin" |
4 | Text Column Scannable [BarCode] | Show_if [NewBin]="SetBin" | |
5 | Action "OpenNewForm" LINKTOFORM() | Action's Target expression LINKTOFORM("ScanTest_Form", "Source", [Source], "BinNumber", [BinNumber]) | Set this Action as "Row Saved Action on Scan Form Saved. |
6 | Form Settings | As below |
|
Backend data for the entered values in the video
Of course your [BinNumber] , [Source] values, column types will be different. There will be more conditions depending on multi user operation etc. You will need to accordingly add user email, datetime stamp etc. columns.
Hope this helps.
Edit: Added one missing detail ( Valid_if expression) for [NewBin] column
Welcome to the Community!
Assuming you have warehouse/bin table and product/bin assignment table, have a reference column in the assignment table back to the bin table, one approach you can try to see if you like is..
1) Set your bin assignment Form as below
2) You want to navigate to this form from your warehouse/bin table, so you press the Add button created by system just below the inline view of your bin assignment table within the warehouse/bin detail view..
Try above and ask more questions if you need further support.
Thank you for the reply @TeeSee1! Products aren't always assigned to the same bin. This is why I wanted the employee to choose the location and source the first time, then rapid scan all the barcodes into that specific bin.
Workflow I'm trying to avoid is having to select source and location for reach scan. Hope that makes sense.
Thanks again for the reply
You could evaluate the following as suggested in the table and image.
The sequence of operation looks like this - one minute video.
https://www.loom.com/share/2e3caa269b334ea2a23c821477385b59
1 | Add an Enum button [NewBin] | Enum Options ResetBin Initial Value "SetBin" | Valid_if [_THIS]="SetBin" Valid_If Error message "Set the source and bin number fields" |
2 | Enum Column [BinNumber] | Enum Options 1,2,3,4 | Show_if [NewBin]="ResetBin" |
3 | Enum Column [Source] | Enum Options Electrical, Mechanical, Hydraulic | Show_if [NewBin]="ResetBin" |
4 | Text Column Scannable [BarCode] | Show_if [NewBin]="SetBin" | |
5 | Action "OpenNewForm" LINKTOFORM() | Action's Target expression LINKTOFORM("ScanTest_Form", "Source", [Source], "BinNumber", [BinNumber]) | Set this Action as "Row Saved Action on Scan Form Saved. |
6 | Form Settings | As below |
|
Backend data for the entered values in the video
Of course your [BinNumber] , [Source] values, column types will be different. There will be more conditions depending on multi user operation etc. You will need to accordingly add user email, datetime stamp etc. columns.
Hope this helps.
Edit: Added one missing detail ( Valid_if expression) for [NewBin] column
This is exactly what I needed. Thank you!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |