Broken references for no reason

[Emilian_Bem]

Hi, I have a big problem. Overnight, the reference stopped working for only a few records. I checked if the key was spelled correctly, but also in table A and in table B it was written correctly. The relationship between these tables is extremely simple. Table A is the items, and table B is the results of the checks performed on these items. So one item can have multiple controls. I do not know where to look for the cause of this phenomenon. I will mention that the databases are created in the google sheet. I don’t have any column formatting turned on and all filters are turned off.

I urgently need help! Thank you in advance

[Steve]

How are the broken references evident? Can you provide a screenshot?

[Emilian_Bem]

“Sorry, there was an error uploading that file. Please try again.”. Is there any other place or mail where I can send screens?

[Aleksi]

Have you tried to just copy & paste the screenshot?

[Emilian_Bem1]

The problem with adding photos is on my side. I add them from another account because I do not have such a possibility from that account.

here are examples of broken references:
Sorry the data is so truncated but it is sensitive data and I cannot share it.

in table A and in table B the values are identical (I searched them using ctrl + F). Additionally, I made sure there were no whitespace there.

[Aleksi]

If you checked that your values on a parent and child tables are correct, please open those records and reselect the value from the Ref field. Also please check if you are able to see the same option twice in your dropdown.

[Emilian_Bem]

I deleted the ref field type in child tabale and again chose ref pointing to parent table, but unfortunately for a few records the reference still does not work and I only see one “ref” option in the dropdown menu.

[Aleksi]

Are you using Ref field or Enum (or EnumList) with a Ref as a base type?

[Emilian_Bem]

In parent table, the column I refer to is of the text type and is a key by the way. In turn child tables, this column with the same name is simply ref type in which it points to parent table. Did I understand your question correctly?

[Aleksi]

Okay it’s a Ref field, not Enum etc. Did you reselect the parent for those childs already?

[Emilian_Bem]

yes i did it, however it changed nothing. I also tried to regenerate the parent and child structures. Because I’ve seen you mention it in other posts about broken references. However, that didn’t help either.

[Aleksi]

Would you please email to support@appsheet.com with your app details, so I can find it from your app. Please tag my name, so I can pick it, thanks.

[Emilian_Bem]

Of course I will write! Thank you very much for help. Can you just specify what you mean by the app detals? What data should I include in the email?

[Aleksi]

Account ID number
App name
Table&Column name
Probably view name as well
Steps that I need to take, so I’m able to see that issue from the app itself (emulator).

[Emilian_Bem]

okay thanks for the info

[Aleksi · Accepted solution]

For others… the reason was a security filter in the Parents table. If the parent doesn’t exist, the Child record can’t find the parent and the link will be broken.

[Emilian_Bem]

Thank you very much for your time and help