Visibility rule using collection value

[dasuksta]

Hi Guys - kinda bamboozled here!!
I have an object that I want to show if value of X is greater than Y where the two values are stored in the same collection (as Storage Used & Quota Waring as numbers) but thats not working!

The rule works if I enter the second value manually any pointers, thanks.

[Kamal]

I tried it like this. And it works.

1. Collection with 2 number fields/properties named Storage Used & Quota Warning.
2. Add a Custom list.
3. Use conditional visibility option for a label/button or any component of that custom list liek shown in the screenshot.

I hope this is what you were aiming at.

Regards.

[dasuksta]

Hi @Kamal thanks for the reply…
Apposed to a list item I am wanting to show the user a message (see attached) and whenever I try to map the Greater Than value via the collection - just don’t wanna work!
The logic seems pretty rudimentary to me, but just can’t get it to function without adding a “Hard Value”

[Victor]

Hi @dasuksta,

That looks weird… I tried to re-create something similar based on my experiments app. Used a list of Cinemas, added Capacity and Actual properties (imagine this is nb of seats / bookings). The goal was to display warning sign if Actual > Capacity.
It worked:

[Victor]

As a crazy idea: may be you could try adding some test element (button/icon/etc) and try to change visibility of it?

Also, another idea: did you check how do you compare the numbers? I.e. in your case “warning” should be shown when storage used is over 80%, so both properties should store %% of storage used. May be you compare %% with absolute number?

[dasuksta]

Hi @Victor thanks for the update - will try your suggestions but for reference the values are absolute numbers - I am just appending the % as text to the end in the UI… My formula works out the used storage and I round it down to a simple number = ROUND((USEDBYTES / ALLOWANCEBYTES) x 100).

But will test using another UI item - like an Icon

[Kamal]

Hi @dasuksta,

I think its something to do with

1. Relationships of your collections and the properties.
2. The way you reach that screen which decides what data is pulled (to be available for use) in that screen.

Anyhow, I tried something simpler and it worked

1. In the users collection, added 2 number properties - “Storage used” and “Quota Warning”.
2. Then, the conditional visibility works on any text label or button etc. For that particular logged in user, if used storage is greater than set warning, the warnign label is seen.

I am sure you would need some relationships from anotehr collection which pulls the data of storage used, that woudl require some trial and error testing.

Alternatively, you could just display that users current storage used and display on his/her profile the total usage and give different colours if it falls above the quota warning.

Let us know, hwo you solve.

[dasuksta]

Hi @Kamalthanks for taking the time to reply
On the collection - then user click on to view their “Storage” I have an action that counts and calculates the usage of that user (based on the files owned by them) and then updates the Storage Collection. I have check this is working - and the Files count is updating the Storage collection but when using the formula as described in the UI… not so!
For now I have hard coded the values, but was hoping to to have this more dynamic so it could be managed on a per-user basis, but will re-check my relationships… As always I’ve mot likely missed something simple

[Victor]

Hi @dasuksta,

Tried with formula in my app - worked for me.
That’s mysterious… could you share the part when you set up the formula? May be via short video?

Best,
Victor

[dasuksta]

Hi @Victor
Thanks for looking at this with me, appreciate your time… sorry for the late reply, yesterday I was jammed with real world issues like "accounts’

I have uploaded an explanation video (3:36 mins) not too long

Using Table value to show element 2020 11 03 at 09 57 05

Please take a look when you can, for now I have hard coded the values - but understanding where i’ve gone wrong will really help.

[Victor]

Hi @dasuksta,

Very interesting.
And what’s inside the “Storage” table? You’re comparing that to sum of Quota Warning 1 -s, so what’s there?

Also, I assume you actually use “Storage” collection just for the clarity of DB structure, and you should never have more than 1 record for each Vendor there?

[dasuksta]

Hey @Victor
See attached the Storage collection - i’m keeping details of the allowance and used space in bytes.
Yes in storage there is only one record for each Vendor else impossible to easily determine each vendors usage.

[Victor]

Hi @dasuksta,

Then I have no idea why it’s not working

I suspect something though; sometimes when I used the functions like “Sum” in a long-long relationship (like yours), they didn’t work correctly for me, so I had to choose the other way.

As an experiment and out of curiosity, could you put a label representing this Sum of “Quota Warning 1”-s, and see what value will be displayed?

Also, the DB structure seems a bit overcomplicated, but I have to think a bit before suggesting smth.

Best,
Victor

[dasuksta]

hi @Victor thanks for taking a look, much appreciated

Ref the DB structure - the app is Multi user with Companies & Their own users… so just let the evolution of the thing dictate, but your feedback is helpful & I’ll take deeper look at the DB structure and see where i can tidy things up - thanks again

[pford]

Not sure if this has been tried yet, but could you try one (or both) of these?

1. Reset the visibility to Always visible, save it, then retry the sometimes condition formula you were using?

2. Delete the component and try setting it up again.

I’ve noticed sometimes the visibility gets hung up on past setups.

[dasuksta]

@pford I have tried re-setting the visibility, no joy!
But will try your trick of creating anew component - as these were copy n’ pasted

[pford]

Ohhhh yeah copy/paste stuff gets funked up sometimes.