The table NAME has a column called [Email] and there are 6 rows with data.
The display rule is:
IN(useremail(), NAME [Email])
When I test it, it only sees the first 4 emails. This rule used to work well for me before so Iโm thinking this may be a bug?
Any tips much appreciated!
Magdalena
Solved! Go to Solution.
YES! that was the mistake. The wrong column was marked as the Key. Thatโs why it was not pulling all the data.
Marc, thank you thank you thank you!
What do you mean by โdisplay ruleโ?
How are you testing it, and why do you think it only sees the first 4 emails?
I mean a display formula in a Ux view.
Iโm using the test formula function. It shows me for which emails the formula is true/false. This matches when Iโm observing when testing different email addresses.
Does that make sense?
Thank you!
Sure that makes sense. But still, why do you think it is only seeing the first 4 emails? Can you show a screenshot?
What do you see here?
Alternatively, if you just enter Users 21Q3[email]
into an expression somewhere (like a temporary VC), what is the result?
You say there are 6 emails in this Table, if the App only โseesโ 4, than I would suspect perhaps the other 2 records donโt have a valid/unique/non-blank Key value.
YES! that was the mistake. The wrong column was marked as the Key. Thatโs why it was not pulling all the data.
Marc, thank you thank you thank you!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |