Question
Trying to add an order list to a form...
+10I'd like to make a form that sales reps would use to enter custom items to order. Basically a column for quantity, item number, etc. I would need multiple rows of these for entry, and I can't pull the info from another table due to the custom nature of the items. It seems like this would be very simple but I can't seem to wrap my mind around how to accomplish this!
no problem.
You will need to have a table called say Purchase Requests and then another table called perhaps Purchase Request Lines.
Then make a Relationship where 1 Purchase request has many Purchase Request Lines.
You will be able to show the Purchase request Lines directly on the Purchase request form as a list.
You will need to have a table called say Purchase Requests and then another table called perhaps Purchase Request Lines.
Then make a Relationship where 1 Purchase request has many Purchase Request Lines.
You will be able to show the Purchase request Lines directly on the Purchase request form as a list.
Yes, the Purchase request lines table would have a field for Item description and qty and maybe price and extended price.
The process to add lines would either one at a time, or if you set the embedded report on form properties to be editable, then the users can enter as many lines as they like in grid edit mode. As they use up lines, more lines magically appear.
Grid edit also allows copy paste and fill down "excel-like" actions.
The process to add lines would either one at a time, or if you set the embedded report on form properties to be editable, then the users can enter as many lines as they like in grid edit mode. As they use up lines, more lines magically appear.
Grid edit also allows copy paste and fill down "excel-like" actions.
+10OK so this works great so far... only questions are that it's adding a checkbox in the first column and a column that I didn't create before the ones I setup in the report. I can't see anywhere to turn that off.
The first "column" on any report, including an embedded report on a form is the recent feature to flag records to be deleted. If users have Permission to delete, then they will see that option to delete.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.