I am in the process of migrating from Notion to Xano. It's not straightforward and there's not much documentation around, unlike, say, migrating from Notion to Airtable. So it's a constant process of frustration going through the steps to recreate what was very simple to do in Notion.
I am struggling to recreate the connection between two different tables: Companies and Sectors:https://files-us-east-1.t-cdn.net/files/W3MvIRasoZ3bTb4X5eCE2
As you can see, I eventually worked out how to split out (in the Companies table) the "Sectors" text field into an array - "Sectors Array". But what I would really like to do is to split the "Sectors" text field out into an array which refers to the Sectors table's "Sectors" field - I have created a table reference field for this purpose.
That way, when companies are added in future, the sector can be looked up in the Sectors table, in order to ensure consistency.
I have been attempting to do this in the function stack:
This video has been my guide to some extent https://www.youtube.com/watch?v=hulHk9v3Phk
but it does not explain how to match either comma separated values in a text field or in an array (in my Companies table) with the Sectors field in the Sectors table.
I am guessing that I need to use Find All Elements rather than Find First Element, but I am reaching the end of my knowledge.
Can the community please point me in the right direction? Thank you!