Color Type data column: which html code insert in ...

FaCe · 06-12-2023 02:20 PM

Hi,

i've a color type data column with these 4 colors.

Which html code i've to insert in Email Body html to show exactly these "balls" instead of words red, green, blue, yellow ...

WillowMobileSys

Probably the best way to make sure you are getting the exact same matching color is to use a Color Picker tool. These tools can inspect the web page area you specify and return the HEX code for that color.

I believe there are a come as a Google extension.

Suvrutt_Gurjar

You could also explore using emojis in email body template.

FaCe

Great idea,

how i can add this emoji 🟡 in this body template:

<<Start: PASSATI[ID]>>
<<[CHECK]>> - <<[DATA]>>
<<[EVENTO]>>
<<End>>

Suvrutt_Gurjar

Which is the color type column in the above expression you mentioned?

FaCe

[CHECK] and i would like to pass 2 colors yellow and green ...

For one color i'm trying with:

<<Start: SELECT(PASSATI[ID], [CHECK] = "Yellow")>>
<<🟡>> - <<[DATA]>>
<<[EVENTO]>>
<<End>>

but it doesn't work

Task 'Invia email' Body template. Expression '🟡' is invalid due to: Expression refers to undefined field.

Suvrutt_Gurjar

Please try

<<Start: PASSATI[ID]>>
<<SWITCH([CHECK], "Green" , 🟢, "Yellow", 🟡, 🔵) >> - <<[DATA]>>
<<[EVENTO]>>
<<End>>

FaCe

Great, but the email include all these 3 colors, green, yellow and blue (btw why blue has not the word "Blue" also ?

Actually i've green, red, yellow and blue, if i want to extract ONLY green and red how to achieve this result ?

I'm reading Switch()

https://support.google.com/appsheet/answer/10107700?hl=en

Suvrutt_Gurjar

Pleaee share the column type and values of [Check]

Does it have one value at a time.

Please share the results from the email also.

FaCe

Please see below:

Suvrutt_Gurjar

Okay, thank you. What kind of issue the email body result is giving.

FaCe

The email send all my records (with four colors)

<<Start: PASSATI[ID]>>
<<SWITCH([CHECK], "Green" , 🟢, "Yellow", 🟡, "Red", 🔴, 🔵) >> <<[DATA]>>
<<[EVENTO]>>
<<End>>

I'd like to show ONLY 2 or 3 of them ...

Suvrutt_Gurjar

Oops. Not sure why it should be. Are you able to share how the email body of the email generated looks by sharing a screenshot. Of course , please do not share any sensitive data such as email ID etc.

FaCe

Here it is (i delete sensitive data).

As you can see are passed all the colors (there's also red, but i extract only a part of the file).

Yes it's really odd ...

Suvrutt_Gurjar

Thank you. Okay.

Now I get it. I believe the result is as expexted and not odd. At a time the color column will have any one value for a record and the color related to that record's color column value is getting displayed.

Even in app's detail or summary views, the color column displays only one value that is selected out of multiple options in form view.

My solution was to display the column value color value ( one for one record) of each record through emoji.

Could you elaboarare what you are expecting? We could possibly show more emojis but then how the email reader know the actual status? Because emojis do not have a tick mark etc. to indicate selection.

FaCe

Hi,

i'd like to send email only for the records in PASSATI slice view that has one or more colors (i.e. all records with red, green and blue "balls" in check column)

Suvrutt_Gurjar

Thank you but I do not understand. For that requirement you could create a slice based on color column status.

Also initially you mentioned only green and yellow colors.

Now you mention red, green and blue.

Could you finalize your requirement.

FaCe

Hi,

yes i could create for sure a slice based on color column status.

In another part of the App i've this email body and it extract only a specific value of the column (in this case the name "ELISABETTA"):

<<Start: SELECT(SCADENZA OGGI[ID],IN("ELISABETTA",[ASSEGNATA]))>>
<<[CATEGORIA]>> - <<[ATTIVITA']>>
<<[DETTAGLI]>>
<<End>>

Why i cannot do the same for my case (select only some color) and need to create 4 specific slides one for each column ?

Yes you're right about the difference between colors.

I just want to understand how to achieve a result taking some colors (don't care about which color is).

Thanks a lot for your help!

Suvrutt_Gurjar

@FaCe wrote:

Why i cannot do the same for my case (select only some color) and need to create 4 specific slides one for each column ?

Sorry, I do not understand this requirement. What do you mean by slide? What do you mean by " one for each column?"

@FaCe wrote:

it extract only a specific value of the column (in this case the name "ELISABETTA"):

What do you mean by specific value? What is the column type [ELISABETTA]? What are its possible values?

I think in general, you have got the idea , how one can use emojis usefully for color columns.

Suvrutt_Gurjar

By the way, is your requirement to just show the color status in the email body for user to see the report kind of document

OR

Do you wish the color type column to be editable by the user from the email body like an enum button?

FaCe

@Suvrutt_Gurjar wrote:
By the way, is your requirement to just show the color status in the email body for user to see the report kind of document

This is ok for now ...

FaCe

@Suvrutt_Gurjar wrote:
What do you mean by specific value? What is the column type [ELISABETTA]? What are its possible values?

This is a Column Type Text have some names in it

Color Type data column: which html code insert in email body of a bot (that sends email) ?