Expression testing works fines but figures do not display in table

[thrifty_test]

Hello am working on an inventory management app.

i have a select expression picking quantities from a purchase order table. when i test the expression in the app formula it shows results. it however does not display these results in the table when i view the data in the table…

SUM(Select(Purchase order[Quantity], AND([SubAsmid]=[_THISROW].[SubAsmid], [Purchase Order Status]=“Recieved”)))-[Commited]

[Suvrutt_Gurjar]

Hi @thrifty_test,

Could you please mention in what type of column you are using this expression? If it is a real column, then its changes will reflect in the respective record only when you open that corresponding record and resave it.

[Suvrutt_Gurjar]

Could you please also update what you mean when the values do not show in table? Do you mean back end table (spreadsheet or database table? )
Alternatively, if you are using expression in a virtual column , the column value will show in the app views but will not be saved in the back end table.

[Steve]

Note carefully:

Suvrutt_Gurjar:

if you are using expression in a virtual column , the column value will show in the app views but will not be saved in the back end table.

[thrifty_test]

Hello,
thanks for the quick response…
when i go to the view data in the view table part. no values are seen. Am not using the expression in the virtual column. am using the the expression in a real column.

[Steve]

App formulas for real columns are only (re)computed when its row is modified.

[thrifty_test]

[thrifty_test]

[thrifty_test]

the expression is in the instock column

[thrifty_test]

Hey Steve, i have done what Mr Suvrutt Recommended in his first post and it worked. am wondering if there is a work around to ensure the figures update automatically without opening and resaving each column.

[Steve]

In cases like yours, one would commonly use an action of type Data: set the values of some columns to update the columns as stock moves in and out.

help.appsheet.com

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

[thrifty_test]

let me read up and try it out… thank you very much