Hi all, I am new to appsheet, and I am planning to create a new app, which is similar app to this, but instead of timesheet and timecards based on USEREMAIL(), I need to be calculated with Employee ID with a 6-digit number. I have tried it, but it is not working.
SUM(
SELECT(TimeCard[Calculated Time],
AND(
[Employee ID]=USEREMAIL(),
[WeekNum]=WEEKNUM(NOW()),
[Day]=1
)
)
)
Solved! Go to Solution.
@Teja1112 wrote:
[Employee ID]=USEREMAIL()
The USEREMAIL function returns the email address of the signed-in user. So, that will never match the value of the Employee ID column if that's a "6-digit number". If the Employee ID value is available in the table that your expression is associated with, you can probably use the following in place of USERMAIL:
[_THISROW].[Employee ID]
If your use case nonetheless involves displaying information based on the current user, there are lots of valuable techniques you may be interested in. See SUMMARY TIP: User permissions, roles, and settings - Google Cloud Community .
@Teja1112 wrote:
[Employee ID]=USEREMAIL()
The USEREMAIL function returns the email address of the signed-in user. So, that will never match the value of the Employee ID column if that's a "6-digit number". If the Employee ID value is available in the table that your expression is associated with, you can probably use the following in place of USERMAIL:
[_THISROW].[Employee ID]
If your use case nonetheless involves displaying information based on the current user, there are lots of valuable techniques you may be interested in. See SUMMARY TIP: User permissions, roles, and settings - Google Cloud Community .
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |