About punkshift

punkshift · 09-10-2021

I have Assets Table and Asset Checkin Checkout Table. I’m trying to count how many times an asset has been checked out. In the Assets Table, I have a virtual column that counts the Check Out Date of a specific Asset Tag # with this Expression: COUNT(...

punkshift · 09-07-2021

I have two tables, one is Assets, the other one is Asset Checkin Checkout. I’m trying to change the value of the Status column from “Ready to Deploy” to “Deployed” under the Assets if a device has been checked out in the Asset Checkin Checkout sheet....

punkshift · 09-13-2021

I tried your suggested expression, however, it didn’t work for me or I just didn’t do it right. lol Anyway, upon looking at the links you provided this is what I came up with: COUNT(FILTER(“Asset Checkin Checkout”, AND(ISNOTBLANK([Check Out Date]), (...

punkshift · 09-07-2021

@Aurelien The FILTER() worked like a charm!

punkshift · 09-07-2021

@Aurelien Thanks for the suggestions, I’ll try these. Oh, and for this part: punkshift: when I’m trying to add a new entry in the Checkout form, it’s not changing the status The Checkout form is another table. And when Im trying to add a new entry on...

punkshift · 09-07-2021

@Aurelien Thanks for the welcome. I don’t quite get what you’re suggesting. How do I use that? Also, I am trying to do the instructions here: Changing Data from a Bot, Workflow Rule or Scheduled Report | AppSheet Help Center If that will help.

My Stats

Narek's Bio

Badges punkshift Earned

Recent Activity

Counting wrong

I think im doing it wrong; SELECT() Expression

Re: Counting wrong

Re: I think im doing it wrong; SELECT() Expression

Re: I think im doing it wrong; SELECT() Expression

Re: I think im doing it wrong; SELECT() Expression