Forum Academy Marketplace Showcase Pricing Features

[SOLVED] Incremental index number every time a value occurs


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:

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!


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

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

This topic was automatically closed after 70 days. New replies are no longer allowed.