I have a control record where I get the current date using a MATH column.
Then I do some other columns to whittle it down to just the Month and Day (think of a birthday which repeats every year, so the year is not significant), then I set up a relation between that day and a Trimmed Lowercase field in my list of “Feasts”. The relation seems to work.
Then I set up some columns in my user table, because that table seems to be able to be referenced everywhere (unlike my Control Table). That gives me my Feast ID. So far so good.
But when I go to the Feast table, any attempt to user the Feast ID in the user table (while it seems to work in the table itself), does not seem to work in the Filter or “visible” for the tab kind of tests. You can see “user feast relation” is “not empty” in one record, but no records show up in my list when I reference “not empty” on that column. I am actually going to have that a detail screen, but used a list for illustration purposes.
This may seem to be a convoluted way to get here, but I had originally tried just matching my Trim LC Date column with the Trim LC Date column in my user record, and that didn’t give a match either, so that’s when I started setting up relations to see if I could work around that. The two dates obviously “match”. “january 24” in the feasts table and “january 24” in the users table. Is there some issue with the fact that it comes from a math column and not a text column? That’s why I thought I could work around it by using relations.
Why the control record? I figured it would be faster (if I have 3000 users) to do all the computed columns in one row and use the final results in my user table rather than have all the computed columns on every user row. That’s just my way of thinking because I don’t know if Glide only does the computed columns for the currently logged in user, or for all users in the table (like I see in my editor).
However, the results (or lack of results) are the same if I move all the computed columns to the user table – it still does not “match” correctly or filter correctly.