Hi guys, I’m building an app that lets you check-in / check-out items at different stores as a logged user.
Basically you will login with a profile and then in each store you have a form for check out and a form for check in. (When the QR scanner is availalbe it will be much easier, for now they need to introduce the number of item by hand)
To this point all good:
- I have a table with my users that translates into a tab with user info using DETAIL LAYOUT
- I have a table with my stores info where people can check in and out and the info like email, date and location get stored using MAP LAYOUT and FORM BUTTON.
- I have a table where all these events (checkin/out) are stored and with ELSE->THEN feature I can create a message saying: THIS IS OUT / THIS IS BACK
1) Showing status to user:
I’d like to use the RELATION to show a user if currently he/she has an item checked out or in. The problem is that the relation only picks the first entry where that user checked out. Any way to tell that it should pick the last one?
2) Showing the number of checks out this user has done
I’m not sure if this is possible with the new Data Features, I’d like to do a Rollup and show it of the number of times this user has checked out in any store. Should I do this in Sheets? I haven’t been able either to find the formula