# Structuring CRM databases for the prospect journey on mobile

**URL:** <https://community.glideapps.com/t/structuring-crm-databases-for-the-prospect-journey-on-mobile/48719>\
**Category:** Ask for Help\
**Created:** [September 6, 2022, 7:26pm UTC](https://community.glideapps.com/t/structuring-crm-databases-for-the-prospect-journey-on-mobile/48719 "2022-09-06T19:26:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![justin\_m](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/justin_m/32/45432_2.png) [@justin\_m](https://community.glideapps.com/u/justin_m)\
**Post date:** [September 6, 2022, 7:26pm UTC](https://community.glideapps.com/t/structuring-crm-databases-for-the-prospect-journey-on-mobile/48719/1 "2022-09-06T19:26:54Z")

</div>

Hi Gliders,

I’m prototyping a new CRM tool as an internal tool. I"m struggling a bit with the database structure and I would love some tips.

I get updates to a Google Sheet with new leads as they come in. I’m trying to turn that into an app so I can better track their prospect journey across the whole team.

I’d like to have a tab in the app for:

1. Each new prospect on the sheet
2. Which prospects are top priorities by labeling them as _hot, warm, cold, dead_
3. What offering each prospect is looking for

I assume that I want to edit the prospect journey in Tab #1 but it doesn’t seem to be allowing me to edit there.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 7, 2022, 12:53am UTC](https://community.glideapps.com/t/structuring-crm-databases-for-the-prospect-journey-on-mobile/48719/2 "2022-09-07T00:53:30Z")

</div>

So you have leads combined all in a Sheet? I think you can have a single tab to show all of them, then:

- Add a column to label the prospect
- Add an If-Then-Else column to convert the label to a sortable number. Say hot = 4, warm = 3, cold = 2, dead =1
- Sort the inline list on the tab by that number, desccendingly
- Other info can go into each details view of the propsects

---

<div class="post-metadata">

**Author:** ![justin\_m](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/justin_m/32/45432_2.png) [@justin\_m](https://community.glideapps.com/u/justin_m)\
**Post date:** [September 7, 2022, 8:36pm UTC](https://community.glideapps.com/t/structuring-crm-databases-for-the-prospect-journey-on-mobile/48719/3 "2022-09-07T20:36:20Z")

</div>

I’m going to try this out! Thank you.