Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
I often set up a quick select method for my clients which i can demo if you contact me directly. it usually takes about 90 minutes of consulting time to setup. The user launches off a Receiving slip and that Receiving slip [Record ID#] is stored in a table of Users where the Key field is Userid. if the Userid does not exists then the launch button creates the Userid record.
The button then redirects to any report you like (for example items supplied from that vendor) and the user can click click click click as many lines on that report and on each click a child record is created on the Many to many Item Receipt table with a quiet pop up message that does not disturb the report. Then when done, the user click a link to get back to the receiving slip parent record to observe that indeed the child record have been added as expected and could cross check the item count to the suppliers packing slip. The user would then Grid Edit the qty received.
I usually set it up so that Items cannot be duplicated on the Item Receipt table for a given Receiving Slip.
I can be contacted at QuickBaseCoach.com
The button then redirects to any report you like (for example items supplied from that vendor) and the user can click click click click as many lines on that report and on each click a child record is created on the Many to many Item Receipt table with a quiet pop up message that does not disturb the report. Then when done, the user click a link to get back to the receiving slip parent record to observe that indeed the child record have been added as expected and could cross check the item count to the suppliers packing slip. The user would then Grid Edit the qty received.
I usually set it up so that Items cannot be duplicated on the Item Receipt table for a given Receiving Slip.
I can be contacted at QuickBaseCoach.com