I have a table (Login)that the reception team (user) is presented with first via a form. All it does is capture a Principle’s name but adds logging information behind the scenes. All good so far.
I want to take that Principle’s name and then show ALL the appointments held in another table (Notes) to the user, so they can add notes after the appointment.
I created a behavior as follows and when they save the form it delivers them to the view filtered with the Principle’s name:
LINKTOFILTEREDVIEW(“Notes", [Name] = [_THISROW].[Name])
And that works as I expect in terms of rows returned. However, I believe that although AppSheet has accepted this and it appears to work, I’ve transposed the expression and it should be
LINKTOFILTEREDVIEW(“Notes", [_THISROW].[Name] = [Name])
When I test, either appears to work and everything appears good.
Question 1. Which expression is correct and why do both work? Do the columns have to be keys?
Question 2 - In testing phase, the team that enter the notes state that some notes are changing or disappearing. It looks as if the notes of one Principle are being over written with anothers or just removed. Is it because of the transposed expression?
I’ve created a workflow that delivers to me an email that shows each and every change in this table together with a change column to tell me when. Sure enough things have changed but I dont know how to diagnose as when I do it I cannot get any form of repro.
Thanks in advance.