I have an issue with initial value i need help with. In my app we register time spent on a job. Basically date (TODAY) and the from time (TIMENOW) to time (TIMENOW+1). So lets say they register their first job in the morning from 8 to 11 am. For their next register i want the from time to be equal to the last registered to time from the spreadsheet in the background (smartsheet). Witch expression should i use to get that info in inital value based on the date being the same as last registered, the useremail being the same and the last registered to time in a row? Is it even possible?
If everybody always registered everything in through time every day the app works with the setup. But if they have to register for a few days back they need to change date, from time and to time for all the registrations.
I think some combination of a select statement combined with maxrow would work. Need more details as to how your table is setupโฆ
Thank you! I will look into this. And come back to you if i canโt get it to work
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |