# Passing data through nested relations **URL:** \ **Category:** Ask for Help\ **Created:** [July 8, 2022, 7:01pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149 "2022-07-08T19:01:28Z")\ **Posts on this page:** 14\ **Page:** 2
**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\ **Post date:** [July 9, 2022, 3:16pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/21 "2022-07-09T15:16:11Z")
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 ---
**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\ **Post date:** [July 9, 2022, 3:19pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/22 "2022-07-09T15:19:32Z")
Template for copying: [https://x-500.glideapp.io/](https://x-500.glideapp.io/) ---
**Author:** ![gwthmpsn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gwthmpsn/32/44800_2.png) [@gwthmpsn](https://community.glideapps.com/u/gwthmpsn)\ **Post date:** [July 9, 2022, 3:21pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/23 "2022-07-09T15:21:09Z")
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 ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [July 9, 2022, 3:21pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/24 "2022-07-09T15:21:50Z")
Interesting! Ya, your solution is pretty innovative. Love that it’s all housed in one sheet. ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [July 9, 2022, 3:54pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/25 "2022-07-09T15:54:56Z")
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! ---
**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\ **Post date:** [July 9, 2022, 4:00pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/26 "2022-07-09T16:00:27Z")
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! 🥲 ---
**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\ **Post date:** [July 9, 2022, 4:09pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/27 "2022-07-09T16:09:07Z")
Tnx, hope someone could take advantage of it, enjoy! ---
**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\ **Post date:** [July 9, 2022, 4:18pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/28 "2022-07-09T16:18:21Z")
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! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 9, 2022, 4:21pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/29 "2022-07-09T16:21:17Z")
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. ---
**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\ **Post date:** [July 9, 2022, 4:28pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/30 "2022-07-09T16:28:55Z")
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! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 9, 2022, 4:36pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/31 "2022-07-09T16:36:54Z")
Ahh, sometimes is case sensitive, so it would be mm for minutes, but MM or LL for months. > **[luxon - Immutable date wrapper](https://moment.github.io/luxon/?gspk=YnVuZ2Nob3dkaWdpbGVhcm44Mzg4&gsxid=EWgbrqjeJb77&utm_source=forum#/formatting?id=table-of-tokens)** > > Immutable date wrapper ---
**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\ **Post date:** [July 9, 2022, 5:59pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/32 "2022-07-09T17:59:22Z")
this is now ok: yyyyLLddHHMMss yields: 20220709180701 Typical undocumented feature! tnx anyhow! ---
**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\ **Post date:** [July 9, 2022, 6:00pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/33 "2022-07-09T18:00:10Z")
I am an innovation scholar and practitioner! 🙂 ---
**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\ **Post date:** [July 9, 2022, 8:35pm UTC](https://community.glideapps.com/t/passing-data-through-nested-relations/44149/34 "2022-07-09T20:35:19Z")
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? [Previous page](https://community.glideapps.com/t/passing-data-through-nested-relations/44149.md?page=1)