LinkedIn
Twitter
I am brand new to App Sheet and trying to create my 1st app. I have read several other posts regarding this topic but have not found one to address my specific issue. I am trying to use the conditional behavior logic contained in one of the existing templates around attendance with some slight modifications. I have used an attendance log in my source data and a virtual column called "Log Check".
This is all set up very similar to the example template but I have simply replaced email with an ID # and I have more than one Course ID. I tried to use the "Contains" conditional filter, replacing the email variable with the ID #, things are not working. The concatenated values on the the virtual column are working correctly but the conditional logic will not accept the new variables and it keeps asking me about a column that is not in the Attendance Log Table or the Log Check Column . What I am I doing wrong?
Log Check Test:
Conditional Statement
Marc - I believe the table is the Log Check which is created by the virtual column. Again this expression was included in your attendance template so I can't claim to fully understand what it's doing. But here is the expression again:
CONTAINS(Attendance Log[Log Check],[Email]&[Course]&TODAY())=FALSE
And here is a screen shot of the table generated by the Log Check
And here is the expression that generated the Log Check table:
[Student ID]&[Course]&[Date]
Again, I don't fully understand how all these pieces are working together but I do understand that the Log Check generates a concat field for student ID, course, and date. Then it looks like the conditional expression for the Action is telling the system to hide (not show) the action button if the concat field in the Log Check contains student ID, course, and today's date... at least that what I want it to do. ๐ Can you help me get to that state?
