Solved: Detail View "Clears" after new row is added - Page 2

Matt_Myers · 02-13-2021 02:36 PM

Hi, I have a Deck with a Grouped Action tied to the Row Selected event. The Grouped Action does two things:

Add a new record to a different table (an activity logging table). Using this: Data: add a new row to another table using values from this row.
Show a detail view using this: App: go to another view within this app

The Grouped Action works when I select a row in the deck. The record IS logged in the table and the detail view is rendered properly. The PROBLEM is that after a few seconds the Detail View just “clears” and the view is a blank screen (the data is cleared out). Does anybody have any thoughts on this?

Screenshots:

The Deck:

The Detail view BEFORE it "clears"

The Detail view AFTER it "clears"

The Actions

Matt_Myers

For what it’s worth I figured out what was happening here. The action Data: add a new row to another table using values from this row caused some Random Number formulas I had set up in the source spreadsheet to recalculate. Those same random numbers what is used to SORT the underlying DECK view I have (I may need to re-visit sorting off of a Random Number formula…the idea though is to give the user some variability in the results they see). When the Random Numbers recalculated it resorted the deck which ‘moved’ the “current row” apparently which caused the detail view to kind of lose it’s place so-to-speak.

I change the Data: add a new row to another table using values from this row to update a completely separate spreadsheet (so the Random Number recalc’s aren’t triggered in the main source spreadsheet) and the issue was resolved.

View solution in original post