How to add multiple products/Services under specific order in the form itlself

[Aditya_Vinayak_]

How can I get the add button just like in the following app when we add an order for the customer and you have the option to add multiple products.

How to do it?

https://www.appsheet.com/templates/An-app-for-managing-customers-products-and-orders?appGuidString=8...

[Aurelien]

Hi @Aditya_Vinayak_Koul

You need to tick the option “is a part of” on the column settings (which you get access to when clicking on the black pen icon)

[SkrOYC]

For reference:

help.appsheet.com

References Between Tables

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

Expressing Ownership Between Tables

References can indicate not only that two tables are related, but that rows of one table should be owned by (or considered a part of) rows from another table. This is done by activating the IsAPartOf option in the Ref column structure. Typically, this should only be done in cases where rows containing the Ref column only make sense when associated with a row from the referenced table. For example, you may have a separate Order Details table for line items that reference an Order , but conceptually each entry should be considered “part of” an Order and shouldn’t exist independently (put another way, the Order record “owns” the Order Details that reference it).

There are several implications of enabling this ownership relationship:

1. Form views should allow users to add or update related rows that are a part of that row without leaving the form.
2. A form comprised of multiple rows should be treated as a single update.
3. If a row is deleted, any related rows that are a part of it should also be deleted (and again treated as a single update).

The first of these to take effect will be #1: System-generated reverse reference columns related to Ref columns marked IsAPartOf will appear in form views and allow users to view, add, and edit line items within the form view. The availability of these options is limited by the table or slice permissions (and until the final form is saved, pending adds can still be modified even if the table doesn’t allow updates).

There are some limitations of which to be aware:

• A table can only have one Ref column marked IsAPartOf (a row can only be a part of one other row).
• Actions are not supported within forms. Inline views based on reverse references in forms will not display actions or trigger actions based on view events.
• Canceling a form with pending line item adds/edits also cancels those adds/edits.