(Solved) AppSheet update just broke my app? (need alt way of knowing what's currently selected)

[Progplmb]

EDIT 2

I literally just turned off Interactive Mode and it works perfectly now, like it did before. Typed all of this out and it took one click to fix.

EDIT

I'm dumb. I just realized what happened.

I have a join table and everything set up (thanks,(URL Removed by Staff)) so Agendas can have multiple Tasks and Tasks can be on multiple agendas. This morning I decided it's not worth the added complexity and performance hit, and decided to only allow Tasks to be assigned to one Agenda and we can just make duplicate Tasks if we need them on more than one Agenda.

So I added the Ref_Agenda column to Tasks.

In Interactive mode, if the tables of two views reference each other, then when selecting a row, the other view will only show rows relating to that selected row. This wasn't an issue before because the references were contained in Task_Agenda_Assignments, which isn't in the dashboard. But now that there's a direct reference between Tasks and Agendas, the Task list only shows Tasks related to the selected Agenda.

So now I gotta find a way around that. Make the dashboard non-interactive and figure out how to have the Detail view show the selected Agenda? Use a simpler join table which doesn't require looping? Are there other options?

----- original post:

So I have a dashboard view ("Agenda Maker") with a card list view of Agendas on the left, Agendas_Detail in the middle, and card list view of Tasks on the right.

The goal:

• Be able to select an Agenda from the list on the left

• See the selected Agenda details in the middle (showing list of Related Tasks)

• See a list of unassigned Tasks on the right

• Be able to click an "Add to Selected Agenda" action button on a Task.

The only way I could figure out how to get the ID of the currently selected Agenda was to make a table called Var_Selected_Agenda, and then made a grouped action which is triggered when an Agenda card is clicked. The action:

1. Adds a new row to Var_Selected_Agenda containing the Agenda_ID

2. Uses LINKTOROW([Agenda_ID], "Agenda Maker") to navigate to the same dashboard view but with the Agenda selected.

Then I use MAXROW() to pull the Agenda_ID from Var_Selected_Agenda and add it to the Task's [Ref_Agenda] (and I have a bot to delete the other rows so it doesn't just keep building up)

This was all working perfectly (implemented a week ago). But now today, when I select an agenda, the list of Tasks on the right goes blank. The Task list view is still there, but it says "No Items."

If I open a different view and then go back to Agenda Maker, it shows the list, but then when I select an Agenda, everything else works the same except that the list of unassigned Tasks goes blank.

This is a crucial part of my app (which is going to be used to manage my company) and it has me worried that after the app is deployed, AppSheet could at any time release an update that breaks it. Do AppSheet updates automatically apply to deployed apps too?

I'm hoping something else is the issue but I don't think I've made any changes today which could possibly cause this, and I also noticed that all views now have a "Show if" field which I'm pretty sure wasn't there yesterday, though there are no release notes referencing that.

Does anybody have any ideas?