# Alternatives to my ridicolous "italian" solution

**URL:** <https://community.glideapps.com/t/alternatives-to-my-ridicolous-italian-solution/10514>\
**Category:** Ask for Help\
**Created:** [June 8, 2020, 8:11am UTC](https://community.glideapps.com/t/alternatives-to-my-ridicolous-italian-solution/10514 "2020-06-08T08:11:16Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paolo\_Milanoli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paolo_milanoli/32/647_2.png) [@Paolo\_Milanoli](https://community.glideapps.com/u/Paolo_Milanoli)\
**Post date:** [June 8, 2020, 8:11am UTC](https://community.glideapps.com/t/alternatives-to-my-ridicolous-italian-solution/10514/1 "2020-06-08T08:11:16Z")

</div>

I’m a newbie, so be patient, please. 😀 🙄

1. I’ve 5 EVENTS DATES I call people to partecipate to.
2. They can CONFIRM theyr partecipation or not  
I made a tab were I can check called/confirmed people for each date  
Example: by clicking on **18/05/2020** from a list I obtain:  
jack  
John  
Paul  
Each name has a FLAG image if confirmed and a RED CROSS image if not confirmed.  
To obtain this result I’ve duplicate every name 10 times:NAME_NUMER OF EVENTS_POSSIBILITIES(confirmed/not confirmed)  
Jack 28/06/2020 confirmed img flag  
Jack 28/06/2020 not confirmed img red cross  
Jack 29/06/2020 confirmed img flag  
Jack 29/06/2020 not confirmed img red cross  
and so on…  
It works, but  
With 40 peopleI I’ve obtained almost 700 rows!! That’s, obviously ridicolous, but I can’t find another way to let a person have the FLAG in one date and the RED CROSS in another date…  
Thank you in advance for reading and help.  
Paolo

---

<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:** [June 8, 2020, 8:19am UTC](https://community.glideapps.com/t/alternatives-to-my-ridicolous-italian-solution/10514/2 "2020-06-08T08:19:26Z")

</div>

Are your Flag and Red Cross images replaceable by emoticons in Google Sheets?

---

<div class="post-metadata">

**Author:** ![Paolo\_Milanoli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paolo_milanoli/32/647_2.png) [@Paolo\_Milanoli](https://community.glideapps.com/u/Paolo_Milanoli)\
**Post date:** [June 8, 2020, 8:46am UTC](https://community.glideapps.com/t/alternatives-to-my-ridicolous-italian-solution/10514/3 "2020-06-08T08:46:03Z")

</div>

Thanks for your speed!!  
This are the imgs, but if necessary I can change them

 ![immagine](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a8e2785463779768fb86affbcaf9743352159c6d.png)

---

<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:** [June 8, 2020, 9:06am UTC](https://community.glideapps.com/t/alternatives-to-my-ridicolous-italian-solution/10514/4 "2020-06-08T09:06:28Z")

</div>

You can use icons in If \> Then \> Else columns.

Here’s my example.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9ca7395ef13a871ff05b15d418523807b869f322.png)

And a demonstration of how it works with icons.

![ezgif-3-8bda15c92fc3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/89aaca9747c0b0da6cd6aa83ef32a8ada48fb9ba.gif)

You also don’t need to make 700+ rows for it. With this if then else you can record just the “Participation?” boolean column then have an If \> Then \> Else like I do and you’re good to go.

---

<div class="post-metadata">

**Author:** ![Paolo\_Milanoli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paolo_milanoli/32/647_2.png) [@Paolo\_Milanoli](https://community.glideapps.com/u/Paolo_Milanoli)\
**Post date:** [June 8, 2020, 12:28pm UTC](https://community.glideapps.com/t/alternatives-to-my-ridicolous-italian-solution/10514/5 "2020-06-08T12:28:16Z")

</div>

This helped me very much, 1000 Thank you!  
I suppose I’ve to do an if-than-else column for each date. Correct?  
Tx, Paolo

---

<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:** [June 8, 2020, 12:54pm UTC](https://community.glideapps.com/t/alternatives-to-my-ridicolous-italian-solution/10514/6 "2020-06-08T12:54:27Z")

</div>

You would design the data as person, date, confirmation (to store the boolean), then an If \> Then \> Else column in Glide.

---

<div class="post-metadata">

**Author:** ![Paolo\_Milanoli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paolo_milanoli/32/647_2.png) [@Paolo\_Milanoli](https://community.glideapps.com/u/Paolo_Milanoli)\
**Post date:** [June 8, 2020, 9:08pm UTC](https://community.glideapps.com/t/alternatives-to-my-ridicolous-italian-solution/10514/7 "2020-06-08T21:08:56Z")

</div>

Thanks again for your help. Now everything seems ok!
