child table value not reflecting in parent table

AppSheet AppSheet Q&A
1

I have set up an “is a part of” child table to which I have populated it with values, then it is supposed to give that value back to be calculated in the parent table on the fly.

child value - 1000

parent value initial stock 8000 minus parent closing value 7000 = [supposed liters sales] which are the child values of 1000. but the answer column is not picking up the child.

no error and my expression to extract the child is:

Sum(Select(Borrow and Return[Borrowed & Return Liters],
And(OR(“Borrow By”=[Borrowed & Return],“Return To”=[Borrowed & Return]),
[Product Name]=[_thisrow].[Product Name],[OrderDetail Id]=[_thisrow].[OrderDetail Id])))

Mario_Moncada_1-1667008365444.png
Mario_Moncada_1-1667008365444.png794×682 12.6 KB

2

Is this using the Desktop Mode beta?

1 Like
3

i am using desktop, yes

4

This is a known problem of that preview feature

2 Likes
5

thanks, i managed to resolve this by changing my expression using the related column.

SUM(
select(
[Related Borrow and Returns][Borrowed & Return Liters],
And(OR(“Borrow By”=[Borrowed & Return],“Return To”=[Borrowed & Return]),
[Product Name]=[_thisrow].[Product Name])
)
)

6

Desktop view is in preview and is not suitable for use in any important app.

Please report problems with the desktop view preview here:

In Preview: New UI design for desktop users - Google Cloud Community

1 Like
7

Merhaba

Alt tablolarda güncelleme yapınca, üst tablodaki toplamda kendiliğinden güncellenebilir mi?

8

It should if you use a virtual column holding the total by doing a SUM() to the child records using a List Dereference.

Or a real column and an action updating the parent.

SUM() - AppSheet Help

Dereference expressions - AppSheet Help

1 Like