Record radom option set

[thomascope]

Hello everyone,

I have an option set name OS with few options
OS_1
OS_2
OS_3

I would like to record randomly an option set when I click on a button.

For example :
I have a table USER with :
Field_Name
Field_OS

In the app:
I have an input and I write a name
I click on a button “Let’s go”
And Bubble choose OS_2 for the field Field_OS next to the field Field_Name.

How could I do it?

Thank you

[davidb]

Consider the :random item operator.

[thomascope]

Thank you for the documentation.

I did like it :

How could tell at Bubble, don’t repeat the Option set twice ?

Thank you

[davidb]

Full list followed by :minus list followed by :random item.

[thomascope]

I don’t get it.
I think I understood the logic but I don’t achieve it.

With this formula, t does not workd, I have nothing selected :

Thnank you

[davidb]

All OS_role:minus list [insert here the list you want to exclude] :random item

[thomascope]

Hello David,

It works !

Below the right formula

Thank you a lot !