Form to select multiple items

Bparham · 01-03-2023 07:37 PM

I have a parent table ( seel below ) Any time we place an order with a vendor, that information gets put here. I am trying to track when the package comes in, who checks it in and so on. I have set up a child table as a form to do this. When I select the PO number, I have other fields fill in based off that number. The area I am having trouble with is the PARTS. Each PO could have 20+ parts and I would like to be able to select which part came in and how many of that part came in as well. HOW DO I DO THIS?

I would like the end result to look like the highlighted. Without having to check in each individual item.

Marc_Dillon

It looks like you're already doing exactly what you need to be doing to me. If you're just selecting multiple values in a single column, like Parts, it could be an EnumList, but as soon as you need to add any additional info, such as Quantity, you'll need to record them as separate records.

Bparham

How do I get the enumlist to only show the parts associated with the PO number and then select all or some of them to change their status?

Marc_Dillon

I think you misunderstood. I was in no way suggesting for you to use an EnumList. I was just giving it as an example of what you could do if your situation was simpler, which it is not.

Bparham

Maybe I am trying to make this to complicated. Is it possible to use a form to update the parent table. ?

Marc_Dillon

You can run actions on the Form Save Behavior, or set up a Bot.

https://help.appsheet.com/en/articles/4865307-appsheet-automation-the-essentials

https://help.appsheet.com/en/articles/953637-actions-the-essentials