Any way to create a relation between the App:Comments sheet and another?

I’d love to be able to display the number of comments that a specific ‘topic’ has associated with it! Given that, is there any way to create a relation between the App:Comments sheet and another?

1 Like

I never tried, but I assume you could create a column in GSheets with a Vlookup…

I think the easiest way to do this is to create a copy of the App:comments sheet using an array formula in another sheet. This way, Glide will see this new sheet and you’ll be able to reference it in your app.

2 Likes

Yes thank you! I was just poking around on other similar threads and found this solution. Note to others this will eat into the number of columns you app can use.

But here’s the exact array formula that works:
=ARRAYFORMULA(IF(‘App: Comments’!A1:F="","",‘App: Comments’!A1:F))

Source:

Thanks @Darren_Murphy

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.