• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

Numbers formatted grab spreadsheet row not repeat

epinela

Member
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?
 

epinela

Member
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.

IMG_1705.jpeg
 

ArshilAhmad

Moderator
Staff member
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.
1696097816713.png
 

epinela

Member
I think I set up counter to increment up by 1 but it shows same starting number? Is this correct?
1696112685655.png
1696112630358.png
 

epinela

Member
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

Moderator
Staff member
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.
 
Top