Randomize Name When Form Filling

[David Stein]

Is there anyway to randomize the name when giving a list of names to choose from?

[Jeevan]

The extension takes data from an excel sheet. One row of an excel sheet is considered as one entry. Whatever data you enter in that row does not change. You can randomize the names in the Excel sheet itself. Thanks

[Charli Smart-Kelly]

Hi David,

To randomise names, I set up a table named "lookup_name" in Excel with two columns -- "id" and "vaue", where "id" is numbers 0-999, and "value" is a list of names from an online random word generator. Then in the datasheet table ("datasheet"), I have a column named "generate" with each cell RANDBETWEEN(0,999)and then a column named "name" with XLOOKUP(datasheet[@generate], lookup_name[id], lookup name[value])

I have attached a quick example so you can see :)