I want to create random times for an attribute named ‘length’ the Table is called ‘CD’. So basically it’s the length of a song. I want the minutes to be equal or less than 6. So allowed values are in between 00:01 and 06:00. How can I do that with mockaroo?
Hi ahu,
You probably don’t need this anymore, but it was a nice exercise as I’m trying to learn Mockaroo.
Create a Number field that will generate between 1 and 360
Create a formula that will convert that to a time.
Here’s an example: Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel
Image in case I delete the above example one day:
There’s probably a nicer way to do that. I tried using rand in the formula, but got an error that’s not permitted. I don’t use Ruby outside of Mockaroo, so I wasn’t able to figure that out.
HTH,
Paul