Numbers formatted grab spreadsheet row not repeat

[epinela]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZmMDYzMDA0Mzc1MjZmNTUzYzUxMzEi_pc

Hi!
I have number formatted choosing a random number then searching themsheet row. The challenge is, I am using this for social media automation and by chance it chose the same number twice, and the same article showed twice in a row.

Is there a better workflow to achieve this or a way to have force choose a different random number incase it accidentally chooses the same number back to back?

 

[Pabblymember11]

Hey @epinela

Can you please briefly elaborate on your concern, so that we can look into it and help you accordingly?

 

[epinela]

I need it to select a random topic from the spreadsheet, but avoid selecting the same number in a row. This is for social media and it by small chance chose the same number twice in a row and posted the same blog link twice. I need to avoid the last chosen number.

 

[ArshilAhmad]

You can try using the Counter feature, which provides sequential numbers. While this won't generate random numbers, it ensures that the numbers are not repeated.

 

[epinela]

I think I set up counter to increment up by 1 but it shows same starting number? Is this correct?

 

[ArshilAhmad]

Yes, it is correct.

 

[epinela]

It does not appear to be counting up. It posted "row 2" twice.

 

[ArshilAhmad]

Set Reset on Execution to 'No' and see if this fixes the issue for you.

 

[epinela]

Thank you. I would then ask when it reaches the last number, does it automatically start from the beginning again? So 2-34 but after 34, it resets?

 

[ArshilAhmad]

Yes, once it reaches the Final Value (34), the counter will reset to the initial value (2). If you don't want the counter to reset, you can keep the Final Value field empty.