# 🎤 We'll Do It Live - Episode 5

**URL:** <https://community.glideapps.com/t/well-do-it-live-episode-5/29002>\
**Category:** General\
**Created:** [July 12, 2021, 2:10pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002 "2021-07-12T14:10:36Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\
**Post date:** [July 12, 2021, 5:01pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/21 "2021-07-12T17:01:53Z")

</div>

Creating a new column : A/Content3 should be placed right after A/Content2 iso B/Content2.

A/content A/content2 B/Content B/Content2

Hope you’ve got what I mean 🙂

---

<div class="post-metadata">

**Author:** ![mmgt2005](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mmgt2005/32/965_2.png) [@mmgt2005](https://community.glideapps.com/u/mmgt2005)\
**Post date:** [July 12, 2021, 5:10pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/22 "2021-07-12T17:10:24Z")

</div>

Turn on the discount/coupon field in the Stripe checkout screen  
@Mark Is this possible?

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [July 12, 2021, 5:24pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/23 "2021-07-12T17:24:47Z")

</div>

One thing I noticed from the last session ---- I think @Jason increased the time delay for notifications and adjusted their width for longer messages. This is great, but I think the notification box should disappear if someone interacts with another part of the app while the message is displayed. I’m finding that the message is sticking around while I’m able to navigate elsewhere in the app.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 12, 2021, 5:31pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/24 "2021-07-12T17:31:52Z")

</div>

Nice! Been saving this list since the last session:  
@Mark @Jason @Tristan

- Increment over relation
- Add/Remove conditions without exiting interface (as requested in the past two We’ll Do It Live sessions)
- Icon Favorites Section (ability to favorite icons or see recents)
- Inline Lookups ([as requested here](https://community.glideapps.com/t/select-values-from-relations-just-like-user-inline-lookups/26092))
- Option to make User Profile Screen a “bottom tab” ([like this](https://community.glideapps.com/t/beautiful-design-app/16191/616))
- Friendly Date Format for date/time and Math columns (eg “x hours/days ago”)
- Titles need actions!
- A third Choice Component Style to look like navigation menu ([like this](https://community.glideapps.com/t/beautiful-design-app/16191/670))

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [July 12, 2021, 6:09pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/25 "2021-07-12T18:09:22Z")

</div>

Very simple feature to have a condition to change user profile photo

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [July 12, 2021, 6:45pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/26 "2021-07-12T18:45:04Z")

</div>

> [@Yasin\_Hassanien](#):
>
> Very simple feature to have a condition to change user profile photo

You mean to have a condition to allow/disallow changing it?

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [July 12, 2021, 7:06pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/27 "2021-07-12T19:06:21Z")

</div>

@Mark Yup, because sometimes we create dual apps and we importrange the user table in Gsheet and sometimes the users upload and they simple miss the importrange formula

We managed to have a workaround to catch their details and zapier it to the source sheet

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [July 12, 2021, 8:53pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/28 "2021-07-12T20:53:04Z")

</div>

Clear whole column values 🙈

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [July 12, 2021, 9:39pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/29 "2021-07-12T21:39:11Z")

</div>

Yes please!!!  
+1

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [July 13, 2021, 7:21am UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/30 "2021-07-13T07:21:47Z")

</div>

So much needed

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 13, 2021, 10:20am UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/31 "2021-07-13T10:20:20Z")

</div>

@mark one thing I would _really_ love is the ability to sort a joined list (I’m pretty sure I’ve asked for this before).

Use case: I build a lot of CSS/HTML tables using relations and joined lists. The results are great, but the one annoyance is that there is no way to sort the rows, and so I wind up with apparently randomly ordered tables. Here is an example:

 ![Screen Shot 2021-07-13 at 5.35.31 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/54d2442856b82b9789f796c802299bb54926e371.png)

In the above example, the table rows are formed by a joined list of template columns. What I’d love to be able to do is specify an “Order By” column when configuring the joined list column.

I hope this makes sense.  
PS. I’m pretty sure @Jeff_Hager would also like to see this one 😉

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [July 13, 2021, 10:32am UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/32 "2021-07-13T10:32:05Z")

</div>

> [@Darren\_Murphy](#):
>
> une chose que j’aimerais _vraiment,_ c’est la possibilité de trier une liste jointe (je suis presque sûr d’avoir déjà demandé cela).

It’s so simple in Yes-Code, but that’s another story 🙂

---

<div class="post-metadata">

**Author:** ![Shiv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shiv/32/25831_2.png) [@Shiv](https://community.glideapps.com/u/Shiv)\
**Post date:** [July 13, 2021, 10:33am UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/33 "2021-07-13T10:33:27Z")

</div>

Just coming back to add one more (not sure someone has/had asked for it in past).

- Multi item select in a choice component.

-Shiv

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [July 13, 2021, 12:41pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/34 "2021-07-13T12:41:09Z")

</div>

An easy one…a counter column !!

---

<div class="post-metadata">

**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\
**Post date:** [July 13, 2021, 1:00pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/35 "2021-07-13T13:00:13Z")

</div>

Allow us to configure “on submit” for the “back” button of a “details” screen. First use that comes to mind is “if order is empty, delete row”… I’m sure there could be just as many uses as the current “on submit” confit.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 13, 2021, 1:05pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/36 "2021-07-13T13:05:01Z")

</div>

Yes! Just like…ahem…conditional relations… sometimes I need to perform some logic within the data before it even makes it to the app’s front end, which is currently the only place where we can filter and sort data. In situations that I’ve ran into, sorting and filtering on the front end is too late. It needs to happen in the data because it affects the results of other computed columns. In my case, I have to use either additional google sheet tabs with queried data, or in one case, an entirely separate Google spreadsheet with import range formulas to move data back and forth between spreadsheets to offload calculations and return results that I couldn’t handle efficienctly in the app’s spreadsheet…and this actually speeds up my app…

I’m so used to working with SQL directly against a DB, or Linq style queries against data tables. Shoot, even old school key lists against physical and logical files on ibm mainframes allow for rudimentary sorting and filtering of data before working with it.

I’ve just been waiting patiently and checking staging periodically in the hopes that a feature like this comes along, 😉 but I imagine it’s maybe a little more than a quick change.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 13, 2021, 1:10pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/37 "2021-07-13T13:10:26Z")

</div>

hehe, conditional relations… but, look at how much fun it is without them!

 ![Screen Shot 2021-07-13 at 9.08.51 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/1853f5946126995e73fbde838adfd746c4411b13.png)

🤣

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 13, 2021, 1:39pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/38 "2021-07-13T13:39:00Z")

</div>

Until you need to create a relation where the source row has a date, and you want to find related rows based on a key, and that also have a date prior to that source date. Then rollup a sum from that relation. Currently impossible within glide, unless you want to create the most horrendous array that includes your main key values and a date as an array for every possible date you hope to relate to (imagine an array of 180 or 365 items, just to check for every possible match within 6 to 12 months…and then dynamically build that for each relation source row based on it’s own date). Glide relations can’t handle data where you need to search by a range. In SQL this would be simple with a JOIN and a ‘WHERE rel\_date\<src\_date’.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 13, 2021, 1:50pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/39 "2021-07-13T13:50:13Z")

</div>

Yes! Actions for:

- Back button
- Buy Button
- Title component

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [July 13, 2021, 1:55pm UTC](https://community.glideapps.com/t/well-do-it-live-episode-5/29002/40 "2021-07-13T13:55:53Z")

</div>

> [@Shiv](#):
>
> Multi item select in a choice component.

Would be the dream… but not sure that it’s an easy piece of work for a “live session”.

[Previous page](https://community.glideapps.com/t/well-do-it-live-episode-5/29002.md?page=1)

[Next page](https://community.glideapps.com/t/well-do-it-live-episode-5/29002.md?page=3)
