Hi team, as per the subject, I have a small project I am working on for myself as a learning exercise (it’s a personal recipes database, and am trying to set it up to find any matches on rows that match a certain string - ie. looking for an ingredient, etc). In the project, I have a Google Sheets data source with 3 tabs - one with the source data, one that will be used purely for filtering the data, and the 3rd for doing the actual filtering.
The issue I have is that, for some reason, I’ve been unable to get my app to update cell A2 in the filtering tab. It simply does nothing.
This is the cell I am trying to update, on the “Filter” tab (potentially expanding this out, but for now, I am concatenating all the source fields in order to simplify doing a fuzzy search/filter for partial matches - I just need to be able to update this particular cell with the search string the user has entered, in order to facilitate the filtering):
The tabs I have in my sheet:
This is how I have the block set up to do it (the logic I’ve used for this, is that once they’ve typed a few characters, it’s enough to start filtering on, at which point I want it to update cell A2… which the filtering in the View_Table tab is set up to atuomatically filter the data on. I’ve tried both 1 and 2 for the index, just to see if I could get it to work, but it just does nothing):
I’ve been looking over a number of different topics on this, tried Google, CoPilot, etc… and so far am drawing a blank as to why this is refusing to write… the data connection is fine, as I am able to pull data from the main table without issue - I can also pull it from the View_Table without issue.
Suggestions/comments/questions very welcome 
