Hello, Iโve got a table data, and due to workflow constrains, only a daily data must be typed (it is easy to solve) but furthermore, every day have to exist one data. So, if a data isnโt entered today, tomorrow the app should warn, and it shouldnโt let you enter tomorrowโs data if you donโt enter todayโs one before. How can I do it?
I have tried to create a control colunm where I calculate the intervale between the date of 2 consecutive registers (It must be 1) and writing at the โvalid ifโ field ([_this]=1], but it doesnโt work.
Can somebdy help me?
Can somebody help me?
What about that ?
ISBLANK(
FILTER("yourDataLogTable",
DATE([TimeStamp])=TODAY()-1
)
)
it will return true if yesterdayโs input is missing
For reference:
Thanks. Your solution is fine but it wonโt let us type the โlostโ records , because this expression doesnโt depend on the date you are trying to record. So Inspired on your solution Iโve tried this:
valid if:: ( [_this] - MAX(โmyTableโ[date] )=1
And it works.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |