Source of Lead Icon in sample app

[rjtroy]

I have a trivial question. I have been working my way through some sample apps including the LEAD TRACKING sample app. Link as follows:

https://www.appsheet.com/Template/AppDef?appName=Lead_Tracking-2059583&quickStart=False#Data.Tables

Question:
I notice that all app records display a [Lead Icon] field but I can’t locate the source of this field in the views.

Solutions would be appreciated.

Dick

[Steve]

In the table view configuration, go to the View Options section:

[rjtroy]

Steve,

Thank you for your prompt reply.
I have followed your instructions but I only get two options: None or Lead Icon

This Shows or Hides the Icon which works - thank you.
Where is the configuration of Lead Icon that selects the Initials?

[Steve]

Ah, you specifically want the initials. For that, you’ll need to add a(n optionally virtual) column of type Image with an App formula expression that uses the TEXT_ICON() and INITIALS() functions, like this:

TEXT_ICON(INITIALS([Lead Name]))

See also:

help.appsheet.com

INITIALS()

First character of each word

help.appsheet.com

TEXT_ICON()

Icon from text

[rjtroy]

Steve,

Your previous help was much appreciated. Opened up days of study and research but very satisfying…
Can I now prevail on you to facilitate my next breakthrough?

My current AppSheet design is per the link below
I have authorized this User [appsheet@discoursemail.com] - hopefully, to enable you to launch my AppSheet design

• site https://www.appsheet.com/Template/AppDef?appName=DLR_AppSheet_VX-2059583&quickStart=False#Users.Allo...
  Achievements to date

• My App is up and running and invaluable for contacting MEMBERS - on the beat - via PHONE, EMAIL, TEXT MESSAGE.
  Next objective

• When sending emails, I would like to incorporate a Gmail Template highlighting the latest customized promotional data.

• Even better if I could select from say three separate email templates at the push of the button.
  Map Problem

• Map pinning the member address is a huge benefit. But for some reason, it seems to be temperamental. .

• All the Addresses in the ADDRESS column work perfectly when fed into Google Maps. Perhaps is that I have 30,000 members? Try this out for yourself.
  Thanks, Steve in anticipation.

Dick

[Steve]

rjtroy:

When sending emails, I would like to incorporate a Gmail Template highlighting the latest customized promotional data.

Not possible.

rjtroy:

Even better if I could select from say three separate email templates at the push of the button.

Not possible.

rjtroy:

All the Addresses in the ADDRESS column work perfectly when fed into Google Maps. Perhaps is that I have 30,000 members?

Yep. Way too many for the app to handle.

[rjtroy]

Thanks for your help.
Back to the drawing board