Calculation Field - Random number

🙏 Ask the Community
1

Hi, I build URL string in calculation field and need cache buster. Will it be possible to get random number calculated each time the record is open, such that the number always changed.

Thanks

2

To my knowledge I don’t think this is possible. Even if you set up a random number inside of a calculation field it would only repopulate if the calculation field is updated itself. That keeps you in the same position with the URL

Int the past we have created a single select field called “refresh” or “reload”.
Then we call it inside of our calculation field that we want to be updated so that when the single select field is selected it displays a space ’ '. And when it is unselected it displays nothing ‘’.

Then we set up a simple automation on the back end that says when the single select field is updated, unselect it.

This forces the calculation field to reset.