LinkedIn
Twitter
Hi, I have a process to scan the barcode of a pallet, with this scan we confirm that every pallet is at my warehouse.
Previously every data of pallet are loaded at the database. when we finishing to the scan change the other view to check that every pallet is received and check the information about the carrier to pick up the pallet later. the user they ask me if no possibility that this verification is done moment to the scan, that is can scan and in the same form check the information about the pallet.
well, I set to work, the first thing I did was create a virtual column and put the formula:
create a new view call โGroupโ and in this verify that every pallet that scans show me the information about carrier
So, I think can link in one only view through the view tape dashboard, but when to try, the scan form is no available to add to the dashboard
My idea was that can scan and in the same view check the information in the other view but in the same dashboard about the pallet and at that moment segregate the material in my warehouse by carrier or date of pick up etcโฆ
Does someone know if this is possible??
Solved
1 ACCEPTED SOLUTION
About this finally found a solution.
to verify where must be located each skid I use a virtual column with this formula in initial value:
so when scan this column contains information about the carrier:
also add two more columns where I add the information of the load and carrier number that I just scanned previously, so I can also verify the last thing I scan.
this is the formula that add in Initial value:
in this way the scanning is not slowed down, the only thing I have not been able to achieve is that after scanning I do not have to click on the scanning field againโฆ
The material (pallet) comes with a print number and a barcode, this barcode contains the same print number which in turn is linked to an instruction sheet (Document print). the process is that when unloading the truck a person check this print document it against the label in each pallet and the document contain apart of load number the carrier to pick up later and the date when we sending and tells the forklift where to place the material, based on the instruction sheet.
a truck contains pallets of a different carriers and different dates to pick. this pallet we are store in different racks by carriers.
I try automate this processโฆI am loading the document with the instructions previously in a table that is linked to an appsheet application. I would like to be able to scan and at the same time know to the area I must send the material.
my idea was used dashboard to link a form the scan with details view down to can see first the load number I just scanned and same time the carrier name and direct the forklift driver without having to also review the printed document.
some like that:
About this finally found a solution.
to verify where must be located each skid I use a virtual column with this formula in initial value:
so when scan this column contains information about the carrier:
also add two more columns where I add the information of the load and carrier number that I just scanned previously, so I can also verify the last thing I scan.
this is the formula that add in Initial value:
in this way the scanning is not slowed down, the only thing I have not been able to achieve is that after scanning I do not have to click on the scanning field againโฆ
