Hi everyone. I have spent absolutely hours trying to resolve this and scouring google, but no luck! I really hope somebody on here can help me!
In my app, when somebody visits a school, they fill in a "school visit form". When they fill in the form, they can select the school and teacher using dependant dropdowns. Now what I'm trying to get it to do, is to work out what the teacher's previous target was. This information comes from the same table ("Visits"). So I want Appsheet to search through the selected teacher's previous targets, and then EITHER display a list of all of their previous targets, so the user can select the most recent, OR (I gave up on this ages ago), display only the teacher's most recent target.
Based upon trying to do the first one (displaying a list of the teacher's previous targets), I have been trying various combinations of this formula:
SELECT(Visits[New target], ([Teacher name] = [_THISROW].[Teacher name]))
Appsheet says the formula is valid, but when you go to the form, this part just isn't showing at all. I read that this is likely because it can't find the values, so I'm wondering if I've missed something out in the formula. Or, is there a specific "type" it needs to be to ensure it shows up in the form? (I've already checked "show?") Or is there something else I need to put into the data validity or auto-compute to make this work?!
Sorry if this isn't very clear. Essentially, I want it Appsheet to see the name of the teacher selected, and from that show all the targets assigned to that teacher, so that the user can select the most recent one from that list.
Please help!! THANK YOU!!
LinkedIn
Twitter
