List of products Ref'd to form, possible to select multiple products with multiple quantities?

[mailyarrum]

Is it possible to create a list of products, Ref them to a jobsheet and then have the option to select more than one type of product and/or multiple quantities of said product?
Any help would be greatly appreciated.

[Steve]

Probably.

[mailyarrum]

Was that a poor question? I don’t understand the reason for your response.

[Steve]

Yes, your question is way too vague to offer any useful guidance.

[mailyarrum]

Apologies. I am just starting out with this.

[mailyarrum]

I have a column named ‘Parts’ in a form that was referenced from a table in my menu, named ‘parts list’. I am hoping to select multiple parts from this list and varying quantities of said parts, then add them to my basket. Any advice would be greatly appreciated. If I can word that any better please let me know. Thanks

[Rafael_ANEIC-PY]

Hello @mailyarrum, they way I do that is having a parent table named “Orders” with all the information related to a single purchase order, then there’s the “Products” table, or in your case it shall be “Parts” table, it is the child table of the “Orders”.

The idea is to create a new Order, and then use the “Related Parts” virtual column that is automatically created by appsheet after the reference is set up.

That allows you to add parts to your order directly from the “Orders” form using the “New” or “Add” button that comes with it by default, that button will take you to the form view for adding a new row in your “Parts” table, there you will select a single part and it’s desired quantity, and repeat this process for each different part that you wish to add to your order.

There might be other ways to do this, but this is the one I found easier hehe, but for this you must be quite familiar with references and how they work:

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

[mailyarrum]

Rafael_ANEIC-PY:

References Between Tables | AppSheet Help Center

Thanks for the response Rafael!
That’s very helpful. Would I only be able to have a ‘Parts’ column in that form?
I am wanting to create a form that an employee can fill out after finishing a job, which will include Date, customer, Parts used, etc would it be possible to use your method in this case?
thanks again

[Rafael_ANEIC-PY]

mailyarrum:

That’s very helpful. Would I only be able to have a ‘Parts’ column in that form?

If you mean in your “Parts” form, yes, it could be as straightforward as having a “Part” column with a reference to a parts list, and a quantity column, or you could add more stuff to it, it’s up to you.

mailyarrum:

I am wanting to create a form that an employee can fill out after finishing a job, which will include Date, customer, Parts used, etc would it be possible to use your method in this case?

The method I explained is best for saving one or more rows that are linked to a single parent record, in your case, it’s up to the data structure that you have in mind, I imagine that a single job can have one or more parts used, with different quantities for each, if that’s the case the same exact method would apply, only with diferent data columns.

[mailyarrum]

Awesome, thanks again for taking the time to respond, Rafael. I think i’m a little out of my depth on this one, do you know of any App examples that I can ‘look under the hood’ at?
Thanks again

[Rafael_ANEIC-PY]

I’ve been looking for one, but without much luck yet, this one might work for you, but the use case is not similar at all to yours:

AppSheet

AppSheet : mobile apps from spreadsheets : Facility Inspections - AppSheet

How to build apps for Facility Inspections using your data in Google Drive, Dropbox, Office 365, and more.

If I get a bit of spare time I’ll try to make one for you