Get Record IDs from Report Link
I have three tables Templates, Template_Events & Template_SubEvents. Templates has a relationship with Template_Events, Template_Events has a relationship with Template_SubEvents, and Template_SubEve...
Forum Discussion
If I'm understanding the basics of what you want to do, I wonder if you could get what you need by creating a couple combined text summary fields of the record id's of related records as well as a formula field?
| Record picker field | Combined text summary of 'Record ID#s' | Combined text summary of 'Children' | Formula to compile Children & Grandchildren into a text list | |
| Record ID# | Parent Record | Children | Grandchildren | All children |
| 1 | 4 | 2;3 | ||
| 2 | 1 | |||
| 3 | 1 | |||
| 4 | 1 | 2;3 | 1;2;3 |
You could likely do something similar using a single formula query, but you'd need to add criteria to the 'get records' portion of the formula - right now looks like it's just returning fid 178 for all records on that table where the value in fid 228 > 0.
From what I'm reading it sounds like you would want to search the table for records that are related to the current record (aka children) and records related to those children (aka grandchildren).
The page I find the most when building formula queries is here, I'd highly recommend it: https://www.quickbasejunkie.com/blog/formula-query-functions
Hope some of that is helpful!
Thank you for the reply! Yes, that does help! Right now I've been able to make it work with Pipelines, but I would rather have something that will update in real-time. Again, thank you!
