I want to know is there anyway to random the value after save the form? Now, I can random automatically when open the form but i want it to random after save the form.
What do you want to exactly achieve? Better to elabrate what you are aiming for.
Randbetween will generate the randam number automatically. Similarly uniqueid is going to genereate the unique strings, which it can be construed as randam value as well.
Are you looking for something else?
1 Like
Now, I used the formula (randbetween() with no the same value in the loop) that will random values immediately when i open a form to fill. But the problem is when 2 users fill the form at the same time it will be same value when they submit the form. It will ruin my flow. So, I want to know how to random after submit the form. I think this solution will help and not ruin my flow. (I don’t know if you understand this. I’m not that good at english.)
I did not know randambetween expression will generate the same value when the users add new row concurrently. Then sounds like you need to avoid to use that expression.
What is your ultimate goal? Just to get randam “number”? Randam string/texts are not workable?
[Auto - sequential numbers, using Googlesheet formula - no duplicate!](https://community.appsheet.com/t/auto-sequential-numbers-using-googlesheet-formula-no-duplicate/26201) Tips & Tricks ?
“To get the auto-sequential number” without duplicates is one of the frequent question and ask here in the community, but there is no native and perfect solutions available for the time being. This is not a perfect solutions, and I m not strongly recommend to implement this tricks into your production app as I m not sure how it will be stable in terms of the performence, but at least, my quick test showed positive result to generate the sequential number dynamically, using Googlesheet formula. …
Could be one of the solutions worth thinking ?
Concact the uniqueid() and randambetween ?, expression like
Uniqueid()&randambetween()
?
There will be always a solution with you.
1 Like
Why do you want to do this?