I have been playing around with @Justin_Barrett’s excellent script “Parent Child tree hierarchy” (Parent Child tree hierarchy).
The output of this is a text field with any separator you like, for example:
World > UK > London > Hammersmith > Elspeth A...
If you mean the “level” eg 1 for a top level, 2 for a child, 3 for a grandchild etc - then one option I use is just taking the path field from the script above, and using a basic formula which does a count on the separator? Eg “—>” or “.” in the exam...
@Justin_Barrett This is fantastic and I've been using it for a few months as a Scripting Extension. Thank you!!Just wondered, do you think it would work as an Automation, so it triggers just for a record that was modified, rather than running through...
All,I have a similar question to the above - understand the database vs spreadsheet point but I still have a situation where the Excel Index/Match functionality comes to mind. To boil it down:Table 1: DeliveriesFields: Delivery ID (number), Postcode ...
Thanks for this script which is great. In my case I input the Parent relationship, and use the script to auto-generate the Child relationship as a separate linked field.I wondered, is there a way to use a similar technique to populate a single linked...
