Help!! I have 2 comumns. 1 for Student name(...

AppSheet AppSheet Q&A
1

Help!!

I have 2 comumns. 1 for Student name(Name) & 1 for log in (DateTime). I hv a view named’Not loged in Today’. What will be expression for this view, so that it will get me the all the students who are not loged in today??

Urgent?

2

Do you have another table where you have all user names?

3

Yes

4

DATE(MAX(SELECT(LoginTable[DateTime],[Name]=[_THISROW].[Name])))<>TODAY()

5

Not working!! Error in expression ‘[_THISROW].[কর্মকর্তার নাম]’ : Unable to find column ‘_THISROW’

I used this expression in show _ if:

DATE(MAX(SELECT(বহিরাগমন রেজিস্টার [লগ ইন],[কর্মকর্তার নাম ]=[_THISROW].[কর্মকর্তার নাম])))<>TODAY()

Translate

6

@Aleksi_Alkio

help!!

Translate

7

Are you using this formula in Users table?