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 pl…

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.

Thanks! What’s a seed column?

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. [fav…

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 f…

[image] ThinhDinh: Then in your Favorites sheet, create a template column with the value “true - true”, Thanks! This should have which values in its place?

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.

So like this with no replacements? [roll1]

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).

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.

[image] Jen_NYCP: it produced the title of one of events in a single cell. Do you mean this in a relation column?

No Favorites Text

Ask for Help

ThinhDinh March 30, 2021, 4:39am 13

Topic		Replies	Views
If the favorites screen is blank Ask for Help	7	224	September 23, 2021
How best to do a User Favorite Column in Pages with changing data Ask for Help	7	638	March 7, 2022
Counting number of "Likes" Ask for Help	2	501	June 17, 2021
Count Participants for an event Conference Template Ask for Help	1	192	September 20, 2022
Is there a way to count favourites?- Solved Ask for Help	13	1536	February 7, 2021

No Favorites Text

Related topics