How can I modify the Time field to output numbers in 30 minute intervals

#1

I am gonna be using this information for a predetermined checklist that will not accept anything such as 12:39, 12:45 etc. It’ll only take inputs such as 12:30 or 1:00.

I have tried with the formulas to be able to do it however, even with the help of StackOverflow I wasn’t really able to get it working. I usually get this error: “error: Could not access blank value: Use || to provide a default value for blank fields. Example: (my_field || 0) + 1PM”

Any recommendations on how to create random instances of times?

Thank you very much in advance.

#2

Use the custom list type for any fields that have a finite set of values. Or if you have a really large list of values, put them in a CSV file, upload them into Mockaroo as a dataset and then use the dataset column data type.

#3

Thank you :slight_smile:

#4

Your solution worked, however this program is expecting a datetime data type. Is there a function that you would recommend for this?