To Calculate the count of New Entries

Sandhiya07

Hi,

I'm Uploading the Attachment 4 times in a Day, I need to calculate the new rows added every time. Kindly suggest some logic to achieve this.

Example: At 10 AM, while Uploading Data, 2 rows are newly added, now count will be 2.

Again 2PM, while Uploading Data, 3 rows are added, now count will be 3. it should not show 5.

Thanks,

Sandhiya P

Gia Thinh

Hi @Sandhiya07,

Try this way.

You add a helper column "New row" and create 3 workflows.

1st change cell value workflow will change "New row" to "checked" when new rows are added

2nd change cell value workflow will run everyday on 11AM to unckeck all rows that have "checked" value

3rd change cell value workflow will run everyday on 3PM to unckeck all rows that have "checked" value

So before 11AM and 3PM, you can count all rows that have "checked" value

Hope that helps.

Gia Thinh

Hi @Sandhiya07,

Try this way.

You add a helper column "New row" and create 3 workflows.

1st change cell value workflow will change "New row" to "checked" when new rows are added

2nd change cell value workflow will run everyday on 11AM to unckeck all rows that have "checked" value

3rd change cell value workflow will run everyday on 3PM to unckeck all rows that have "checked" value

So before 11AM and 3PM, you can count all rows that have "checked" value

Hope that helps.

Sandhiya07

Hi @Gia Thinh

Thanks for your reply. It's working.