If you don’t have date column, you get random order of the entries of the same level within one parent., eg:
Topic 1
Child 1.3
Child 1.1
Grandchild 1.1.2
Grandchild 1.1.1
Child 1.2
Template for copying: https://x-500.glideapp.io/
This is great!
For all date formatting issues, try the computer column type Other > Date & Time > Format Date. It’s been so helpful for me haha
Interesting! Ya, your solution is pretty innovative. Love that it’s all housed in one sheet.
In this example is Miro setting the column values in one step, having Glide create the template, then using that template value in the following set column value to create a basic column therefore avoiding Glide ‘discovering’ a circular relationship?
I thought this didn’t work because of timing issues with Google sheets or do computed columns get updated immediately?
Thanks as always!
You are most welcome! It was nice challenge for me and it brings me back some 50 years ago when I was in good shape for programming!
Tnx, hope someone could take advantage of it, enjoy!
Good, but which are the valid templates for date format, e.g. for YYYYMMDD ?
With that I get weired stuff: YYYY079. srp 2022.
Only MM is correct!
Using the date format plugin countries that don’t follow a MM/DD/YYYY format can cause issue. It’s generally recommended to avoid using any date plugins if your country uses the DD/MM/YYYY format.
everything is ok, only “MM” stays now for minutes!
yyyymmdd yields 20221309 , where “13” stays for 13 minutes! This is a bug due to ambiguity of M for minutes of months!
Lets stay by date arithmetics, fuctions ok!
Ahh, sometimes is case sensitive, so it would be mm for minutes, but MM or LL for months.
this is now ok: yyyyLLddHHMMss yields: 20220709180701
Typical undocumented feature! tnx anyhow!
I am an innovation scholar and practitioner!
Sorrrrrrrrry folks, if you try to reproduce this “innovation”, it looks like the chef who gives the recipe with missing basic ingredient, by purpos!
Main gimmick is: how do you get the parent RowID in the child row?