Getting the usernames of users selected from gridField

Hi Daniel,

 

You can use the following example.

You are going to still save your Grid Selection with ids and you can use those ids as an index to retrieve the full element.

Add a test rule input as (Any Type).

 

I think there's a problem with your solution. After trying this with a handful of entries, it seems you're using the IDs you get from local.gridSelection.selected as indexes, for the index() function (I think). This doesn't always work, because the elements in the datasubset can be out of ID order, or have gaps between their IDs, so you end up getting the wrong elements in the rule input variable.

I think there's a problem with your solution. After trying this with a handful of entries, it seems you're using the IDs you get from local.gridSelection.selected as indexes, for the index() function (I think). This doesn't always work, because the elements in the datasubset can be out of ID order, or have gaps between their IDs, so you end up getting the wrong elements in the rule input variable.

Here's the solution I eventually came to. It's looks clunky, but it makes ri!test an accurate array of what you have selected.  

saveInto: {
    local!gridSelection,
    a!save(
        ri!test,
        a!forEach(
            items: local!gridSelection.selected,
            expression: with(
                local!griditemid: fv!item,
                index(
                    local!externalDataSubset.data, 
                    where(
                        a!forEach(
                            items: local!externalDataSubset.data,
                            expression: {
                                local!griditemid = index(fv!item, "id")
                            }
                        )
                    )
                )
            )
        )
    )
},

 

a!save(ri!test,
index(
local!datasubset.data,
wherecontains(
local!gridSelection.selected,
index(local!datasubset.data,"yourIDField","")
)
)
)

 

 

Your identifiers are going to be your primary key so you are finding in the data subset those indexes and you are going to save those indexes into your rule input.