Hi! Out of nowhere, my inline lists are displaying blank in my app. It was working fine, now nothing is showing. The data looks fine in the glide editor. The datasheet is a public directory I created using lookups from my business profiles sheet. Under each category, there should be an inline list. Did I do something wrong? Thanks!
Bit of an obvious question, but are the lookups working fine?
Or are you viewing as a user that doesnāt have access to that tab?
@PabloMFalero @Robert_Petitto Ah I figured it out, I added row owners to the original ābusiness profilesā sheet. Didnāt think that would carry over to the public directory since that specific column isnāt added as a lookup.
Another thing I noticed when I created a relation column for Row ID so I can have these look-ups- the first cell contains the title, instead of a dash, is that correct?
@Jen_NYCP - I believe that Iām to blame for this, for giving you bad advice, apologies.
However, I can give you a workaround that I have tested, and does work.
Essentially, do the same thing, but instead of doing the lookups in Glide, do them all in the GSheet.
So as well as an arrayformula for the RowID, do the same for each column you want to expose in your Public sheet. So it will look something like this:
The arrayformulas are in the first row, eg:
={"Row ID";ARRAYFORMULA(Users!A2:A)}
Yup thatās the way Iāve gotten around some RowID āissuesā (that arenāt really issues haha). Create a copy of the necessary columns in the GSheet and link them together using the RowIDs.
heh yeah, I had based my original advice on that thing you did with your manager/employee approvals. Iād bookmarked that post because I intend to use the same technique in one of my apps. But I hadnāt actually tested it 
Felt bad when I saw that I had led @Jen_NYCP up the garden path, so obliged to come up with a workaround. At least I know what to do in my own app now 
Ah! this might be better than having to create 30+ lookups which I had to do twice because I changed the sheet name and reloaded the sheet without knowing, so everything blanked out 
Iām afraid if I change the lookups to these array columns this I would have to re-do my components again; had to re-do when moving the synced data from the business profiles sheet to public directory sheet??
The lookups are working, but I was just wondering about that first cell, why it doesnāt have a dash like the others.
mmm, unfortunately I think you would have to, yes
That surprises me. You still have Row Owners enabled on your āPrivateā sheet, yes?
Are you saying youāre able to pull data from that sheet via lookups with Row Owners enabled and that data is publicly visible? (thatās not what I found when I tested just now - hence my workaround suggestion).
Or did you remove Row Owners?
Oh no no, I removed Row Owners, thatās why it wasnt working for a bit. The workaround will work even with row owners enabled? So far I do not have any data being pulled from that sheet so itās not being downloaded, but was thinking for future uses.
