Vanishing virtual columns on action

I have a button that adds a line to another table based on current row. When I press this button 2 of my virtual columns vanish. I have another virtual column that says though. The column that stays is LOOKUP([Total] in a database view)-LOOKUP([Subtotal] in that same database view) and the other two are
AVG(SELECT([Total] where vendor=thisrow))
and
SELECT([Total+Date] where vendor=thisrow)
The table I am adding a record to has no interaction with any tables I am looking up but I’m assuming it is recalculating the select statements when I do this action?

First thought - Do you have any Show_If criteria specified in the Virtual columns that are disappearing?

Beyond that, images showing us what you are seeing (or not seeing as it were) would be extremely helpful!

When discussing expressions, I (at least) would prefer the actual expressions rather than some shorthand. The expressions(-ish) you gave look suspect, but it may just be your shorthand.

In what views do the virtual column disappear? If in a detail view, the disappearance may indicate the column’s value became blank–AppSheet hides columns with blank values by default in detail views.

Virtual columns are recomputed when (among other times) the row is modified, as by an action or Quick Edit. So, the answer to this is yes: “I am looking up but I’m assuming it is recalculating the select statements when I do this action?”

LOOKUP([_THISROW].[Textract_Process_ID],“SubtotalVerificationView”,“Textract_Process_ID”,“TotalLineItems”)-LOOKUP([_THISROW].[Textract_Process_ID],“SubtotalVerificationView”,“Textract_Process_ID”,“TOTAL_AMOUNT_DUE”)

Average(Select(LastSixInvoices[Total_Amount_Due], [Vendor_ID]=[_ThisRow].[Vendor_ID]))

LIST(" “&SUBSTITUTE(
SELECT(LastSixInvoices[Total and Bill Date],[Vendor_ID]=[_THISROW].[Vendor_ID]),”,","
"))
Those are the 3 formulas in the order they are in my original post

1 Like


This is before I press the button

This is after I press the button. The 2 columns return after a few seconds.

2 Likes

This suggests the disappearing columns may use values from a table that changes as part of the action. They then reappear when the background sync occurs and everything gets recomputed.

1 Like

@Austin_Lambeth I agree with Steve. Additionally, Detail views, which are the views on the left-hand side of your images, have a default behavior to NOT show columns that are blank.

Is there some processing attached to or initiated by the button click that removes rows from the “SubtotalVerificationView” table?

One idea to resolve the disappearing columns and inform the user, is to display some informative text while the re-calculation is happening (if indeed this is the issue). Test if the returned value ISBLANK() and if so show “processing”.

The action is to add a line to the Invoice Details page which has references to the Invoice Header which is where the columns are disappearing. Additionally the LastSixInvoices is based on Invoice Header in database. LastSixInvoices has no references within appsheet and both disappearing column are based on that table. image

Deleting the reference from Detail to Header removed the issue. Since the action was adding a detail it was updating the related details column which caused all other columns to recalculate.

2 Likes