About kgrapes

kgrapes

this seems fairly simple, which is why it's driving me to levels of insanity. IFS( [RECENTCOUNT].[DATETIME] > (NOW() - "000:30:00"), LINKTOVIEW("DROP CASH"), [RECENTCOUNT].[DATETIME] < (NOW() - "000:30:00"), LINKTOVIEW("COUNT DRAWER DROP") ) if you c...

kgrapes

so, after exploring everything and nothing making sense i decided to see what would happen if i tried to actually view these references in the app. all references, but this reference were working. so i went back to my formula in the virtual column MA...

kgrapes

yes, as an action. if they hit the button taking them to the view it should force them to count if no count has been added in the past 30 minutes, otherwise it will take them directly to drop. the issue trying to be solved, is that gsheets is being u...

kgrapes

not having any luck still, interestingly if i change it from NOW() to TIMENOW() it reverses the resulting view, no clue why. have ripped this apart and broken it down in every way i can think of and it's simply not working. i havent been able to get ...

My Stats

kgrapes's Bio

Badges kgrapes Earned

Recent Activity

datetime arithmetic

Re: datetime arithmetic

Re: datetime arithmetic

Re: datetime arithmetic