Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Moving raw prospect data to a Contact list to a client list

Topic Labels: Base design
Solved
Jump to Solution
582 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m a freelance writer. Here’s my overall goal for Airtable:
Collect raw data by which to cold contact companies >
Make contact with said companies and move data to a Contact list >
Work contact list until a contact becomes a client >
Store dynamic information on all client activity such as first and subsequent project briefings and timelines; planned delivery dates; payments and all that jazz.

I want to be able to reference raw data from the prospecting list across all tables as they narrow down from uncontacted Prospect to Contacted to Client. I was hoping to set the actions so that all the raw information in a single Prospect record could be linked or maybe automatically transferred to the Contact list once the “Status” field is updated to “Contacted”. Then, once a single contact record is updated to “Client” by check box field, it would transfer to the Client list without dragging all the raw data with it, just keeping linked to it. Does this make sense? If this is possible, how should I go about it?

Thank you!

1 Solution

Accepted Solutions

Hi Linda,

I would create a table to track your list of Contacts and their corresponding Pipeline Stage:

image

Then create multiple views that filter based on the Pipeline Stage:

image

This is an example of an Uncontacted Prospects view:

image

Keep track of your Notes in a different table that links to your Contacts table:

image

Same with Dates:

image

And Payments:

image

What do you think? Will that work?

Cheers,
Gwynn

See Solution in Thread

2 Replies 2

Hi Linda,

I would create a table to track your list of Contacts and their corresponding Pipeline Stage:

image

Then create multiple views that filter based on the Pipeline Stage:

image

This is an example of an Uncontacted Prospects view:

image

Keep track of your Notes in a different table that links to your Contacts table:

image

Same with Dates:

image

And Payments:

image

What do you think? Will that work?

Cheers,
Gwynn

Yes, Gwynn, I think you broke through my mental block. Thank you!