add the current row to the count in the google sheet

[pangalawang]

my aim is if I have this one TM in the g sheet, and I input the same TM in the current row, I  would like to automatically add that current row to the total count that this TM existed. simply, if this TM is already in the G sheet then the total count that this TM exists should be two times.

This expression doesn't do that:

Count(Select(Timesheet[TM Number],And([TM Number]=[_thisrow].[TM Number],[Date]=[_Thisrow].[Date],[Shift]=[_thisrow].[Shift])))

0 Likes

[Austin_QREW]

Hi @pangalawang,

Great question! Here is the expression we use in our timesheet app to calculate clocking-in/out:

Total Hours:

SUM(SELECT(TimeCard[Calculated Time],
AND([Employee ID]=USEREMAIL(),
[WeekNum]=WEEKNUM(NOW())
)
)
)

Copy & Customize: Timesheet App

If you want to learn more about logic and expression we also have this course available here. 

Let me know if you have anymore questions, I will try to help in any way I can.

Thanks,

Austin from AppSheet Training

[pangalawang]

Hi Austin,

my question is how do I count a certain item or value ? one is in G sheet and the other is in the current row. Specifically, I need to count if the TM appears 2 times at the same shift.  App supposed to pickup the same TM already in the G sheet and supposed to add the new record while inputting in the app.

example:  if this TM : name "Tugue" already in the PM shift, which already in G sheet, i need the app to show that her name is now second time appears.

[Austin_QREW]

Hi @pangalawang, 

Thanks for the updates. Looks like you are trying to monitor within the app if there are duplicate clock-ins for the same shift and employee.

If you are wanting to show this in a view you could simple use the COUNT feature in the UX Tab as shown below: 

Count Employee Timecards View

Let me know if this is what you are looking for or if you need some more assistance I would recommend connecting with @Cale_QREW to sign up for a Free Tech Talk. You can sign up here: https://calendly.com/cale-9/tech-talk 

Thanks,

Austin from AppSheet Training