codefordenver / partner-finder

Using an open dataset with registered colorado business to build a tool that manages outreach to potential CFD partners.
3 stars 14 forks source link

Replace Contact field with Email #182

Closed galbwe closed 3 years ago

galbwe commented 3 years ago

We have a "Contact" column in the table on the home page, but we do not have contact information for any rows:

select count(*) from leads where contact_name is not null;

-[ RECORD 1 ]
count | 0

However, we have email addresses that are not being used in the table

select count(*) from leads where email is not null;

-[ RECORD 1 ]
count | 758

Replace the "Contact" column with "Email".

Screen Shot 2021-10-14 at 7 57 31 AM

Include a link in each row with href="mailto..." that includes the provided email address. The email address can be accessed by the email property of the leads object.

If no email address is available for a lead, display nothing in the email column for that row.

If you want to be super fancy, use an icon instead of email text. The Email icon from the MaterialUI docs seems like a good candidate.

Safwan310 commented 3 years ago

Hey, can I do this?

galbwe commented 3 years ago

Sure @Safwan310 ! I'll assign you.