Yellow triangle warning

[casitasrd]

I have a column that auto computes with a formula that references from a table. The information is pulling correct, but still get the Yellow triangle warning and no reference to the table.

[casitasrd · Accepted solution]

I noticed that both formulas where giving me the same result but somehow now this one is working, it doesn't make any sense but... yea

[dbaum]

That icon can mean that the current user does not have access to the data (in another table's row) that is being referenced by the key value that was previously populated in the row currently being viewed.

[casitasrd]

@dbaum Thanks for your fast response. My user does have access as I am the only one creating this app and I have access to everything.

[casitasrd]

When i make it a type text column with the formula to compute the value, the triangle goes away:

Then i get the reference arrow:

If I click the reference arrow above, it goes to a blank detail view

This is what i see in the view ref system generated for that arrow:

[Gonzague_Issen1]

Thanks @dbaum , there is ample discussion about the yellow triangle meaning a broken link or the reference to a column other than a key, but you are the first to point out that it can also mean an issue with access to the row: that was my problem because of I created a security filter!

Thanks again

[casitasrd · Accepted solution]

I noticed that both formulas where giving me the same result but somehow now this one is working, it doesn't make any sense but... yea

[dbaum]

A Ref type column’s values must always be from the key column of the referenced table, even though AppSheet helpfully displays to users the referenced table’s label column values. 

[casitasrd]

@dbaum thanks for telling me. Right now I'm working on the same issue Yellow Triangle in a ref column which filters by another column. Maybe you can give me an idea of where to look. 

[Suvrutt_Gurjar]

Solved: Yellow Warning Triangle - Google Cloud Community

Please see the above post.

[casitasrd]

@Suvrutt_Gurjar I've already read this, not much help from this thread. Steve link is not longer there and I haven't change any key, ID or deleted any parent or child record.

[dbaum]

---

@casitasrd wrote:

Steve link is not longer there

---

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?q=yellow%20triangle 

[casitasrd · Accepted solution]

Used this formula and it works now. Thanks everyone for your help. At the end it's all about making sure you compare from ID to ID when referring from one table to the other. Thanks @dbaum and @Suvrutt_Gurjar  for always been there and trying to help.