I’m doing a schema that includes 240 records with each record having a timestamp. How can I have the last record be the current time with each previous record 3 minutes apart? Can the date also be today, instead to selecting a actual date?
Hi @eddie_nunezt
Assuming you have the default row as id row number, then add a field of type formula and set the formula to be:
now().utc-minutes((240-id)*3)
1 Like
@mp_np , thanks for the suggestion. I wasn’t able to get it to work doing that; do you happen to have an example schema?
Hi @eddie_nunezt try https://www.mockaroo.com/f0f93f40 - I’ve set it to 100 so you can view it working in the preview, but just replace 100 with 240 in your example.
You need to scroll down to the bottom to check after you’ve run preview as you wanted the last to be now, and each previous 3 minutes earlier.
@mp_np , now I’m realizing why you mentioned “assuming you have default row as ‘id row number’”. It works well the way you used it, however, I’m working with a json object with an array that will include a UTC timestamp and value. I don’t use “id” anywhere in my json formatting. Is there a way to do it in the “timestamp” for every item in my custom list as I have it here: https://mockaroo.com/schemas/109114 ?
Hi @eddie_nunezt. To share a schema, you need to use the Share link which is below the download and preview buttons. Schemas under your own login look like this: https://www.mockaroo.com/schemas/108856
and can’t be accessed by others unless you share the project with them. Share links look like: https://www.mockaroo.com/f0f93f40
However, I have modified my example to use a hidden row number field. Simply use 2 x underscore (_) in front of a field name and that field is hidden from view in the mock data, though you can use it in formulae.
So the row number field becomes:
__id
Note, you could call this __row_number for clarity in your own project
and the formula becomes:
now().utc-minutes((100-__id)*3)
(replacing __id with __row_number if you change the name)
Here is an example that may work for you: https://www.mockaroo.com/492c9f30
@mp_np , perhaps I’m not setting up my json arrays correctly? I have the parent object names “dataTypes” that only appears once, in that object I have a list that displays the value and timestamp. If you press “preview”, this is exactly how I would like it to appear for the exception of the timestamp not doing what I would want it to do. Is there a way to add that formula using this schema I’ve created?
Hi @eddie_nunezt - as your rows are within the JSON array, you need the rownumber hidden field to be within the JSON array so it increments.
See modified example of yours: https://mockaroo.com/624399a0
@mp_np you nailed it!! I should of known to have it within the array. Thanks for taking the time, really appreciate this!
The timestamp using UTC with each that latest being the valuable so https://netgears.support/blog/netgear-r6700-nighthawk-ac1750-review/ the user will get the solution to understand the part perfectly to manage it.