Transparency / Opacity in Format Rules

[Fabian_Weller]

You can use Hex colors with transparency / opacity in Format Rules.

This one will look like this:

If you add the Opacity value after the Hex value, it looks like this:

This is also working for Actions:

And for Map Pins:

_____

Hex Opacity Values

• 100% — FF
• 95% — F2
• 90% — E6
• 85% — D9
• 80% — CC
• 75% — BF
• 70% — B3
• 65% — A6
• 60% — 99
• 55% — 8C
• 50% — 80
• 45% — 73
• 40% — 66
• 35% — 59
• 30% — 4D
• 25% — 40
• 20% — 33
• 15% — 26
• 10% — 1A
• 5% — 0D
• 0% — 00

[Koichi_Tsuji]

Fabian, how did you find the trick, by accident?
Super awesome finding.

To Appsheet team, I think we should put this to official documentation!

[Fabian_Weller]

Thank you Koichi, I needed a Dummy Pin in a Map that should not be visible.
So I looked in google, if Hex colors are working with transparency

[Sergio_Sa]

Very, very cool.

[Grant_Stead]

Holy dope tastic!
I too need dummy pins… It seems the background XY trick you showed off really needs a starter pin to initiate the backgrounds image… Is that what you’re using this for.

[Fabian_Weller]

Yes I need the dummy Pin for a XY Background Image. After adding the first real Pin, the dummy gets deleted via an Action.

[Grant_Stead]

@Adam this is one of the issues we were emailing about. One hell of a workaround that Fabian worked out.

[Grant_Stead]

Don’t forget to put the pin back if there are no pins remaining… Like if someone deletes all the pins

[Fabian_Weller]

You are right thank you. There are always so many scenarios to consider

[Grant_Stead]

Agreed. I had considered this, and in the end decided to just leave the pin…

[Fabian_Weller]

Where do you place the Dummy Pin? 50, 50 or 0, 0 ?

I mean you could also give him an icon via Format Rules like
and assign him some infos. When the user opens the XY he can click on the INFO PIN to learn what to do next.
Just some ideas

[Grant_Stead]

I might like that idea of an info pin…
50, 50 is the best bet for now…

[Jonathon]

Fantastic

[Suvrutt_Gurjar]

Great input @Fabian.

[Lucinda_Mason]

Can this be used to set the specific color and transparency in the UX Brand: Primary Color?

That would be cool and enable me to match our corporate branding.

Lucinda

[Fabian_Weller]

Adding @nico FYI

[Fabian_Weller]

This is working also with RGB. Thanks you @tsuji_koichi

Format rule - RGBA can be used for color picker Tips & Tricks 💡

This might have been tweeted before, but let me post quickly although possible duplicates. For the color picker of format rule (not theme color), we can use HEX, but rgba color code is also working. Meaning, we are able to set the “transparency” of the color as well. Nice. [image] This generates, [image]

[Fabian_Weller]

To make something completely invisible, you can also use the word transparent instead of #000000.

Automatic star rating based on likes and dislikes Tips & Tricks 💡

Instead of making the text white you can type the word transparent which means when grouping data it wont show white text on grey background [image]

[teambelair]

Very nice. Can I do something similar for images. I have a set of records in card view and want the user to focus on a single card at a time so i m looking to grey out the other cards. I can now reduce the opacity of the text but i m interested to do that for the image too. 

Ideas? Thank you!

[teambelair]

Perfect for text but would love to have something similar for pictures. Is there any way to do that without creating another image with low opacity for every image?

[Fabian_Weller]

Sorry for the late reply @teambelair You can try using a XY column type in the card view. Because you can lighten up XY Background images.
https://www.googlecloudcommunity.com/gc/Tips-Tricks/Make-a-map-or-XY-background-image-lighter-or-dar...
You need to create or an extra child table for the XY, or you can use a self ref with a virtual column. Because you can add XY in a card only when it's a ref list.

[teambelair]

@Fabian_Weller 

I have the main table A with an image field.

Sol 1: I created a table B, with a ref to A that also contains a field XY. Does it mean I have to store the image on table A also on table B?

Sol 2: I added a self ref in the the table A. I don't see the REF_ROWS being automatically created. Also not sure how to utilize that.

I watched your video: https://www.googlecloudcommunity.com/gc/Tips-Tricks/KML-Image-Overlay-Ground-Overlay-for-Watermark-A...

I am not sure if that would work since the image I would like to make brighter dynamically is on the Card view. 

Also, would that trick work for any image size? The sizes of the uploaded images aren't the same.

Can we setup a call?

[Fabian_Weller]

Hi @teambelair I just did some testing and I'm sorry, but I'm pretty sure that this is no solution for your requirement. 

It would look like this:

The Image is a map view inside the card view. That's why you see "Google" and all that stuff.
The map view has a secondary data table. I thought with that I can define when to show the KML to brighten up the image. But that's not possible, because only the KML for the first data label is respected. So you have the KML or you don't have it. We have asked many times to make the "Optional Url for KML File" configurable. But this is still not possible.

You can have a look at my App here. It's called "Transparency".
https://www.appsheet.com/portfolio/549987

So I think you should go another way. For example you could try an image API like this one:
https://www.googlecloudcommunity.com/gc/Tips-Tricks/IMAGE-EDITING-Rotate-Crop-Resize-Mirror-Etc-Usin...

Or this one:
https://pixelixe.com/docs/image-processing/brightness-image-api.html

[aijac1314]

Wow, this is nice, thank you very much