I couldn’t understand it
In this table if there is NO row yet for today, then my view should show.
If there is already rows for today date, then the expression you wrote for me works. But if there are NO rows yet for today I need it to show.
Here is the view I am trying to show IF:
What you gave me worked fine. But I did not consider when the new day starts. ISNOTBLANK… will not work. I need to show this when there is a new day = meaning NO rows for the day have been logged yet.
Ok. What is the response from the expression assistant?
ISBLANK(any(FILTER(Timecard,
AND(
TODAY() = [Date],
USEREMAIL() = [Employee ID]
)))),
so when I add the ISBLANK… NO errors. However, the view shows ALL the time and NEVER goes away?
Wait. So now IT DID GO AWAY?
Hang on…
It’s acting strange. sometimes it goes away (as it should) and sometimes it does not?
I added ANY to my expression like yours but the “Clock In” button still shows EVEN though it should not be:
Right now according to my table - the “Clock In” Button (above image) should NOT be showing as the employee is “Clocked in” already:
This is my updated expression (no errors):
OR(
ISBLANK(ANY(FILTER(Timecard,
AND(
TODAY() = [Date],
USEREMAIL() = [Employee ID]
)))),
ISNOTBLANK(
MAXROW(“TimeCard”,“_RowNumber”,
AND(
TODAY() = [Date],
USEREMAIL() = [Employee ID],
ISNOTBLANK([Time In]),
ISNOTBLANK([Time out])
)
)
)
)
I want to look under the hood bro.
How do I share the app with you?
Even when I test the expression it CLEARLY states (NO) the view should NOT be shown and yet it still is?
My email id (PII Removed by Staff)
Give editor access of the app.
Sorry for the delay I had to ask my boss for the ok before sharing this. I will try and share it with you today.
Sorry, what is your email please? I want to give you access.
.
Sent in pvt
I sent the app link email to you. I wasn’t sure if you had a chance to look into my app yet.
APP name…?
TS - JOB BOARD
There are several tables, slices, actions. I could not find where it it.
