I need to make a condition for an action that takes the user to a certain view to complete info for certain rows if at least one of them is blank.
Iโm stuck thinking about this.
SELECT()
might help but I want to keep it simple.
This didnโt work:
COUNT([CMVINV_Inline][ID_INVITEMS])<>COUNT([CMVINV_Inline][PRECIO_U])
CMVINV_Inline
has the list of values to check. List column type
[ID_INVITEMS]
is the Key column.
[PRECIO_U]
is the column that canโt be blank
The condition is for an action that shouldnโt be enabled if there is no blank field inside [CMINV_Inline][PRECIO_U]
This should be very simple but Iโm smashing my head against the wall with this.
I count on you guys
Solved! Go to Solution.
Woohoo!
This is the one
COUNT(
INTERSECT(
[CMVINV_Inline][PRECIO_U],
LIST("")
)
)<>0
As soon as I add a value inside the last row that was blank, the action dissapears. If I remove the content of any of the rows, leaving it blank, the action come back!
That was a lot of formulas to find the right way
Thanks @Steve and @tsuji_koichi for your valuable time!
COUNT([CMVINV_Inline][ID_INVITEMS])=COUNT([CMVINV_Inline][PRECIO_U]-LIST(""))
What about this ?
Thanks!
This did the trick:
COUNT([CMVINV_Inline][ID_INVITEMS])=COUNT([CMVINV_Inline][PRECIO_U]-LIST(""))
Since I want it to return true if there is any column left, I needed to check if [CMVINV_Inline][PRECIO_U]
minus the blank ones is the same as the count of the ID.
Your tip worked like charm!
PS: Can you change your expression from <>
to =
so that I can mark yours as the solution?
Great to hear it was solved. Correction is made.
Iโm very sorry @tsuji_koichi but I jumped too soon!
Itโs not working as expected. Neither <>
or =
Now, credits to you because the expression that you wrote first with <>
was right, it just didnโt work.
^ My bad. If I substract the blank ones from the [PRICE_U] list, itโs COUNT()
should be the same as the one for the keys. So if both COUNT()
are the same, there is no blank values, and I need the opposite.
Iโm sorry again and Iโm still working on this
Some hours ago Im have such problem with "blank"s.
Min() ddnt understand them.
But Im solved my trouble by incrementing all values by 1
Is that help you?
Yeah, itโs a little bit problematic
COUNT([CMVINV_Inline][PRECIO_U])
counts the number of fields, eventhough they are blankCOUNT([CMVINV_Inline][PRECIO_U]-LIST(""))
counts 0. Thatโs OK but it also counts just the unique values, just like if it where COUNT(UNIQUE([CMVINV_Inline][PRECIO_U]-LIST("")))
. So if [CMVINV_Inline][PRECIO_U]
is {1, 1, , 12} ; COUNT()
=2COUNT(UNIQUE([CMVINV_Inline][PRECIO_U]-LIST("")))
COUNT([CMVINV_Inline][PRECIO_U]-LIST(""))`
Above two expression should be equivalent in theory.
Itโs working like that.
But I donโt need to count just the unique values, I need every field, it shouldnโt matter if one value is more than once in the list
Iโm under โLegacyโ on Data โ Options โ Expression
Iโm gonna check if โConsistentโ helps
Yes thats the point of the check.
Otherwise maybe it is an idea that you add the virtual column to refernced table, with expression
IF(ISNOTBLANK([PRECIO_U]),1,0), named it [CountCheck]
Then alter expression to
COUNT([CMVINV_Inline][ID_INVITEMS])=SUM([CountCheck])
COUNT([CMVINV_Inline][ID_INVITEMS])<>SUM([CountCheck])
either way to fit your requirement as alternative workaround?
@tsuji_koichi
I though about that but itโll be very messy with a lot of VC after a while
Right now I have 70 rows where each one of them has the [CMVINV_Inline]
field with between 2 to 20~ rows.
So that would be 140 to 1400 AppFormulas
Try:
ISNOTBLANK(
SELECT(
[CMVINV_Inline][_ROWNUMBER],
ISBLANK([PRECIO_U])
)
)
Interesting.
On the editor Test shows it working as I want it to work.
Y
when there is at least one field blank, N
when there arenโt.
On the App it seems like itโs always N
Woohoo!
This is the one
COUNT(
INTERSECT(
[CMVINV_Inline][PRECIO_U],
LIST("")
)
)<>0
As soon as I add a value inside the last row that was blank, the action dissapears. If I remove the content of any of the rows, leaving it blank, the action come back!
That was a lot of formulas to find the right way
Thanks @Steve and @tsuji_koichi for your valuable time!
User | Count |
---|---|
43 | |
29 | |
29 | |
14 | |
14 |