[Launch impacting] Relationship column in Sheet not being recognised

Report a Bug
1

My app’s URL: https://go.glideapps.com/app/AKFCLjDSVh31tZd7HouK

Sheet ‘Profiles’
Has a column ‘Initiatives3=Initiatives:Creator:Multiple’

Sheet ‘Initiatives’
Has a column ‘CreatorRelationship=Profiles:Email’

Profiles.Initiatives3 column will not be recognised by Glide when reloading.

If I change ‘Profiles’ column to ‘Initiatives=TestInitiatives:Creator:Multiple’,
with a test sheet ‘TestInitiatives’, it is recognised.

I create a copy of ‘Initiatives’ sheet as ‘Initiatives2’,
and added to ‘Profiles’ sheet column ‘Initiatives1=Initiatives2:Creator:Multiple’,
and that is recognised.

Glide is getting confused with reference to the original ‘Initiatives’ sheet

2

Have you considered setting up the relations in the glide data editor? It’s a lot less confusing.

3

Yes, but since your User model doesn’t support non editors vs editors permissions (which I will file a different Feature Suggestion about),
I have to create two apps with same Sheet, and wanted the data model in the sheet.

4

You can currently set editing permissions by user, but if you want to stick with 2 apps, is it getting confused because one column is CreatorRelationship and you are referring to it as Creator?

5

Do you support an app that doesn’t require Sign In,
but limit Add to a signed in user?

6

I already have a column in the ‘Initiatives’ sheet = ‘Creator’
CreatorRelationship was used to avoid name duplicates.
I have other mapped columns with arbitrary names that work fine.

7

I don’t…

Neither does Glide as far as I know.

8

That’s why I need two apps

9

Might need some screenshots of your headings to better understand.

10

It’s a bug.
I’ll leave Glide to have a look at it.

11

Update:
Added an ‘Profiles’.‘Initiatives’ relation column via the Data editor for now so I can launch

12

Could you share the sheet with me in a PM, please?

13

Done. Thanks.

14

A bug indeed. It’ll be fixed by Tuesday at the latest. Thank you for reporting!

1 Like