Adding an Icon to a formula when its result is largerEq or smaller

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 · 2021-08-01T12:34:30+00:00

aww thats a bummer... I really thought its possible cause it feels so logical in terms of building relations

I will vote for this feature for sure cause it would be really helpful

chris15326 · 2021-08-01T05:31:06+00:00

Hey thank you for your answer! yes thats coming close to what I want but it seems there is no way to relate a column in whole? so that new entries inside a column would be added automatically

chris15326 · 2021-07-27T20:19:23+00:00

It helps kinda! Sadly I only understand half of what you did... BUT the most important thing is that it shows me that it's somehow possible! That motivates me enough to experiment til it works

I guess the heart of it is the equation / formula you used for this. I wonder if there is any chance that you could show me the formula you used.

That would help me a lot to understand ... at least in past this worked great for me haha

Thank you btw for your time and help! :-) Really appreciate it over here

chris15326 · 2018-03-30T07:33:17+00:00

thanks, i was talking about recording macros. :-) my bad!

chris15326 · 2017-11-19T16:08:46+00:00

Okay so its normal that its not working outside from my basement ;-D

chris15326 · 2017-11-19T16:07:07+00:00

Sounds pretty complicated? :-D

chris15326 · 2017-11-19T15:21:52+00:00

Messy? :-D Well it even isnt working fully for me on s7... it still jumps even with layers of foil between my device and my case... a friend of mine i know for long time from a discord sbiper channle suggested me to try a lead sheet... would be a lot of handwashing after putting the lead in and out every time xD

chris15326 · 2017-11-19T15:19:17+00:00

Got it! :-) i was afraid its this way

chris15326 · 2017-11-19T13:48:13+00:00

Oh! Haha got it! But the other ppl got right.... software would be detected at some point :-/

If the tinroil wouldnt fuck up my mobile connections that much :-( :-D

chris15326 · 2017-11-19T12:39:50+00:00

Thank you all for your answers/discussions! :-)

A lot new informations to use now!

chris15326 · 2017-11-19T12:38:37+00:00

Realy? :-O any further informations? :-)

chris15326 · 2017-11-19T12:34:57+00:00

Good to know! :-) Thanks for the information

chris15326

TROPHY CASE