Hi there - I have looked through older posts but nothing quite answers my question. The closest answer I could find (from 2019) starts with “Create a column that contains the default picture in every row” which is the part I’m struggling with. See details below:
I’m trying to set a default image in a couple of tables and have a Lookups table - basically one row with a single value for the column “ImageDefault”. I use a Lookup in another table to set the default image for each row in that table. I then have an if-then-else column which I want to use to pick up the user-defined image from another column if it exists, otherwise use the ImageDefault Lookup.
Problem is, I can’t see the ImageDefault in the if-then-else pick list so can’t build the rule. I can see the other image columns there, both of which are also lookups from other tables, but not this new ImageDefault Lookup.
Is this because I have not used the relation/lookup combination to drill into a single record? I only have one record (cell) in the Lookups table column, so haven’t done a Relationship in the other table, just a Lookup. The image the Lookup brings back appears to me like a single record (literal) and not a structure (ie. doesn’t show as a shadowed collection in the column but as a single image). But maybe your system needs a relationship/lookup? If so, can you suggest another approach because there’s no way to key into the Lookups table to set up that relationship/lookup on the other table.