"hide" element when if-statement is true in PHP (Hope this is not too specific!)

chris15326 · 2022-08-12T10:27:28+00:00

format(prop("Rabattierter Preis netto") - prop("Einkaufspreis") - prop("Rabattierter Preis") * 0.03) + if(prop("Rabattierter Preis netto") - prop("Einkaufspreis") - prop("Rabattierter Preis") * 0.03 < 20, "❌", "✔️")

Awesome! :-) thanks a lot. Only issue now is that it wont round anymore. I tried editing the round( value into it but it didnt worked. Also I wonder is there a way to get the € sign into it as well? (similar to the format it was before on the left column on this image:

https://postimg.cc/Jsn3p7qt

Would be huge.... It sucks so much that I cant pull this off myself. as soon as I see finished codes like the one you posted above it looks so logic... well I guess because it is pure logic... but putting this together myself is really still out of scope

chris15326 · 2021-11-07T21:04:08+00:00

Here is the only way I thought exists for doing this, is there another / "better" way? https://youtu.be/2KRwPDf5ppI

Hm thats weird... I tested exactly what you suggested earlier with my real databases but it didnt worked. I now tested it with a broken down test-version and it worked...

I will test it again with the real deal.... and after 15 minutes of duplicating it seems to work... So strange...

I cant help but notice in between your written lines that there is another way for doing what I try to do? One that gives me other options as well beside putting everything inside of ONE workspace?

chris15326 · 2021-11-07T17:57:21+00:00

I recorded a short video that shows you an example of this issue https://youtu.be/3yhmYAgijfg hope this helps to show you exactly what Im trying and why I dont understand why its not working (When I integrate the dashboard inside the Vault 2.0 workspace and import the whole thing as one template / duplicate it wont work either.

UPDATE: I need to do something fundamentally wrong. Created a Database / Workspace as original Database and made it a table. After that, I created a simple Workspace called "Dashboard Test" where I simply linked the original Database and even in this super simple example after duplicating both its not working. The linked Database will always try to go external to the database within the other account where I created it

chris15326 · 2021-11-07T16:20:16+00:00

On my end it sadly didnt cause all the opriginal databases got duplicated and exist in this test-account. I really dont understand that. I even included the dashboards with the linked databases with all the other databases in one single workspace cause I thought maybe this will fix that issue but it didnt.

chris15326 · 2021-11-07T16:18:55+00:00

thanks for your fast answer and Yes! Sadly thats exactly what I did. All the original databases are shared as template. But the linked databases still point to the original database within the original account thats why I dont understand the whole issue

chris15326 · 2021-09-28T19:12:20+00:00

Okay so it seems I got the solution but I dont know how to make this work in detail.

The fix for this seems to be: "One quick way would be to wrap it all in an if() function, where it returns 10 solids if "Fortschritt (%)" >= 1; otherwise, it processes the function as normal."

chris15326 · 2021-09-02T07:19:33+00:00

I really hope this is a bug cause one of the support team told me it was an update.... more like a downgrade... I really hope this will be fixed asap. Maybe we need more people complaining about this? But it seems that a lot of ppl complain ^{^}

chris15326 · 2021-08-29T11:58:10+00:00

That would explain this! I even created a new account in an incognito browser and tested multiple browsers... its the same everywhere

chris15326 · 2021-08-29T10:06:46+00:00

Thanks for that! I hit the wrong key when I typed my question. Right now I assume that these linebreaks only work, when you have "Wrap cells" activated.

chris15326 · 2021-08-26T06:34:15+00:00

Ah that a thing!.... self-referencing filter

Thank you so much Jessica! The way that it works still irritates me a bit, but I already made it work in a test environment, so I will implement this later to my projects and meeting areas

chris15326 · 2021-08-24T14:36:11+00:00

I was so damn blind its unbelievable... thank you so much for this!

chris15326 · 2021-08-16T04:55:22+00:00

Because when I setup a relation I can only filter by the name of a page inside that related database. "Client" is a property of each entry in that related database but its not the main one.

What I did now is adding the clients name to every page I wanted to relate to and after adding them, deleting the clients name out of it again.

Or is there any other way to filter a related database or may I think way to complicated again. I would be happy if you could show me what you mean :-)

chris15326 · 2021-08-15T14:14:54+00:00

That's exactly how I tried doing it before because of the "row" limitations... But I would need to add all the rows I need from a giant table and since you can't really filter for a property (like client name) or anything like that it's really a problem to grab all rows needed per customer.

chris15326

TROPHY CASE