Relation data not displaying

Data:

UI:

This seems painfully simple, but I can’t figure out why the data in my table doesn’t display in the UI. Well one record does.

Same no matter which user I view as in the editor.

This is a simplified screen I created to trouble shoot as this happens on a large scale: some look up cols that have data in my data source don’t show that data in the UI. Not sure I’ve seen this before.

I have a clients table with row owners. Do I need the users email address in these tables?

Currently the relation is based on client ID as some data comes from reports that are exported from another app and those reports don’t include the email address. So I’m using client ID for the relation and assumed I don’t need a row owner in the related table.

The most likely cause is Row Owners.
Just keep in mind that when Row Owners are applied to a table, then any and all unowned rows will not exist on a clients device. Which means that anything that tries to reference those rows will fail.

1 Like

thanks, strange that some data shows up even if I show the raw table data rather then the relation column, anyways, will assume it’s row owners and find a way to get emails in there.

Update: Weirdly this all started working. I deleted my troubleshooting screen, but the original screens that weren’t displaying data that was in the tables via relations now work fine. I didn’t add row owners to the related tables. Couldn’t tell you what happened :man_shrugging: