LinkedIn
Twitter
Hi everyone. I just want to ask on how can I make this possible:
I have two forms, my 1st form is ADD PR which is a form view type of End User Table. This form consists of the following questions:
- PR No.
- PR Status
- Item Description
- Quantity
- Unit
The Item Description, Quantity, and Unit were referenced to the Items Table.
my second form is ADD PO which is a form view type of my Purchase Order Table. this form consists of the following questions:
- PR No. (which is a list of collected answers from ADD PR form)
- PO No.
what i want is when I selected PR No. in ADD PO form, it will show a lists of the Item Description, Quantity, and Unit under that PR No. but I want it to be clickable and the user may choose items under that PR No. since there are chances that Items under PR No. will be more than one. So when I want to fill out in ADD Po form, I can choose an Item/s under that PR No. but I want Item Description, Quantity, and unit have each different columns. not in one column. but when I selected one of the Item Description in my ADD PO form, It will also shows the Quantity and Unit under that Item Description that I chose but must not be edited. should I add columns of Item Description, Quantity, and Unit in my google sheet (Purchase Order Table) since I don't want to concatenate Item Description, Quantity, and Unit in one Column? what formula should I use?
I tried this, but it concatenate like this;
what I want is when I click/ choose Safety shoes, it will corresponds or it will shows the quantity and unit under of safety shoes only but in different column;
