Field with App Formula Not Updating After Unarchiving

AppSheet AppSheet Q&A
,
1

I’ve created an Archiving Unarchiving system with actions. Action button copies then deletes Parent and Children from Table A1 to Table B1 (parents) and Table A2 to Table B2 (children). One of the fields in Table A1 is a PO Total field with this:

SUM(SELECT(PO Items[Extended Price],[PONumber]=[_THISROW].[PONumber]))

This works great as is. But when I unarchive a Parent and it’s Children, of course the Total field doesn’t get updated during sync, only after edit and submit. So I created a Virtual column, vPO Total, with the above code and set PO Total to vPO Total.

But PO Total is still not updating after sync. I would rather not use a Virtual column at all with this (only because of sync time).

Any help would be much appreciated. Thanks.

2

Your virtual column should be updating automatically on each change of the PO Items rows filtered by your Select statement, you may want to contact support about it.

Now, if you go the real column with AppFormula route, just add a number column that’s hidden and updated via action so that you can make sure the row is updated → the formula is updated.

You can then call this action from anywhere your app

1 Like