Editable List

[dionvk]

I have a table of "Sale" that have column of ID Sale, Cust., Phone, etc and a table of "SaleDetail" that have column of ID Detail, Qty, Price, etc. and im currenty working on making a form for adding products, in general it is already done for, but in adding product form there are some trouble,

1. in the form for adding product (SaleDetail_Form) i check the Auto re-open so it will automatically open the SaleDetail_Form for the next product adding and it will show the list of added product. the problem here is currently im using [ID Sale].[Related SaleDetails] for the list, and i can't edit it, it can only show, the only way to edit is to back first to  Sale_Form (i used a virtual column [Related SaleDetails] with formula: aREF_ROWS("SaleDetail", "ID Sale")) and edit the list from there, is there a way to edit it in the SaleDetail_Form?

nb: I tried to find edit behaviour, but i can't find it also

        

2. in the Product Name, is it possible to search a product for partial match? or if it not, is it possible to adding category first, so it will make easier to find the product?

sorry for my bad explaining, and thanks before.

[Arni_Kli]

---

@dionvk wrote:

2. in the Product Name, is it possible to search a product for partial match?

---

CONTAINS()

Does text contain fragment? 

[Arni_Kli]

---

@dionvk wrote:

the problem here is currently im using [ID Sale].[Related SaleDetails] for the list, and i can't edit it, it can only show

---

What does edit mean? What do you want to do? Do you want edit child rows in the parent form? You can acsess them from parent detail view or from action button.

---

@dionvk wrote:

 [ID Sale].[Related SaleDetails]

---

Strange formula in my opinion

---

@dionvk wrote:

aREF_ROWS("SaleDetail", "ID Sale"))

---

and this one too

[dionvk]

as you can see in this form, there are a Table list of added product, and i want it to be editable, because when i click the row, it only show the detail.

somehow i only can do this expression  [ID Sale].[Related SaleDetails] so it can show the table list, i don't know the correct way.

aREF_ROWS("SaleDetail", "ID Sale"))->> there are typo. REF_ROWS("SaleDetail", "ID Sale"))

[Arni_Kli]

---

@dionvk wrote:

[ID Sale].[Related SaleDetails]

---

I can't understand why you need this [ID Sale]. Why don't you just use [Related SaleDetails]?
[Related SaleDetails] already contains a filter of the required child records.
If your Sale Details table has edit permission, then when you click on any row of this list, you will go to the detailed view by default where you can enter to editing form. Or configure the click so that the form opens immediately.

[dionvk]

because it on SaleDetails_Form, so i took the existing [Related SaleDetails] on table Sale using virtual column.

so the table column structure is like this:

Table: Sale
Key: ID Sale
Column: [Related SaleDetails]

Table: SaleDetail
Key: ID Detail

this [Related SaleDetails] on Sale_Form is editable, it have no problem, the problem in SaleDetail_Form i can't edit the table

[Steve]

If you save the Sale row and re-edit it, you cannot delete SaleDetail rows that were added previously. You can only delete SaleDetail rows that are added this time. This is just how the feature works.

[dionvk]

maybe i need to rephrase it so it will be more clearer

Table: Sale
Key: ID Sale
Ref: ID Detail
Virtual Column: Related SaleDetails

Table: SaleDetail
Key: ID Detail
Ref: ID Sale
Ref: ID Product

this is the general structure of the table, so the Related SaleDetails in the SaleForm will bring user to new form called SaleDetailForm, where user can adding product, and also i turn on Auto re-open so can make it easier to adding next product, 

then i want to add an inline to the SaleDetailForm so user can review for the added product and edit or remove the product without go back to SaleForm, so the process can go more quicker. so to show the inline i tried using [ID Sale].[Related SaleDetails], i tried using slice, and others. but now i run of option. if by default appsheet can't make it possible to edit the Related SaleDetails on the SaleDetailsForm i just want to make it can't be clicked, i tried to setting the behaviour on the SaleDetails_Inline on row click to edit, using action, or anything, but it looks like a default setting is to view details, and i can't even change the view on details.

so if there are any option left to do here?

im sorry if my explanation is lacking, because im not native english and im also a very new on this appsheet

[Steve · Accepted solution]

---

then i want to add an inline to the SaleDetailForm so user can review for the added product and edit or remove the product without go back to SaleForm

---

Not possible.