I know it’s a long-shot, but is there a native way to populate (some of) an Item’s columns based on a Dropdown selection with the source of said column data being another Item with a matching Dropdown (with one other column condition thrown in to distinguish in the case of multiple Items with the same Dropdown selection)?
For context, the Items here are version updates of various records (with unique record ID’s - hence the Dropdown) and many of the column entries for the most recent prior update (‘date published’ etc.) are repeated in the subsequent update entry.