The idea of the above is to return the most relevant record from airtable based on matching tags. The submission fields are iterated, passed through a match pattern to isolate just the answers, then aggregated back into an array.
The airtable module returns all (6) records, fed into a match pattern to isolate the ‘tag names (rollup)’ field and aggregated into an array for each record. The set variable module called matchcount should score the records based on how many matching tags there are between each array, but from the formulas I’ve tried it always returns 0. I’ve double checked letter case and unnecessary spaces, although the system is dynamic, the form is multi choice so there are only a set number of tags that can be used.
The aggregator takes this variable and the rest of the record information, and the following module sorts by matchcount in desc order.
Is there a simple fix?