Hi, I have a query relating to the data structure:
Currently I have 2 ‘Things’ that I want to relate to each other so that I can run certain queries later.
a) ‘Chain’ which is a company that owns a number of ‘Shops’. It has a field called ‘Shops List’ which is a list of ‘Shops’ (e.g., ‘Chain’ = ‘Starbucks’ and ‘Shop’ = ‘a particular Starbucks cafe’)
b) ‘Shop’ which is a shop, store or cafe that sells various food and drink items. It has a field called ‘Member of Chain’ which is defined as type ‘Chain’
Ideally, I would like the ‘Shops List’ in a) to automatically populate as and when more ‘Shops’ are added to the database with the relevant ‘Chain’. However I don’t think this is possible at the moment (please tell me if it is), so instead I wanted to include a step in the workflow that ‘Adds’ the current ‘Shop’ to the ‘list of Shops’ under the relevant ‘Chain’. However when I try to do this (basing it on the example video although I appreciate that the example uses the list function under the ‘User’ thing which is a special type of ‘Thing’) I am unable to get it to ‘Add’ to the list. (Please see the screenshot). Perhaps because the ‘Chain’ is not the primary ‘Thing’ being updated in this workflow, it does not want to allow to ‘Add’ to a list in a secondary ‘Thing’.
Anyway, any help / tips appreciated.