I am essentially trying to build the Tags repeating group of figure 3 below.
The tag names are pulled from from figure 2.
In order to get the products count for each tag (figure 3), I do a search for Product but I am unable to filter Product by the current cell tag’s name (figure 4).
(A product may be associated with 0, 1 or more than one tag, basically a list of tags.)
Thanks for your help.
to @insightrade : I understand that by default, unique_id is the primary key of a data type.
However, since each row entry in the Tag app data has a unique name, does it matter if I set the primary key to Name ?
I think I am right in using the keyword contains since I am comparing a list of tags with a text cell value (" Current cell’s Tag Name ")
(My understanding is that I would have to use the keyword intersects in the query if I was comparing a list with another list)
The issue checker gives me the following error message : Search for Products:value should be Tag but right now it is a text.
I both do not properly understand the error message (since the Tag name is of text type) and have no idea how to convert the value to the Tag data type .