# No Favorites Text **URL:** \ **Category:** Ask for Help\ **Created:** [March 22, 2021, 2:13am UTC](https://community.glideapps.com/t/no-favorites-text/24569 "2021-03-22T02:13:52Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 22, 2021, 2:13am UTC](https://community.glideapps.com/t/no-favorites-text/24569/1 "2021-03-22T02:13:52Z")
I have a favorites tab within my app. If a user has yet to favorite an item, I would like to display text that says they have not favorited anything yet. I’m stuck on visibility since the text component is using the favorites sheet, which essentially just has headers (title and subtitle) and as a placeholder for the tab. My question is how to bring over the favorite data to this sheet when there isn’t any data within it. ---
**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:** [March 22, 2021, 3:30am UTC](https://community.glideapps.com/t/no-favorites-text/24569/2 "2021-03-22T03:30:28Z")
I believe you can use a rollup pointing to the “is Favorited” column and set to count true. If rollup is 0 then you display the text. Also, you should have a seed column with a value in there to generate a row for the rollup to populate. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 29, 2021, 9:22pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/3 "2021-03-29T21:22:19Z")
Thanks! What’s a seed column? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 29, 2021, 9:38pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/4 "2021-03-29T21:38:09Z")
This is what I created, but the correct number is 6 not 13. I figured out why, it’s counting old events as well. I have two sheets for favorites (business and events) so I created two roll-ups. The events rollup however will also have to take the date into account, not sure if that’s possible. ![favapp](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/34277b7ed095e8a2c9a9cb37f1edfbb6cef38348.png) ---
**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:** [March 29, 2021, 11:05pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/5 "2021-03-29T23:05:24Z")
A seed column contains a placeholder value so that Glide can actually generate a value for computed columns, it can be anything you want. For the date problem, create an If Then Else column in your events Sheet, if date is before today then false, else true. Create a template column combining the favorite column and the ITE column above with the format “value1 - value2”, pointing to the correct columns. Then in your Favorites sheet, create a template column with the value “true - true”, make a relation from this template column to the template column in the Events sheet. A rollup on top of that relation will return the correct count. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 29, 2021, 11:13pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/6 "2021-03-29T23:13:38Z")
> [@ThinhDinh](#): > > Then in your Favorites sheet, create a template column with the value “true - true”, Thanks! This should have which values in its place? ---
**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:** [March 29, 2021, 11:14pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/7 "2021-03-29T23:14:53Z")
No, that shouldn’t have any values. It’s the “correct” text to use in the relation. You only need to replace the template column in the Events sheet. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 29, 2021, 11:27pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/8 "2021-03-29T23:27:03Z")
So like this with no replacements? ![roll1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/7/e7e706f20eb7b373a2fe4ea1530d36de6434c702.png) ---
**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:** [March 29, 2021, 11:27pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/9 "2021-03-29T23:27:48Z")
Yes that’s true. Please mind the format of the template column when you do it in the Events sheet (it should be value1-value2 without any spaces like what you do in the screenshot above). ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 29, 2021, 11:30pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/10 "2021-03-29T23:30:57Z")
ok thanks! I did the relation after this with the templates from the event sheet and favorite sheet and it produced the title of one of events in a single cell. ---
**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:** [March 30, 2021, 12:58am UTC](https://community.glideapps.com/t/no-favorites-text/24569/11 "2021-03-30T00:58:03Z")
> [@Jen\_NYCP](#): > > it produced the title of one of events in a single cell. Do you mean this in a relation column? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 30, 2021, 12:59am UTC](https://community.glideapps.com/t/no-favorites-text/24569/12 "2021-03-30T00:59:52Z")
Yes ---
**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:** [March 30, 2021, 4:39am UTC](https://community.glideapps.com/t/no-favorites-text/24569/13 "2021-03-30T04:39:38Z")
> [@User\_relation using first name, not email?](https://community.glideapps.com/t/user-relation-using-first-name-not-email/24853/6): > > The relation can be seen as a door to open the path between the two Sheets you’re linking above. The visual presentation there shows that there’s one row or multiple rows found according to your Settings, and it would take a random column in the destination sheet to show on the screen. The actual value you can use, let’s say for displaying, is through a lookup/single value column on top of the relation. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 30, 2021, 5:29am UTC](https://community.glideapps.com/t/no-favorites-text/24569/14 "2021-03-30T05:29:00Z")
Ok, so I need to create a lookup? I have the following: ![roll12](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e40514cdc185e84aea8a72f3bddfe2339b1b5827.png) ![roll123](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e7a540942299694863eecf1258ca379563ffa81.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 30, 2021, 5:55am UTC](https://community.glideapps.com/t/no-favorites-text/24569/15 "2021-03-30T05:55:16Z")
That’s a single relation, so doing a rollup count will always return 1. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 30, 2021, 1:07pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/16 "2021-03-30T13:07:54Z")
Should I check off match multiple? ---
**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:** [March 30, 2021, 1:21pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/17 "2021-03-30T13:21:18Z")
Yes, if you need data from multiple rows. - Check multiple if you want a relation to potentially find multiple matches. Even if it finds one match now, it could find and return multiple matches in the future. - Leave it as single if you want a relation to only ever find one match. If there is only one match, then it will find it. If there are multiple matches, then it will still only return the first match. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 30, 2021, 1:36pm UTC](https://community.glideapps.com/t/no-favorites-text/24569/18 "2021-03-30T13:36:52Z")
I see. thanks! The rollup is still 1 however, even though I see there are multple relations. Ok I think I see, it should be rollup on the same relation then point back to the favorites column in the events sheet? Does this also count favorites without an end date? Some do not have an end date, but they were favorited.