[SOLVED] Incremental index number every time a value occurs

[appie]

Hello,

For some days I’m stuck with this one. I’m having a repeating group ‘Sales’ and I want to create an index column that increments +1 every time a certain product has been sold. In Excel I used the COUNTIF-function to do this, but I don’t know how to do this in Bubble.

Here an example where I filled the values manually:

Here’s the link to the app:
https://bubble.io/page?name=index&type=page&id=marmitex&tab=tabs-1

Above is a simple example, but in the real situation I would create the Sales on a API Workflow, so if there is a way to create this ‘Index column’ on the moment of creating the Sales would be even better than in a repeating group.

I hope some one can help me on this one. Thanks!

Appie

[pranjal]

Solved. Added the workflow to your demo app. Let me know if you need help understanding it.

Essentially: Sequence number = (Search for Sales, where Product = Input Product):count + 1

[appie]

Thanks for your help pranjal ! This is what I was looking for!